public static bool Update_BookingNo(BookOrdMasterVM model, string dealerCode)
{
try
{
SqlParameter[] param =
{
new SqlParameter("@DealerCode", dealerCode), //0
new SqlParameter("@BookRefNo", model.BookRefNo), //1
new SqlParameter("@BookingNo", model.BookingNo), //2
new SqlParameter("@BookingDate", sysfun.SaveDate(model.BookingDate)), //3
new SqlParameter("@TentativeDate", sysfun.SaveDate(model.TentativeDate)), //4
};
if (sysfun.ExecuteSP_NonQuery("SP_Update_BookingNo", param))
{
IsSaved = true;
}
}
catch (Exception)
{
throw;
}
return(IsSaved);
}
public JsonResult Insert_BOMaster(BookOrdMasterVM DOMasterVM)
{
bool result = false;
string msg = "Failed to save record..";
if (DOMasterVM.BookRefNo != "" && DOMasterVM.BookRefNo != "0")
{
if (Core.CRM.ADO.SecurityBll.UserRights("2014", "003"))
{
result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg);
if (result)
{
msg = "Successfully Added";
}
}
else
{
msg = "You dn't have a right! Please Contact to Administrator";
result = false;
}
}
else
{
result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg);
if (result)
{
msg = "Successfully Added";
}
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Update_BookingNo(BookOrdMasterVM VehStockVM)
{
bool result = false;
string msg = "Failed to save record..";
result = BookingOrderMethods.Update_BookingNo(VehStockVM, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_BOMaster(BookOrdMasterVM DOMasterVM)
{
bool result = false;
string msg = "Failed to save record..";
result = BookingOrderMethods.Insert_BOMaster(DOMasterVM, ref msg);
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public static bool Insert_BOMaster(BookOrdMasterVM model, ref string msg)
{
IsSaved = false;
try
{
if (model.BookRefNo == null || model.BookRefNo == "" || model.BookRefNo == "0")
{
strAutoCode = sysfun.AutoGen("BookOrdMaster", "BookRefNo", DateTime.Parse(DateTime.Now.ToShortDateString()).ToString("dd/MM/yyyy"), model.DealerCode);
}
else
{
strAutoCode = model.BookRefNo;
}
SqlParameter[] param =
{
new SqlParameter("@DealerCode", model.DealerCode), //0
new SqlParameter("@BookRefNo", strAutoCode), //1
new SqlParameter("@BookRefDate", sysfun.SaveDate(model.BookRefDate)), //2
new SqlParameter("@InvTypeCode", model.InvTypeCode), //3
new SqlParameter("@InvSubTypeCode", model.InvSubTypeCode), //4
new SqlParameter("@PriceTypeCode", model.PriceTypeCode), //5
new SqlParameter("@CusCode", model.CusCode), //6
new SqlParameter("@UpdUser", AuthBase.UserId), //7
new SqlParameter("@UpdTerm", General.CurrentIP), //8
new SqlParameter("@FHName", model.FHName), //9
new SqlParameter("@Address1", model.Address1), //10
new SqlParameter("@NIC", model.NIC), //11
new SqlParameter("@NTN", model.NTN), //12
new SqlParameter("@CellNo", model.CellNo), //13
new SqlParameter("@Email", model.Email), //14
new SqlParameter("@PhoneNo", model.PhoneNo), //15
new SqlParameter("@SalesPerson", model.SalesPerson), //16
new SqlParameter("@BookMode", model.BookMode), //17
new SqlParameter("@Segment", model.Segment), //18
new SqlParameter("@TaxType", model.TaxType), //19
new SqlParameter("@CusTypeCode", model.CusTypeCode), //20
new SqlParameter("@StockType", model.StockType), //21
new SqlParameter("@DeliveryLocation", model.DeliveryLocation), //22
new SqlParameter("@PaymentTerms", model.PaymentTerms), //23
new SqlParameter("@AccountOf", model.AccountOf), //24
new SqlParameter("@VehicleTotal", model.VehicleTotal), //25
new SqlParameter("@City", model.City), //26
new SqlParameter("@State", model.State), //27
new SqlParameter("@Country", model.Country), //28
new SqlParameter("@VehicleQty", model.VehicleQty), //28
new SqlParameter("@EnquiryNo", model.EnquiryNo), //28
new SqlParameter("@RemainingTotal", model.RemainingTotal), //15
};
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
if (sysfun.ExecuteSP_NonQuery("SP_Insert_BookOrdMaster", param, Trans))
{
IsSaved = true;
}
else
{
return(IsSaved);
}
}
//if (sysfun.ExecuteSP_NonQuery("SP_VehicleDeliveryMaster_Insert", param))
//{
// IsSaved = true;
//}
}
catch (Exception ex)
{
//ObjTrans.RollBackTransaction(ref Trans);
msg = ex.Message;
}
return(IsSaved);
}
