public ActionResult Dashboard()
{
if (string.IsNullOrEmpty((string)Session["DealerCode"]))
{
return(RedirectToAction("NewLogin", "Home"));
}
dealerCode = Session["DealerCode"].ToString();
List <BookOrdMasterVM> lstBO = new List <BookOrdMasterVM>();
DataTable dt = new DataTable();
List <SalesPersonPerformanceVM> model = new List <SalesPersonPerformanceVM>();
model = DashboardMethods.Select_SalesPersonPerformance(dealerCode);
SqlParameter[] sqlParam =
{
new SqlParameter("@DealerCode", dealerCode)
};
dt = DataAccess.getDataTable("SP_Get_BookRefModal", sqlParam, General.GetBMSConString());
if (dt.Rows.Count > 0)
{
lstBO = EnumerableExtension.ToList <BookOrdMasterVM>(dt);
}
List <RequestDeliveryOrderVM> lstDO = DeliveryOrderMethods.GetDOModalList(dealerCode);
ViewBag.BookingOrders = lstBO;
ViewBag.DeliveryOrders = lstDO;
return(View(model));
}
public JsonResult Select_DeliveryCheckList(string EnquiryId)
{
string data = "";
bool result = false;
data = DeliveryOrderMethods.Get_DeliveryChkList(EnquiryId, Session["DealerCode"].ToString(),"VR");
if (!string.IsNullOrEmpty(data))
{
result = true;
}
return Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet);
}
public JsonResult Select_DelChkList(string Type, string DealerCode)
{
string data = "";
bool result = false;
data = DeliveryOrderMethods.Get_DelChkList(Type, DealerCode);
if (!string.IsNullOrEmpty(data))
{
result = true;
}
return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Select_ProRecDetailget(string EnquiryId)
{
List <RequestVehicleReceiptVM> data;
bool result = false;
data = DeliveryOrderMethods.GetProRecDetailget(EnquiryId, Session["DealerCode"].ToString());
if (data.Count > 0)
{
result = true;
}
return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Select_ChassisNo(string EnquiryId, string DealerCode)
{
List <SelectListItem> data;
bool result = false;
data = DeliveryOrderMethods.GetChassisNo(EnquiryId, Session["DealerCode"].ToString());
if (data.Count > 0)
{
result = true;
}
return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Select_DOModal(string EnquiryId)
{
string data;
bool result = false;
data = DeliveryOrderMethods.GetDOModal(Session["DealerCode"].ToString());
if (!string.IsNullOrEmpty(data))
{
result = true;
}
return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Select_Emp(string EnquiryId, string DealerCode)
{
List <SelectListItem> data;
bool result = false;
data = DeliveryOrderMethods.GetDealerEmployee(dealerCode);
if (data.Count > 0)
{
result = true;
}
return(Json(new { Success = result, Response = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Check_Hold(string EnquiryId)
{
string msg = "";
bool result = false;
//result = VehReceiptMethods.Check_ChassisNo(chassisNo,engineNo, DealerCode);
string DealerCode = Session["DealerCode"].ToString();
if (DeliveryOrderMethods.Check_Hold(EnquiryId, DealerCode))
{
msg = "This Vehicle is Hold For Delivery You Can Not Create its Delivery Order";
result = true;
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM)
{
bool result = false;
string msg = "Failed to save record..";
result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_VehChkList(string strCheckedValues)
{
bool result = false;
int count = 0;
string msg = "Failed to save record..";
result = DeliveryOrderMethods.Insert_VehChkList(strCheckedValues, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete_DeliveryOrder(string EnquiryId)
{
bool result = false;
string msg = "Vehicle is Delivered , Data can't be deleted";
result = DeliveryOrderMethods.Delete_DeliveryOrder_Record(EnquiryId, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Deleted";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_GatePass(GatePassVM DOMasterVM)
{
bool result = false;
string msg = "Failed to save record..";
Session["TransCode"] = DOMasterVM.TransCode;
result = DeliveryOrderMethods.Insert_GatePass(DOMasterVM, Session["DealerCode"].ToString(), ref msg);
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_DODetail(List <VehicleDeliveryDetailVM> objects)
{
bool result = false;
int count = 0;
string msg = "Failed to save record..";
//foreach (var item in objects)
//{
// if (count >= 1 || item.BrandCode != null)
// {
result = DeliveryOrderMethods.Insert_DODetail(objects, Session["DealerCode"].ToString());
// }
// count++;
//}
if (result)
{
msg = "Successfully Added";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete_DeliveryOrder(string EnquiryId)
{
bool result = false;
string msg = "Vehicle is Delivered , Data can't be deleted";
try
{
string DealerCode = Session["DealerCode"].ToString();
var DetailList = BMS.VehicleDeliveryDetail.Where(g => g.DealerCode == DealerCode && g.DeliveryNo == EnquiryId).ToList();
if (ObjTrans.BeginTransaction(ref Trans) == true)
{
foreach (var item in DetailList)
{
result = DeliveryOrderMethods.Delete_DeliveryOrder_Record(item.ChasisNo, DealerCode, EnquiryId, Trans);
}
if (result == true)
{
ObjTrans.CommittTransaction(ref Trans);
}
msg = "Deleted Successfully...!";
}
}
catch (Exception ex)
{
ObjTrans.RollBackTransaction(ref Trans);
msg = "Something went wrong with server! /n" + ex;
}
if (result)
{
msg = "Successfully Deleted";
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
public JsonResult Insert_DOMaster(VehicleDeliveryMasterVM DOMasterVM)
{
bool result = false;
string msg = "Failed to save record..";
if (DOMasterVM.DeliveryNo != "" && DOMasterVM.DeliveryNo != "0")
{
if (Core.CRM.ADO.SecurityBll.UserRights("2017", "003"))
{
result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
}
else
{
msg = "You dn't have a right! Please Contact to Administrator";
result = false;
}
}
else
{
result = DeliveryOrderMethods.Insert_DOMaster(DOMasterVM, Session["DealerCode"].ToString());
if (result)
{
msg = "Successfully Added";
}
}
return(Json(new { Success = result, Message = msg }, JsonRequestBehavior.AllowGet));
}
// GET: DeliveryOrder
public ActionResult DOMain(string EnquiryId = "")
{
if (string.IsNullOrEmpty((string)Session["DealerCode"]))
{
return(RedirectToAction("Login", "Home"));
}
if (common.UserRight("2017", "001"))
{
dealerCode = Session["DealerCode"].ToString();
List <SelectListItem> ddlRecNo = new List <SelectListItem>();
ddlRecNo = VehReceiptMethods.GetRecNo(dealerCode);
ViewBag.RecNo = ddlRecNo;
List <SelectListItem> ddlVersion = new List <SelectListItem>();
ddlVersion = GeneralMethods.GetDataFromSp("Select_Version");
ViewBag.ddlVersion = ddlVersion;
//List<SelectListItem> ddlDONo = new List<SelectListItem>();
//ddlDONo = DeliveryOrderMethods.GetDONo(dealerCode);
//ViewBag.DONo = ddlDONo;
List <SelectListItem> ddlVehType = new List <SelectListItem>();
ddlVehType = GeneralMethods.GetDataFromSPWithDealerCode("Select_VehicleType", dealerCode, "Y");
ViewBag.VehType = ddlVehType;
List <SelectListItem> ddlRecType = new List <SelectListItem>();
ddlRecType = GeneralMethods.GetDataFromSPWithDealerCode("Select_ReceiptType", dealerCode);
ViewBag.RecType = ddlRecType;
List <SelectListItem> ddlBrandCode = new List <SelectListItem>();
ddlBrandCode = GeneralMethods.GetDataFromSPWithDealerCode("Select_Brand", dealerCode);
ViewBag.BrandCode = ddlBrandCode;
List <SelectListItem> ddlProdCode = new List <SelectListItem>();
//ddlProdCode = GeneralMethods.GetProduct();
ViewBag.ProdCode = ddlProdCode;
List <SelectListItem> ddlColor = new List <SelectListItem>();
ddlColor = GeneralMethods.GetColor(Session["VehicleCategory"].ToString());
ViewBag.Color = ddlColor;
List <SelectListItem> ddlCustomers = new List <SelectListItem>();
ddlCustomers = VehReceiptMethods.GetDatafromSP("SP_Select_Customer", dealerCode);
ViewBag.Customers = ddlCustomers;
List <SelectListItem> ddlVehLoc = new List <SelectListItem>();
ddlVehLoc = VehReceiptMethods.GetDatafromSP("SP_Select_VehLocation", dealerCode);
ViewBag.VehLoc = ddlVehLoc;
List <SelectListItem> ddlAssignTo = new List <SelectListItem>();
ddlAssignTo = DeliveryOrderMethods.GetDealerEmployee(dealerCode);
ViewBag.AssignTo = ddlAssignTo;
List <SelectListItem> ddlVendor = new List <SelectListItem>();
ddlVendor = GeneralMethods.GetVendor();
ViewBag.Vendor = ddlVendor;
ViewBag.UrlLeadId = EnquiryId;
List <SelectListItem> BookingList = new List <SelectListItem>();
BookingList = BookingOrderMethods.GetDataFromSPWithDealerCode("sp_DelCheckList", dealerCode);
ViewBag.BookingList = BookingList;
}
else
{
TempData["TestAccessError"] = MessageAlert.MsgAuthorized();
return(RedirectToAction("Error", "Definition"));
}
return(View());
}
public ActionResult EnquiryDetail(string leadId = "")
{
if (string.IsNullOrEmpty((string)Session["DealerCode"]))
{
return(RedirectToAction("Login", "Home"));
}
dealerCode = Session["DealerCode"].ToString();
List <SelectListItem> ddleadId = new List <SelectListItem>();
ddleadId = GeneralMethods.GetDataFromSPWithDealerCode("Select_EnquiryId", dealerCode, "Y");
ViewBag.LeadId = ddleadId;
List <SelectListItem> ddSaluation = new List <SelectListItem>();
ddSaluation = GeneralMethods.GetDataFromSp("Select_Profession");
ViewBag.ddSaluation = ddSaluation;
List <SelectListItem> ddlLeadType = new List <SelectListItem>();
ddlLeadType = GeneralMethods.GetDataFromSPWithDealerCode("Select_ProspectType", dealerCode);
ViewBag.LeadType = ddlLeadType;
List <SelectListItem> ddlLeadMode = new List <SelectListItem>();
ddlLeadMode = GeneralMethods.GetDataFromSPWithDealerCode("Select_EnquiryMode", dealerCode);
ViewBag.LeadMode = ddlLeadMode;
List <SelectListItem> ddlVersion = new List <SelectListItem>();
ddlVersion = GeneralMethods.GetDataFromSp("Select_Version");
ViewBag.ddlVersion = ddlVersion;
List <SelectListItem> ddlLeadSrouce = new List <SelectListItem>();
ddlLeadSrouce = GeneralMethods.GetDataFromSPWithDealerCode("Select_EnquirySource", dealerCode);
ViewBag.LeadSource = ddlLeadSrouce;
List <SelectListItem> ddlVehicelSegments = new List <SelectListItem>();
ddlVehicelSegments = GeneralMethods.GetVehicleSegments();
ViewBag.VehicleSegments = ddlVehicelSegments;
List <SelectListItem> ddlAssignTo = new List <SelectListItem>();
ddlAssignTo = DeliveryOrderMethods.GetDealerEmployee(dealerCode);
ViewBag.AssignTo = ddlAssignTo;
List <SelectListItem> ddlBank = new List <SelectListItem>();
ddlBank = GeneralMethods.GetBank();
ViewBag.Bank = ddlBank;
List <SelectListItem> ddlCustomers = new List <SelectListItem>();
ddlCustomers = GeneralMethods.GetDataFromSPWithDealerCode("Select_Customer", dealerCode, "Y");
ViewBag.Customers = ddlCustomers;
List <SelectListItem> ddlCountry = new List <SelectListItem>();
ddlCountry = GeneralMethods.GetCountry();
ViewBag.Country = ddlCountry;
List <SelectListItem> ddlCity = new List <SelectListItem>();
ddlCity = GeneralMethods.GetCity();
ViewBag.City = ddlCity;
List <SelectListItem> ddlBrandCode = new List <SelectListItem>();
ddlBrandCode = GeneralMethods.GetDataFromSPWithDealerCode("Select_Brand", dealerCode, "Y");
ViewBag.BrandCode = ddlBrandCode;
List <SelectListItem> ddlProdCode = new List <SelectListItem>();
ddlProdCode = GeneralMethods.GetProduct();
ViewBag.ProdCode = ddlProdCode;
List <SelectListItem> ddlColor = new List <SelectListItem>();
ddlColor = GeneralMethods.GetColor(Session["VehicleCategory"].ToString());
ViewBag.Color = ddlColor;
List <SelectListItem> ddlPriority = new List <SelectListItem>();
ddlPriority = GeneralMethods.GetStatus();
ViewBag.Priority = ddlPriority;
List <SelectListItem> ddlStatusType = new List <SelectListItem>();
ddlStatusType = GeneralMethods.GetStatusType();
ViewBag.StatusType = ddlStatusType;
List <SelectListItem> ddlFurtherContact = new List <SelectListItem>();
ddlFurtherContact = GeneralMethods.GetTaskType();
ViewBag.FurtherContact = ddlFurtherContact;
List <EnquiryMasterVM> lstEnquiry = EnquiryMethods.Get_EnquiryModal(Session["DealerCode"].ToString());
ViewBag.UrlLeadId = leadId;
ViewBag.Enquires = lstEnquiry;
return(View());
}
// GET: BookingOrder
public ActionResult BOMain(string EnquiryId = "")
{
if (string.IsNullOrEmpty((string)Session["DealerCode"]))
{
return(RedirectToAction("Login", "Home"));
}
dealerCode = Session["DealerCode"].ToString();
List <SelectListItem> ddlBONo = new List <SelectListItem>();
ddlBONo = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectBONo", dealerCode);
ViewBag.BONo = ddlBONo;
List <SelectListItem> ddlEnquiry = new List <SelectListItem>();
ddlEnquiry = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_EnquiryID", dealerCode);
ViewBag.Enquiry = ddlEnquiry;
List <SelectListItem> ddlCusType = new List <SelectListItem>();
ddlCusType = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectCustomerType", dealerCode);
ViewBag.CusType = ddlCusType;
List <SelectListItem> ddlInvType = new List <SelectListItem>();
ddlInvType = BookingOrderMethods.GetDataFromSP("SP_SelectInvoiceType");
ViewBag.InvType = ddlInvType;
List <SelectListItem> ddlInvSubType = new List <SelectListItem>();
ddlInvSubType = BookingOrderMethods.GetDataFromSP("SP_SelectInvoiceSubType");
ViewBag.InvSubType = ddlInvSubType;
List <SelectListItem> ddlPriceType = new List <SelectListItem>();
ddlPriceType = BookingOrderMethods.GetDataFromSP("SP_SelectriceType");
ViewBag.PriceType = ddlPriceType;
List <SelectListItem> ddlChassisNo = new List <SelectListItem>();
ddlChassisNo = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectChassisNo", dealerCode);
ViewBag.ChassisNo = ddlChassisNo;
List <SelectListItem> ddlLocation = new List <SelectListItem>();
ddlLocation = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_Select_VehLocation", dealerCode);
ViewBag.Location = ddlLocation;
List <SelectListItem> ddlAssignTo = new List <SelectListItem>();
ddlAssignTo = DeliveryOrderMethods.GetDealerEmployee(dealerCode);
ViewBag.AssignTo = ddlAssignTo;
List <SelectListItem> ddlCustomers = new List <SelectListItem>();
ddlCustomers = VehReceiptMethods.GetDatafromSP("SP_Select_Customer", dealerCode);
ViewBag.Customers = ddlCustomers;
ViewBag.AccountOf = ddlCustomers;
string ddlCustomer;
ddlCustomer = BookingOrderMethods.GetCustomerModal(dealerCode);
ViewBag.Customer = ddlCustomer;
List <SelectListItem> ddlBrandCode = new List <SelectListItem>();
ddlBrandCode = GeneralMethods.GetDataFromSPWithDealerCode("Select_Brand", dealerCode, "Y");
ViewBag.BrandCode = ddlBrandCode;
List <SelectListItem> ddlProdCode = new List <SelectListItem>();
//ddlProdCode = GeneralMethods.GetProduct();
ViewBag.ProdCode = ddlProdCode;
List <SelectListItem> ddlColor = new List <SelectListItem>();
ddlColor = GeneralMethods.GetColor();
ViewBag.Color = ddlColor;
List <SelectListItem> ddlRecNo = new List <SelectListItem>();
ddlRecNo = VehReceiptMethods.GetRecNoList(dealerCode);
ViewBag.RecNo = ddlRecNo;
List <SelectListItem> ddlBank = new List <SelectListItem>();
ddlBank = GeneralMethods.GetBank();
ViewBag.Bank = ddlBank;
ViewBag.DrwanBank = ddlBank;
List <SelectListItem> ddlCity = new List <SelectListItem>();
ddlCity = GeneralMethods.GetCity();
ViewBag.City = ddlCity;
List <SelectListItem> ddlPaymentMode = new List <SelectListItem>();
ddlPaymentMode = BookingOrderMethods.GetDataFromSP("sp_PaymentMode_select");
ViewBag.PaymentMode = ddlPaymentMode;
@Session["ProdCode"] = string.Empty;
ViewBag.UrlLeadId = EnquiryId;
return(View());
}
// GET: BookingOrder
public ActionResult BOMain(string EnquiryId = "")
{
if (string.IsNullOrEmpty((string)Session["DealerCode"]))
{
return(RedirectToAction("Login", "Home"));
}
if (common.UserRight("2014", "001"))
{
dealerCode = Session["DealerCode"].ToString();
List <SelectListItem> ddlBONo = new List <SelectListItem>();
ddlBONo = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectBONo", dealerCode);
ViewBag.BONo = ddlBONo;
List <SelectListItem> ddlEnquiry = new List <SelectListItem>();
ddlEnquiry = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_EnquiryID", dealerCode);
ViewBag.Enquiry = ddlEnquiry;
List <SelectListItem> ddlCusType = new List <SelectListItem>();
ddlCusType = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectCustomerType", dealerCode);
ViewBag.CusType = ddlCusType;
List <SelectListItem> ddlInvType = new List <SelectListItem>();
ddlInvType = BookingOrderMethods.GetDataFromSP("SP_SelectInvoiceType");
ViewBag.InvType = ddlInvType;
List <SelectListItem> ddlInvSubType = new List <SelectListItem>();
ddlInvSubType = BookingOrderMethods.GetDataFromSP("SP_SelectInvoiceSubType");
ViewBag.InvSubType = ddlInvSubType;
List <SelectListItem> ddlPriceType = new List <SelectListItem>();
ddlPriceType = BookingOrderMethods.GetDataFromSP("SP_SelectriceType");
ViewBag.PriceType = ddlPriceType;
List <SelectListItem> ddlChassisNo = new List <SelectListItem>();
ddlChassisNo = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_SelectChassisNo", dealerCode);
ViewBag.ChassisNo = ddlChassisNo;
List <SelectListItem> ddlLocation = new List <SelectListItem>();
ddlLocation = BookingOrderMethods.GetDataFromSPWithDealerCode("SP_Select_BOLocation_Frieght", dealerCode);
ViewBag.Location = ddlLocation;
List <SelectListItem> ddlAssignTo = new List <SelectListItem>();
ddlAssignTo = DeliveryOrderMethods.GetDealerEmployee(dealerCode);
ViewBag.AssignTo = ddlAssignTo;
List <SelectListItem> ddlCustomers = new List <SelectListItem>();
ddlCustomers = VehReceiptMethods.GetDatafromSP("SP_Select_Customer", dealerCode);
ViewBag.Customers = ddlCustomers;
ViewBag.AccountOf = ddlCustomers;
string ddlCustomer;
ddlCustomer = BookingOrderMethods.GetCustomerModal(dealerCode);
ViewBag.Customer = ddlCustomer;
List <SelectListItem> ddlBrandCode = new List <SelectListItem>();
ddlBrandCode = GeneralMethods.GetDataFromSPWithDealerCode("Select_Brand", dealerCode, "Y");
ViewBag.BrandCode = ddlBrandCode;
List <SelectListItem> ddlProdCode = new List <SelectListItem>();
//ddlProdCode = GeneralMethods.GetProduct();
ViewBag.ProdCode = ddlProdCode;
List <SelectListItem> ddlColor = new List <SelectListItem>();
ddlColor = GeneralMethods.GetColor(Session["VehicleCategory"].ToString());
ViewBag.Color = ddlColor;
List <SelectListItem> ddlRecNo = new List <SelectListItem>();
ddlRecNo = VehReceiptMethods.GetRecNo(dealerCode);
ViewBag.RecNo = ddlRecNo;
List <SelectListItem> ddlBank = new List <SelectListItem>();
ddlBank = GeneralMethods.GetBank();
ViewBag.Bank = ddlBank;
ViewBag.DrwanBank = ddlBank;
List <SelectListItem> ddlCity = new List <SelectListItem>();
ddlCity = GeneralMethods.GetCity();
ViewBag.City = ddlCity;
List <SelectListItem> ddlPaymentMode = new List <SelectListItem>();
ddlPaymentMode = BookingOrderMethods.GetDataFromSP("sp_PaymentMode_select");
ViewBag.PaymentMode = ddlPaymentMode;
List <SelectListItem> BookingList = new List <SelectListItem>();
BookingList = BookingOrderMethods.GetDataFromSP("sp_DocCheckList");
ViewBag.BookingList = BookingList;
@Session["ProdCode"] = string.Empty;
ViewBag.UrlLeadId = EnquiryId;
}
else
{
TempData["TestAccessError"] = MessageAlert.MsgAuthorized();
return(RedirectToAction("Error", "Definition"));
}
return(View());
}
