public static bool Insert_Customer(CustomerVM model, string dealerCode, ref string msg)
{
string csgNo;
try
{
if (model.CusCode == "" || model.CusCode == null)
{
strAutoCode = sysfun.GetNewMaxID("Customer", "CusCode", 8, dealerCode);
string sql = "Select NTNno from Customer where DealerCode='" + dealerCode + "'";
dt = sysfun.GetData(sql, "BMS0517ConnectionString");
if (NTNno == model.NTNno)
{
msg = "This Record Can't Be Edit or Save. . .! NTNno Should be Unique NTNno.";
return(false);
}
string sql1 = "Select CellNo from Customer where DealerCode='" + dealerCode + "'";
dt = sysfun.GetData(sql1, "BMS0517ConnectionString");
if (dt.Rows.Count > 0)
{
CellNo = dt.Rows[0]["CellNo"].ToString();
// Delflag = dt.Rows[0]["DelFalg"].ToString();
if (CellNo == model.CellNo)
{
msg = "This Record Can't Be Edit or Save. . .! CellNo Should be Unique CellNo.";
return(false);
}
}
}
else
{
strAutoCode = model.CusCode;
}
if (model.CSGNo == null)
{
csgNo = sysfun.CustomerAutoGen("Customer", "CSGNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
}
else
{
csgNo = model.CSGNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@CusCode", strAutoCode), //1
new SqlParameter("@CusDesc", model.CusDesc), //2
new SqlParameter("@FatherHusName", (object)DBNull.Value), //3
new SqlParameter("@Address1", model.Address1), //4
new SqlParameter("@Address2", (object)DBNull.Value), //5
new SqlParameter("@Address3", (object)DBNull.Value), //6
new SqlParameter("@ContPerson", model.ContPerson), //7
new SqlParameter("@CreditDays", model.CreditDays), //8
new SqlParameter("@CreditLimit", model.CreditLimit), //9
new SqlParameter("@NIC", model.NIC), //10
new SqlParameter("@CusTypeCode", model.CusTypeCode), //11
new SqlParameter("@DOB", (object)DBNull.Value), //12
new SqlParameter("@Phone1", model.Phone1), //13
new SqlParameter("@Phone2", model.Phone2), //14
new SqlParameter("@CellNo", model.CellNo), //15
new SqlParameter("@FaxNo", model.FaxNo), //16
new SqlParameter("@Email", model.Email), //17
new SqlParameter("@URL", model.URL), //18
new SqlParameter("@NTNno", model.NTNno), //19
new SqlParameter("@AdvanceReceipt", (object)DBNull.Value), //20
new SqlParameter("@UpdUser", AuthBase.UserId), //21
new SqlParameter("@UpdTerm", General.CurrentIP), //22
new SqlParameter("@SalesTaxRegNo", model.SalesTaxRegNo), //23
new SqlParameter("@Behavior", (object)DBNull.Value), //24
new SqlParameter("@Remarks", (object)DBNull.Value), //25
new SqlParameter("@Distance", model.Distance), //26
new SqlParameter("@CountryCode", model.CountryCode), //27
new SqlParameter("@CityCode", model.CityCode), //28
new SqlParameter("@StateCode", model.StateCode), //29
new SqlParameter("@Title", model.Title), //30
new SqlParameter("@CSGNo", csgNo), //31
new SqlParameter("@MCNo", model.MCNo), //32
new SqlParameter("@AccountCode", model.AccountCode) // 33
};
if (sysfun.ExecuteSP_NonQuery("sp_Insert_Customer", param))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw;
}
return(IsSaved);
}
public static bool Insert_Customer(CustomerVM model, string dealerCode)
{
string csgNo;
try
{
if (model.CusCode == "" || model.CusCode == null)
{
strAutoCode = sysfun.GetNewMaxID("Customer", "CusCode", 8, dealerCode);
}
else
{
strAutoCode = model.CusCode;
}
if (model.CSGNo == null)
{
csgNo = sysfun.CustomerAutoGen("Customer", "CSGNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
}
else
{
csgNo = model.CSGNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@CusCode", strAutoCode), //1
new SqlParameter("@CusDesc", model.CusDesc), //2
new SqlParameter("@FatherHusName", model.FatherHusName), //3
new SqlParameter("@Address1", model.Address1), //4
new SqlParameter("@Address2", (object)DBNull.Value), //5
new SqlParameter("@Address3", (object)DBNull.Value), //6
new SqlParameter("@ContPerson", model.ContPerson), //7
new SqlParameter("@CreditDays", model.CreditDays), //8
new SqlParameter("@CreditLimit", model.CreditLimit), //9
new SqlParameter("@NIC", model.NIC), //10
new SqlParameter("@CusTypeCode", model.CusTypeCode), //11
new SqlParameter("@DOB", (object)DBNull.Value), //12
new SqlParameter("@Phone1", model.Phone1), //13
new SqlParameter("@Phone2", model.Phone2), //14
new SqlParameter("@CellNo", model.CellNo), //15
new SqlParameter("@FaxNo", model.FaxNo), //16
new SqlParameter("@Email", model.Email), //17
new SqlParameter("@URL", model.URL), //18
new SqlParameter("@NTNno", model.NTNno), //19
new SqlParameter("@AdvanceReceipt", (object)DBNull.Value), //20
new SqlParameter("@UpdUser", AuthBase.UserId), //21
new SqlParameter("@UpdTerm", General.CurrentIP), //22
new SqlParameter("@SalesTaxRegNo", model.SalesTaxRegNo), //23
new SqlParameter("@Behavior", (object)DBNull.Value), //24
new SqlParameter("@Remarks", (object)DBNull.Value), //25
new SqlParameter("@Distance", model.Distance), //26
new SqlParameter("@CountryCode", model.CountryCode), //27
new SqlParameter("@CityCode", model.CityCode), //28
new SqlParameter("@StateCode", model.StateCode), //29
new SqlParameter("@Title", model.Title), //30
new SqlParameter("@CSGNo", csgNo), //31
new SqlParameter("@MCNo", model.MCNo), //32
new SqlParameter("@AccountCode", model.AccountCode), //33
new SqlParameter("@Source", "Sale") // 34
};
if (sysfun.ExecuteSP_NonQuery("sp_Insert_Customer", param))
{
IsSaved = true;
}
}
catch (Exception ex)
{
throw;
}
return(IsSaved);
}