public static bool Insert_IRMaster(ReceiptMasterVM model)
{
DateTime recDate;
ChasisNo = model.ChasisNo;
EngineNo = model.EngineNo;
try
{
if (model.ReceiptNo == "" || model.ReceiptNo == null)
{
strAutoCode = sysfun.AutoGen("ReceiptMaster", "ReceiptNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.ReceiptNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@ReceiptNo", strAutoCode), //1
new SqlParameter("@ReceiptDate", sysfun.SaveDate(model.ReceiptDate)), //2
new SqlParameter("@CusCode", model.CusCode), //3
new SqlParameter("@Remarks", model.Remarks), //4
new SqlParameter("@ISFullAndFinal", 'N'), //5
new SqlParameter("@FullAndFinalReceiveable", 0.0), //6
new SqlParameter("@FullAndFinalPenalty", 0.0), //7
new SqlParameter("@FullAndFinalTotalReceiveable", 0.0), //8
new SqlParameter("@FullAndFinalDiscount", 0.0), //9
new SqlParameter("@CreateDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //10
new SqlParameter("@CreateTime", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //11
new SqlParameter("@CreatedBy", AuthBase.UserId), //12
new SqlParameter("@CreateTerm", General.CurrentIP), //13
new SqlParameter("@DelFlag", 'N'), //14
new SqlParameter("@PostFlag", 'Y'), //15
new SqlParameter("@PostDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //16
new SqlParameter("@TransferStatus", 'C'), //17
new SqlParameter("@TransferDate", sysfun.SaveDate(DateTime.Now.ToString("dd-MM-yyyy"))), //18
new SqlParameter("@SoftwareVersion", DBNull.Value), //19
new SqlParameter("@CommunicationVersion", DBNull.Value), //20
new SqlParameter("@EmpCode", model.EmpCode), //21
new SqlParameter("@EmpDesc", model.EmpDesc), //22
new SqlParameter("@ProdDesc", model.ProdDesc), //23
new SqlParameter("@EngineNo", model.EngineNo), //24
new SqlParameter("@ChasisNo", model.ChasisNo), //25
new SqlParameter("@Type", model.Type), //26
new SqlParameter("@OldReceiptNo", DBNull.Value), //27
new SqlParameter("@InvoiceDate", sysfun.SaveDate(model.InvoiceDate)), //28
new SqlParameter("@BalanceWithoutPenalty", 0), //28
new SqlParameter("@BalancePenalty", 0), //28
new SqlParameter("@TotalBalance", 0), //24
new SqlParameter("@LastActualTransDate", sysfun.SaveDate(model.ReceiptDate)), //25
new SqlParameter("@LastPenaltyTransDate", sysfun.SaveDate(model.ReceiptDate)), //26
new SqlParameter("@PrintCounter", DBNull.Value), //27
new SqlParameter("@InvoiceNo", model.InvoiceNo), //28
new SqlParameter("@PRBNo", model.PRBNo), //28
new SqlParameter("@SONo", model.SONo), //28
new SqlParameter("@FormName", model.FormName), //28
new SqlParameter("@TransType", model.TransType), //28
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("SP_Insert_ReceiptMaster", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
ObjTrans.RollBackTransaction(ref Trans);
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);
}
