public JsonResult Insert_VSMaster(VehicleStockVM VehStockVM)
{
bool result = false;
string msg = "Failed to save record..";
result = VehicleUpdateMethods.Insert_VSMaster(VehStockVM, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public static bool Insert_VSMaster(VehicleStockVM model, string dealerCode)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@ChasisNo", model.ChasisNo), //1
new SqlParameter("@EngineNo", model.EngineNo), //2
new SqlParameter("@CusCode", model.CusCode), //3
new SqlParameter("@BrandCode", model.BrandCode), //4
new SqlParameter("@ProdCode", model.ProdCode), //5
new SqlParameter("@ColorCode", model.ColorCode), //6
new SqlParameter("@RegNo", model.RegNo), //9
new SqlParameter("@RegDate", model.RegDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.RegDate)), //10
new SqlParameter("@InvoiceNo", model.InvoiceNo), //11
new SqlParameter("@InvoiceDate", model.InvoiceDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.InvoiceDate)), //12
new SqlParameter("@OrderNo", model.OrderNo), //13
new SqlParameter("@OrderDate", model.OrderDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.OrderDate)), //14
new SqlParameter("@BookingRefNo", model.BookingRefNo), //15
new SqlParameter("@BookingRefDate", model.BookingRefDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.BookingRefDate)), //16
new SqlParameter("@BookRecDate", model.BookRecDate == null ? (object)DBNull.Value :sysfun.SaveDate(model.BookRecDate)), //17
new SqlParameter("@BookIssueDate", model.BookIssueDate == null ? (object)DBNull.Value : sysfun.SaveDate(model.BookIssueDate)), //18
new SqlParameter("@InsCompCode", model.InsCompCode), //19
new SqlParameter("@InsPolicyNo", model.InsPolicyNo), //20
new SqlParameter("@InsDate", model.InsDate == null ?(object)DBNull.Value :sysfun.SaveDate(model.InsDate)) //21
};
//if (ObjTrans.BeginTransaction(ref Trans) == true)
//{
// sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param, Trans);
// IsSaved = true;
//}
if (sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param))
{
IsSaved = true;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
public static bool Insert_VSMaster(VehicleStockVM model, string dealerCode, ref string msg)
{
try
{
strAutoCode = model.ChasisNo;
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@ChasisNo", model.ChasisNo), //1
new SqlParameter("@EngineNo", model.EngineNo), //2
new SqlParameter("@CusCode", model.CusCode), //3
new SqlParameter("@BrandCode", model.BrandCode), //4
new SqlParameter("@ProdCode", model.ProdCode), //5
new SqlParameter("@ColorCode", model.ColorCode), //6
new SqlParameter("@RegNo", model.RegNo), //9
new SqlParameter("@RegDate", model.RegDate == null ? (object)DBNull.Value : model.RegDate), //10
new SqlParameter("@InvoiceNo", model.InvoiceNo), //11
new SqlParameter("@InvoiceDate", model.InvoiceDate == null ? (object)DBNull.Value : model.InvoiceDate), //12
new SqlParameter("@OrderNo", model.OrderNo), //13
new SqlParameter("@OrderDate", model.OrderDate == null ? (object)DBNull.Value : model.OrderDate), //14
new SqlParameter("@BookingRefNo", model.BookingRefNo), //15
new SqlParameter("@BookingRefDate", model.BookingRefDate == null ? (object)DBNull.Value : model.BookingRefDate), //16
new SqlParameter("@BookRecDate", model.BookRecDate == null ? (object)DBNull.Value : model.BookRecDate), //17
new SqlParameter("@BookIssueDate", model.BookIssueDate == null ? (object)DBNull.Value : model.BookIssueDate), //18
new SqlParameter("@InsCompCode", model.InsCompCode), //19
new SqlParameter("@InsPolicyNo", model.InsPolicyNo), //20
new SqlParameter("@InsDate", model.InsDate == null ?(object)DBNull.Value : model.InsDate), //21
new SqlParameter("@TransportDelivery", model.TransportDelivery == null ?(object)DBNull.Value : model.TransportDelivery) //22
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Update_VehicleStock", param))
{
IsSaved = true;
}
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(IsSaved);
}
