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);
}
