public static string Insert_CrdSIMasterData(VehicleSaleMasterVM model, AccountTransactionVM AccountModel)
{
string leadid = "";
SysFunction sys = new SysFunction();
if (model.TransCode == "" || model.TransCode == "0" || model.TransCode == null)
{
string getNextTransCode = "declare @lastval varchar(14),@id int " +
"set @id = (select count(*) from VehicleSaleMaster) " +
"set @id=@id+1 " +
"if len(@id) = 1 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00000' " +
"if len(@id) = 2 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0000' " +
"if len(@id) = 3 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'000' " +
"if len(@id) >= 4 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00' " +
"if len(@id) >= 5 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0' " +
"declare @i varchar(14) " +
"set @i = CAST(@id as varchar(14)) " +
"set @lastval = @lastval+@i " +
"select @lastval as TransCode";
dt = DataAccess.getDataTableByQuery(getNextTransCode, nullSqlParam, General.GetBMSConString());
strAutoCode = dt.Rows[0]["TransCode"].ToString();
}
else
{
strAutoCode = model.TransCode;;
}
try
{
//var Serializer = new JavaScriptSerializer();
string transType = "CrdSI";
string delflag = "N";
string dealerCode = "MCM01";
DateTime UniDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DateTime UniTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
string txt = model.TransDate;
//DateTime leadDate = DateTime.ParseExact(model.TransDate,"MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@TransCode", strAutoCode), //2
new SqlParameter("@TransDate", sys.SaveDate(txt)), //3
new SqlParameter("@TransType", transType), //4
new SqlParameter("@SaleType", model.SaleType), //5
new SqlParameter("@CreditTerms", model.CreditTerms), //6
new SqlParameter("@EmpCode", model.EmpCode), //7
new SqlParameter("@CusCode", model.CusCode), //8
new SqlParameter("@CustomerType", model.CustomerType), //9
new SqlParameter("@CNICNTN", model.CNICNTN), //10
new SqlParameter("@ContactNo", model.ContactNo), //11
new SqlParameter("@PriceLevel", model.PriceLevel), //12
new SqlParameter("@BillTo", model.BillTo), //13
new SqlParameter("@ShipTo", model.ShipTo), //14
new SqlParameter("@SameAs", model.SameAs), //15
new SqlParameter("@TotalQty", model.TotalQty), //16
new SqlParameter("@ServceQty", model.TotalQty), //17
new SqlParameter("@TotalAmount", model.TotalAmount), //18
new SqlParameter("@PaymentReceiptCode", (object)DBNull.Value), //19
new SqlParameter("@PaidAmoun", (object)DBNull.Value), //20
new SqlParameter("@DelFlag", delflag), //21
new SqlParameter("@RefType", model.RefType), //22
new SqlParameter("@RefDocumentNo", model.RefDocumentNo), //23
new SqlParameter("@PostFlag", (object)DBNull.Value), //24
new SqlParameter("@VoucherNo", (object)DBNull.Value), //25
new SqlParameter("@VoucherDate", (object)DBNull.Value), //26
new SqlParameter("@UpdUser", AuthBase.UserId), //27
new SqlParameter("@UpdDate", UniDate), //28
new SqlParameter("@UpdTime", UniTime), //29
new SqlParameter("@UpdTerm", General.CurrentIP), //30
};
dt = DataAccess.getDataTable("SP_Insert_VehicleSaleMaster", sqlParam, General.GetBMSConString());
if (dt.Rows.Count > 0)
{
}
leadid = strAutoCode;
IsSaved = true;
}
catch (Exception ex)
{
//throw;
}
//-------------------------Account Transaction----------------------------------
string ActAutoCode;
if (AccountModel.TransactionCode == "" || AccountModel.TransactionCode == "0" || AccountModel.TransactionCode == null)
{
string getNextTransCode = "declare @lastval varchar(14),@id int " +
"set @id = (select count(*) from AccountTransaction) " +
"set @id=@id+1 " +
"if len(@id) = 1 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00000' " +
"if len(@id) = 2 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0000' " +
"if len(@id) = 3 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'000' " +
"if len(@id) >= 4 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00' " +
"if len(@id) >= 5 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0' " +
"declare @i varchar(14) " +
"set @i = CAST(@id as varchar(14)) " +
"set @lastval = @lastval+@i " +
"select @lastval as TransactionCode";
dt = DataAccess.getDataTableByQuery(getNextTransCode, nullSqlParam, General.GetBMSConString());
ActAutoCode = dt.Rows[0]["TransactionCode"].ToString();
}
else
{
ActAutoCode = AccountModel.TransactionCode;;
}
try
{
//var Serializer = new JavaScriptSerializer();
string delflag = "N";
string dealerCode = "MCM01";
string TrType = "CrdSI";
int Credit = 0;
string Narration = " Credit Sale Invoice ";
//DateTime CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DateTime CreateTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
DateTime CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
//DateTime leadDate = DateTime.ParseExact(AccountModel.TransactionDate,"MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", dealerCode), //0
//new SqlParameter("@ID",),//2
new SqlParameter("@TransactionCode", ActAutoCode), //3
new SqlParameter("@TransactionDate", CreateDate), //4
new SqlParameter("@CusCode", model.CusCode), //5
new SqlParameter("@AccountCode", model.CusCode), //6
new SqlParameter("@InvType", TrType), //7
new SqlParameter("@TrType", TrType), //8
new SqlParameter("@Narration", Narration), //9
new SqlParameter("@Reference", model.RefDocumentNo), //10
new SqlParameter("@Debit", model.TotalAmount), //11
new SqlParameter("@Credit", Credit), //12
new SqlParameter("@Balance", model.TotalAmount), //13
new SqlParameter("@Remarks", Narration), //14
new SqlParameter("@CreateDate", CreateDate), //15
new SqlParameter("@CreateTime", CreateTime), //16
new SqlParameter("@CreateUser", AuthBase.EmpCode), //17
new SqlParameter("@CreateTerm", AuthBase.UserId), //18
new SqlParameter("@UpdDate", (object)DBNull.Value), //19
new SqlParameter("@UpdTime", (object)DBNull.Value), //20
new SqlParameter("@UpdUser", (object)DBNull.Value), //21
new SqlParameter("@UpdTerm", (object)DBNull.Value), //22
};
dt = DataAccess.getDataTable("SP_Insert_AccountTransaction", sqlParam, General.GetBMSConString());
if (dt.Rows.Count > 0)
{
}
leadid = strAutoCode;
IsSaved = true;
}
catch (Exception ex)
{
//throw;
}
return(leadid);
}
public static bool Insert_SaleOrder(VehicleSaleMasterVM model, ref string msg)
{
string leadid = "";
if (model.TransCode == "" || model.TransCode == "0" || model.TransCode == null)
{
string getNextTransCode = "declare @lastval varchar(14),@id int " +
"set @id = (select count(*) from VehicleSaleMaster) " +
"set @id=@id+1 " +
"if len(@id) = 1 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00000' " +
"if len(@id) = 2 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0000' " +
"if len(@id) = 3 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'000' " +
"if len(@id) >= 4 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00' " +
"if len(@id) >= 5 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0' " +
"declare @i varchar(14) " +
"set @i = CAST(@id as varchar(14)) " +
"set @lastval = @lastval+@i " +
"select @lastval as TransCode";
dt = DataAccess.getDataTableByQuery(getNextTransCode, nullSqlParam, General.GetBMSConString());
strAutoCode = dt.Rows[0]["TransCode"].ToString();
}
else
{
strAutoCode = model.TransCode;;
}
try
{
//var Serializer = new JavaScriptSerializer();
string transType = "SO";
string delflag = "N";
// string dealerCode = "MCM01";
string EmpCode = "001";
string CudCode = "001";
DateTime UniDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DateTime UniTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
//DateTime leadDate = DateTime.ParseExact(model.TransDate,"MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@TransCode", strAutoCode), //2
new SqlParameter("@TransDate", UniDate), //3
new SqlParameter("@TransType", transType), //4
new SqlParameter("@SaleType", model.SaleType), //5
new SqlParameter("@CreditTerms", model.CreditTerms), //6
new SqlParameter("@EmpCode", model.EmpCode), //7
new SqlParameter("@CusCode", model.CusCode), //8
new SqlParameter("@CustomerType", model.CustomerType), //9
new SqlParameter("@CNICNTN", model.CNICNTN), //10
new SqlParameter("@ContactNo", model.ContactNo), //11
new SqlParameter("@PriceLevel", model.PriceLevel), //12
new SqlParameter("@BillTo", model.BillTo), //13
new SqlParameter("@ShipTo", model.ShipTo), //14
new SqlParameter("@SameAs", model.SameAs), //15
new SqlParameter("@TotalQty", model.TotalQty), //16
new SqlParameter("@ServceQty", (object)DBNull.Value), //17
new SqlParameter("@TotalAmount", (object)DBNull.Value), //18
new SqlParameter("@PaymentReceiptCode", (object)DBNull.Value), //19
new SqlParameter("@PaidAmoun", (object)DBNull.Value), //20
new SqlParameter("@DelFlag", delflag), //21
new SqlParameter("@RefType", (object)DBNull.Value), //22
new SqlParameter("@RefDocumentNo", (object)DBNull.Value), //23
new SqlParameter("@PostFlag", (object)DBNull.Value), //24
new SqlParameter("@VoucherNo", (object)DBNull.Value), //25
new SqlParameter("@VoucherDate", (object)DBNull.Value), //26
new SqlParameter("@UpdUser", AuthBase.UserId), //27
new SqlParameter("@UpdDate", UniDate), //28
new SqlParameter("@UpdTime", UniTime), //29
new SqlParameter("@UpdTerm", General.CurrentIP), //30
};
//dt = DataAccess.getDataTable("SP_Insert_VehicleSaleMaster", sqlParam, General.GetBMSConString());
//if (dt.Rows.Count > 0)
//{
// }
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Insert_VehicleSaleMaster", param, Trans);
IsSaved = true;
leadid = strAutoCode;
}
//IsSaved = true;
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
IsSaved = false;
//throw;
}
return(IsSaved);
}
public static bool Insert_CSIMasterData(VehicleSaleMasterVM model, AccountTransactionVM AccountModel, ReceiptMasterVM ReceiptModel, string ProdDesc, string EngineNo, string ChassisNo, string DealerCode, ref string msg)
{
string leadid = "";
string json = "";
var Serializer = new JavaScriptSerializer();
List <VehicleSaleMasterVM> lst = new List <VehicleSaleMasterVM>();
//SysFunction sys = new SysFunction();
if (model.TransCode == "" || model.TransCode == "0" || model.TransCode == null)
{
strAutoCode = sys.AutoGen("VehicleSaleMaster", "TransCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), DealerCode);
// dt = DataAccess.getDataTableByQuery(getNextTransCode, nullSqlParam, General.GetSBOConString());
// strAutoCode = dt.Rows[0]["TransCode"].ToString();
}
else
{
strAutoCode = model.TransCode;;
}
try
{
//var Serializer = new JavaScriptSerializer();
string transType = "CSI";
string delflag = "N";
//string dealerCode = "MCM01";
DateTime UniDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DateTime UniTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
// string txt = sys.SaveDate(model.TransDate);
//DateTime leadDate = DateTime.ParseExact(model.TransDate,"MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", DealerCode), //0
new SqlParameter("@TransCode", strAutoCode), //2
new SqlParameter("@TransDate", sys.SaveDate(model.TransDate)), //3
new SqlParameter("@TransType", transType), //4
new SqlParameter("@SaleType", model.SaleType), //5
new SqlParameter("@CreditTerms", model.CreditTerms), //6
new SqlParameter("@EmpCode", model.EmpCode), //7
new SqlParameter("@CusCode", model.CusCode), //8
new SqlParameter("@CustomerType", model.CustomerType), //9
new SqlParameter("@CNICNTN", model.CNICNTN), //10
new SqlParameter("@ContactNo", model.ContactNo), //11
new SqlParameter("@PriceLevel", model.PriceLevel), //12
new SqlParameter("@BillTo", model.BillTo), //13
new SqlParameter("@ShipTo", model.ShipTo), //14
new SqlParameter("@SameAs", model.SameAs), //15
new SqlParameter("@TotalQty", model.TotalQty), //16
new SqlParameter("@ServceQty", model.TotalQty), //17
new SqlParameter("@TotalAmount", model.TotalAmount), //18
new SqlParameter("@PaymentReceiptCode", (object)DBNull.Value), //19
new SqlParameter("@PaidAmoun", (object)DBNull.Value), //20
new SqlParameter("@DelFlag", delflag), //21
new SqlParameter("@RefType", model.RefType), //22
new SqlParameter("@RefDocumentNo", model.RefDocumentNo), //23
new SqlParameter("@PostFlag", (object)DBNull.Value), //24
new SqlParameter("@VoucherNo", (object)DBNull.Value), //25
new SqlParameter("@VoucherDate", (object)DBNull.Value), //26
new SqlParameter("@UpdUser", AuthBase.UserId), //27
new SqlParameter("@UpdDate", UniDate), //28
new SqlParameter("@UpdTime", UniTime), //29
new SqlParameter("@UpdTerm", General.CurrentIP), //30
new SqlParameter("@CusInvCode", model.CusInvCode), //30
};
// dt = DataAccess.getDataTable("SP_Insert_VehicleSaleMaster", sqlParam, General.GetSBOConString());
// if (dt.Rows.Count > 0)
// {
// IsSaved = true;
// // lst = EnumerableExtension.ToList<VehicleSaleMasterVM>(dt);
// }
// json = Serializer.Serialize(lst);
//}
//catch (Exception ex)
//{
// ObjTrans.RollBackTransaction(ref Trans);
// msg = ex.Message;
//}
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sys.ExecuteSP_NonQuery("SP_Insert_VehicleSaleMaster", sqlParam, Trans);
IsSaved = true;
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
//throw;
msg = ex.Message;
}
//-------------------------Account Transaction----------------------------------
string ActAutoCode;
if (AccountModel.TransactionCode == "" || AccountModel.TransactionCode == "0" || AccountModel.TransactionCode == null)
{
string getNextTransCode = "declare @lastval varchar(14),@id int " +
"set @id = (select count(*) from AccountTrasnaction) " +
"set @id=@id+1 " +
"if len(@id) = 1 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00000' " +
"if len(@id) = 2 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0000' " +
"if len(@id) = 3 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'000' " +
"if len(@id) >= 4 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'00' " +
"if len(@id) >= 5 " +
"set @lastval='" + "'+cast((YEAR(getDate()) ) %100 as varchar(10)) +'0' " +
"declare @i varchar(14) " +
"set @i = CAST(@id as varchar(14)) " +
"set @lastval = @lastval+@i " +
"select @lastval as TransactionCode";
dt = DataAccess.getDataTableByQuery(getNextTransCode, nullSqlParam, General.GetSBOConString());
ActAutoCode = dt.Rows[0]["TransactionCode"].ToString();
}
else
{
ActAutoCode = AccountModel.TransactionCode;;
}
try
{
//var Serializer = new JavaScriptSerializer();
string delflag = "N";
string dealerCode = "MCM01";
string TrType = "CSI";
int Credit = 0;
string Narration = " Cash Sale Invoice ";
//DateTime CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
DateTime CreateTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString());
DateTime CreateDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
//DateTime leadDate = DateTime.ParseExact(AccountModel.TransactionDate,"MM/dd/yyyy", CultureInfo.InvariantCulture);
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", DealerCode), //0
//new SqlParameter("@ID",),//2
new SqlParameter("@TransactionCode", ActAutoCode), //3
new SqlParameter("@TransactionDate", CreateDate), //4
new SqlParameter("@CusCode", model.CusCode), //5
new SqlParameter("@AccountCode", model.CusCode), //6
new SqlParameter("@InvType", TrType), //7
new SqlParameter("@TrType", TrType), //8
new SqlParameter("@Narration", Narration), //9
new SqlParameter("@Reference", model.RefDocumentNo), //10
new SqlParameter("@Debit", model.TotalAmount), //11
new SqlParameter("@Credit", Credit), //12
new SqlParameter("@Balance", model.TotalAmount), //13
new SqlParameter("@Remarks", Narration), //14
new SqlParameter("@CreateDate", CreateDate), //15
new SqlParameter("@CreateTime", CreateTime), //16
new SqlParameter("@CreateUser", AuthBase.EmpCode), //17
new SqlParameter("@CreateTerm", AuthBase.UserId), //18
new SqlParameter("@UpdDate", (object)DBNull.Value), //19
new SqlParameter("@UpdTime", (object)DBNull.Value), //20
new SqlParameter("@UpdUser", (object)DBNull.Value), //21
new SqlParameter("@UpdTerm", (object)DBNull.Value), //22
new SqlParameter("@ReceiptNo", (DBNull.Value))
};
if (sys.ExecuteSP_NonQuery("SP_Insert_AccountTransaction", sqlParam, Trans) == true)
{
IsSaved = true;
}
//if (ObjTrans.BeginTransaction(ref Trans) == true)
//{
// sys.ExecuteSP_NonQuery("SP_Insert_AccountTransaction", sqlParam, Trans);
// IsSaved = true;
//}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
return(IsSaved);
}
