private static PermitFormScreenDesignTemplateDetailBE ToPermitFormScreenDesignTemplateDetailBE(SqlDataReader rdr) { PermitFormScreenDesignTemplateDetailBE o = new PermitFormScreenDesignTemplateDetailBE(); o.FormID = Functions.ToInt(rdr["FormID"]); o.Field = Functions.ToInt(rdr["Field"]); o.FieldName = Functions.TrimRight(rdr["FieldName"]); o.FieldType = (FormFieldType)Functions.ToInt(rdr["FieldType"]); o.Section = Functions.TrimRight(rdr["Section"]); o.Sequence = Functions.ToInt(rdr["Sequence"]); o.SectionDescription = Functions.TrimRight(rdr["SectionDescription"]); o.SectionSequence = Functions.ToInt(rdr["SectionSequence"]); return o; }
public static bool AddPermitFormScreenDesignTemplateDetail(PermitFormScreenDesignTemplateDetailBE o) { bool success = false; using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_PermitFormScreenDesignTemplateDetail_Add", conn); cmd.CommandType = CommandType.StoredProcedure; BusinessEntityHelper.ReplaceNullProperties<PermitFormScreenDesignTemplateDetailBE>(o); FromPermitFormScreenDesignTemplateDetailBE(ref cmd, o); cmd.ExecuteNonQuery(); success = true; } return success; }
public static PermitFormScreenDesignTemplateDetailBE FetchPermitFormScreenDesignTemplateDetail(int formId, int field) { PermitFormScreenDesignTemplateDetailBE o = null; using (SqlConnection conn = new SqlConnection(_connectionstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("usp_PermitFormScreenDesignTemplateDetail_Fetch", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("FormID", formId); cmd.Parameters.AddWithValue("Field", field); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) o = ToPermitFormScreenDesignTemplateDetailBE(reader); } } return o; }
private static void FromPermitFormScreenDesignTemplateDetailBE(ref SqlCommand cmd, PermitFormScreenDesignTemplateDetailBE o) { cmd.Parameters.AddWithValue("FormID", o.FormID); cmd.Parameters.AddWithValue("FieldName", o.FieldName); cmd.Parameters.AddWithValue("FieldType", (int)o.FieldType); cmd.Parameters.AddWithValue("Section", o.Section); cmd.Parameters.AddWithValue("Sequence", o.Sequence); }