public static bool AddPermitFormScreenDesignTemplate(PermitFormScreenDesignTemplateBE o, out int id)
{
bool success = false;
id = 0;
using (SqlConnection conn = new SqlConnection(_connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("usp_PermitFormScreenDesignTemplate_Add", conn);
cmd.CommandType = CommandType.StoredProcedure;
BusinessEntityHelper.ReplaceNullProperties<PermitFormScreenDesignTemplateBE>(o);
FromPermitFormScreenDesignTemplateBE(ref cmd, o);
cmd.Parameters.Add("ErrorOccured", SqlDbType.Bit);
cmd.Parameters["ErrorOccured"].Direction = ParameterDirection.Output;
cmd.Parameters["FormID"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["ErrorOccured"].Value != DBNull.Value)
{
success = Convert.ToBoolean(cmd.Parameters["ErrorOccured"].Value);
}
if (cmd.Parameters["FormID"].Value != DBNull.Value)
{
id = Convert.ToInt32(cmd.Parameters["FormID"].Value);
}
}
return success;
}
public static void UpdateDigitalSignature(DigitalSignatureBE o)
{
using (SqlConnection conn = new SqlConnection(_connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
BusinessEntityHelper.ReplaceNullProperties<DigitalSignatureBE>(o);
FromDigitalSignatureBE(ref cmd, o);
cmd.Parameters.AddWithValue("LastUpdatedDate", DateTime.Now);
cmd.ExecuteNonQuery();
}
}
public static bool UpdateTemplateFormSection(TemplateFormSectionBE o)
{
bool success = false;
using (SqlConnection conn = new SqlConnection(_connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("usp_TemplateFormSection_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
BusinessEntityHelper.ReplaceNullProperties<TemplateFormSectionBE>(o);
FromTemplateFormSection(ref cmd, o);
cmd.ExecuteNonQuery();
success = true;
}
return success;
}
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 void AddDigitalSignature(DigitalSignatureBE o, out int createdSurrogate)
{
createdSurrogate = 0;
using (SqlConnection conn = new SqlConnection(_connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("usp_DigitalSignature_Add", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Surrogate", SqlDbType.Int, 8).Direction = ParameterDirection.Output;
BusinessEntityHelper.ReplaceNullProperties<DigitalSignatureBE>(o);
FromDigitalSignatureBE(ref cmd, o);
cmd.ExecuteNonQuery();
if (cmd.Parameters["Surrogate"].Value != DBNull.Value)
{
createdSurrogate = Convert.ToInt32(cmd.Parameters["Surrogate"].Value);
}
}
}
public static bool SaveTemplateFormFieldData(TemplateFormFieldDataBE o)
{
bool success = false;
using (SqlConnection conn = new SqlConnection(_connectionstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("usp_TemplateFormFieldData_Update", conn);
cmd.CommandType = CommandType.StoredProcedure;
BusinessEntityHelper.ReplaceNullProperties<TemplateFormFieldDataBE>(o);
FromTemplateFormFieldDataBE(ref cmd, o);
cmd.Parameters.Add("ErrorOccured", SqlDbType.Bit);
cmd.Parameters["ErrorOccured"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["ErrorOccured"].Value != DBNull.Value)
{
success = Convert.ToBoolean(cmd.Parameters["ErrorOccured"].Value);
}
}
return success;
}
