/branches/V4-3-RC/Templates/CSLA40DAL/CSharp/DataPortalDelete_DalObject.asp
# · ASP · 134 lines · 130 code · 4 blank · 0 comment · 22 complexity · 766f6645aff13769bc7ad6a1fdaf53d0 MD5 · raw file
- <%
- if (Info.GenerateDataPortalDelete)
- {
- foreach (Criteria c in Info.CriteriaObjects)
- {
- if (c.DeleteOptions.DataPortal)
- {
- if (isFirstMethod)
- isFirstMethod = false;
- else
- Response.Write(Environment.NewLine);
-
- if (usesDTO)
- {
- %>
- /// <summary>
- /// Deletes the <%= Info.ObjectName %> object from database.
- /// </summary>
- <%
- if (c.Properties.Count > 1)
- {
- foreach (Property prop in c.Properties)
- {
- string param = FormatCamel(prop.Name);
- %>
- /// <param name="<%= param %>">The <%= param %> parameter of the <%= Info.ObjectName %> to delete.</param>
- <%
- }
- }
- else if (c.Properties.Count > 0)
- {
- %>
- /// <param name="<%= c.Properties.Count > 1 ? "crit" : HookSingleCriteria(c, "crit") %>">The delete criteria.</param>
- <%
- }
- if (c.Properties.Count > 1)
- {
- %>
- public void Delete(<%= ReceiveMultipleCriteria(c) %>)
- <%
- }
- else
- {
- %>
- public void Delete(<%= ReceiveSingleCriteria(c, "crit") %>)
- <%
- }
- }
- else
- {
- string strDeleteCritParams = string.Empty;
- string strDeleteComment = string.Empty;
- bool deleteIsFirst = true;
-
- for (int i = 0; i < c.Properties.Count; i++)
- {
- if (!deleteIsFirst)
- strDeleteCritParams += ", ";
- else
- deleteIsFirst = false;
-
- TypeCodeEx propType = c.Properties[i].PropertyType;
-
- strDeleteCritParams += string.Concat(GetDataTypeGeneric(c.Properties[i], propType), " ", FormatCamel(c.Properties[i].Name));
- strDeleteComment += "/// <param name=\"" + FormatCamel(c.Properties[i].Name) + "\">The " + CslaGenerator.Metadata.PropertyHelper.SplitOnCaps(c.Properties[i].Name) + ".</param>" + System.Environment.NewLine + new string(' ', 8);
- }
- %>
- /// <summary>
- /// Deletes the <%= Info.ObjectName %> object from database.
- /// </summary>
- <%= strDeleteComment %>public void Delete(<%= strDeleteCritParams %>)
- <%
- }
- %>
- {
- <%= GetConnection(Info, false) %>
- {
- <%= GetCommand(Info, c.DeleteOptions.ProcedureName) %>
- {
- <%
- if (Info.CommandTimeout != string.Empty)
- {
- %>
- cmd.CommandTimeout = <%= Info.CommandTimeout %>;
- <%
- }
- %>
- cmd.CommandType = CommandType.StoredProcedure;
- <%
- foreach (CriteriaProperty p in c.Properties)
- {
- if (!usesDTO)
- {
- %>
- cmd.Parameters.AddWithValue("@<%= p.ParameterName %>", <%= GetParameterSet(Info, p, false, true) %><%= (p.PropertyType == TypeCodeEx.SmartDate ? ".DBValue" : "") %>).DbType = DbType.<%= TypeHelper.GetDbType(p.PropertyType) %>;
- <%
- }
- else
- {
- if (c.Properties.Count > 1)
- {
- %>
- cmd.Parameters.AddWithValue("@<%= p.ParameterName %>", <%= GetParameterSet(p, false, false, false) %><%= (p.PropertyType == TypeCodeEx.SmartDate ? ".DBValue" : "") %>).DbType = DbType.<%= TypeHelper.GetDbType(p.PropertyType) %>;
- <%
- }
- else
- {
- %>
- cmd.Parameters.AddWithValue("@<%= p.ParameterName %>", <%= AssignSingleCriteria(c, "crit") %><%= (p.PropertyType == TypeCodeEx.SmartDate ? ".DBValue" : "") %>).DbType = DbType.<%= TypeHelper.GetDbType(p.PropertyType) %>;
- <%
- }
- }
- }
- string hookArgs = string.Empty;
- if (c.Properties.Count > 1)
- {
- hookArgs = ", crit";
- }
- else if (c.Properties.Count > 0)
- {
- hookArgs = ", " + HookSingleCriteria(c, "crit");
- }
- %>
- var rowsAffected = cmd.ExecuteNonQuery();
- if (rowsAffected == 0)
- throw new DataNotFoundException("<%= Info.ObjectName %>");
- }
- }
- }
- <%
- }
- }
- }
- %>