public static string CreateContractForm(ContractForm contractForm, QueryHelper qh)
{
var head =
new[]
{
ContractForm.User_ID, ContractForm.CUSTOMER_ID, ContractForm.AGREEMENT_NO,
ContractForm.EFFECTIVE_DATE, ContractForm.EXPIRY_DATE, ContractForm.TOTAL_CONTRACT_AMT,
ContractForm.CONTRACT_TYPE_ID,ContractForm.REMARK, ContractForm.STATUS_FLG
}.ToList();
var data = new[]
{
new[]
{
contractForm.UserId.ToString(),contractForm.CustomerId.ToString(),contractForm.AgreementNo,
contractForm.EffectiveDate.ToUniversalTime().ToString("yyyy-MM-dd H:mm:ss"), contractForm.ExpiryDate.ToUniversalTime().ToString("yyyy-MM-dd H:mm:ss"), contractForm.TotalContractAmt.ToString(),
contractForm.ContractTypeId.ToString(),contractForm.Remarks,contractForm.StatusFlg.ToString()
}.ToList()
}.ToList();
if (!string.IsNullOrWhiteSpace(contractForm.id.ToString()))
{
head.Add(ContractForm.DB_ID);
data[0].Add(contractForm.id.ToString());
}
var query = QueryHelper.BuildBulkInsertQuery(ContractForm.DB_TABLE_NAME, head, data, true, ContractForm.DB_ID);
return qh.QueryInsertUpdateDelete(query).ToString();
}
public static string ModifyContractFormWithId(string contract_id, ContractForm contractForm, QueryHelper qh)
{
var head =
new[]
{
ContractForm.User_ID, ContractForm.CUSTOMER_ID, ContractForm.AGREEMENT_NO,
ContractForm.EFFECTIVE_DATE, ContractForm.EXPIRY_DATE, ContractForm.TOTAL_CONTRACT_AMT,
ContractForm.CONTRACT_TYPE_ID,ContractForm.REMARK, ContractForm.STATUS_FLG
}.ToList();
var data = new[]
{
contractForm.UserId.ToString(),contractForm.CustomerId.ToString(),contractForm.AgreementNo,
contractForm.EffectiveDate.ToUniversalTime().ToString("yyyy-MM-dd H:mm:ss"), contractForm.ExpiryDate.ToUniversalTime().ToString("yyyy-MM-dd H:mm:ss"), contractForm.TotalContractAmt.ToString(),
contractForm.ContractTypeId.ToString(),contractForm.Remarks,contractForm.StatusFlg.ToString()
}.ToList();
var query = QueryHelper.BuildUpdateQuery(ContractForm.DB_TABLE_NAME,
head,
data,
new[] { ContractForm.DB_ID }.ToList(),
new[] { contract_id }.ToList());
return qh.QueryInsertUpdateDelete(query).ToString();
}