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