public static bool Insert_Buying(BuyingCusVehicleVM model, string dealerCode)
{
try
{
if (string.IsNullOrEmpty(model.BuyingCode))
{
if (sysfun.IsExist("RegNo", model.RegNo, "UCS_Buying", dealerCode))
{
return(IsSaved);
}
strAutoCode = sysfun.AutoGen("UCS_Buying", "BuyingCode", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), dealerCode);
//strAutoCode = sysfun.GetNewMaxID("UCS_Buying", "BuyingCode", 8, dealerCode);
}
else
{
strAutoCode = model.BuyingCode;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode ", dealerCode), //0
new SqlParameter("@BuyingCode ", strAutoCode), //1
new SqlParameter("@BuyingDate ", sysfun.SaveDate(model.BuyingDate)), //3
new SqlParameter("@RegNo ", model.RegNo), //5
new SqlParameter("@KM ", model.KM), //6
new SqlParameter("@RoadTaxPaid ", model.RoadTaxPaid), //7
new SqlParameter("@RoadTaxValidUpTo ", sysfun.SaveDate(model.RoadTaxValidUpTo)), //8
new SqlParameter("@IsInsured ", model.IsInsured), //9
new SqlParameter("@InsuranceValidUpTo ", sysfun.SaveDate(model.InsuranceValidUpTo)), //10
new SqlParameter("@BuyingPrice ", Convert.ToDecimal(model.BuyingPrice)), //11
new SqlParameter("@EvaluationCode ", model.EvaluationCode), //12
new SqlParameter("@EvaluationDate ", sysfun.SaveDate(model.EvaluationDate)), //13
new SqlParameter("@Pic01 ", model.Pic01), //19
new SqlParameter("@Pic02 ", model.Pic02), //20
new SqlParameter("@Pic03 ", model.Pic03), //21
new SqlParameter("@Pic04 ", model.Pic04), //22
new SqlParameter("@Pic05 ", model.Pic05), //23
new SqlParameter("@UpdUser ", AuthBase.UserId), //24
new SqlParameter("@UpdTerm ", General.CurrentIP), //27
new SqlParameter("@LocationCode ", model.LocationCode),
new SqlParameter("@BuyingMode ", model.BuyingMode)
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
sysfun.ExecuteSP_NonQuery("Insert_Buying", param, Trans);
IsSaved = true;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
public JsonResult Insert_Buying(BuyingCusVehicleVM Objects)
{
Objects.Pic01 = Session["FrontImg"].ToString();
Objects.Pic02 = Session["BackImg"].ToString();
Objects.Pic03 = Session["LeftImg"].ToString();
Objects.Pic04 = Session["RightImg"].ToString();
Objects.Pic05 = Session["TopImg"].ToString();
string dealerCode = Session["DealerCode"].ToString();
bool result = false;
string msg = "Failed to save record..";
result = BuyingCusVehicleMethods.Insert_Buying(Objects, dealerCode);
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
