public ActionResult CreateVehicle(FormCollection frm) { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } USP_GetUserDetails_Result logindetails = new USP_GetUserDetails_Result(); if (Session["logindetails"] != null) { logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; } usp_VehicleMasterGetByID_Result vehicle = new usp_VehicleMasterGetByID_Result(); TryUpdateModel(vehicle); string result = Convert.ToString(InventoryEntities.usp_VehicleMasterInsertUpate(0, vehicle.VehicleNumber, logindetails.Company_Id, logindetails.Branch_Id, DateTime.Now, logindetails.USer_Id, 0, null, vehicle.status).SingleOrDefault()); if (result == "Duplicate Vehicle") { ModelState.AddModelError("Error", "Vehicle already exists"); return(View()); } else { return(RedirectToAction("Index")); } } catch (Exception ex) { return(RedirectToAction("Index")); } }
public USP_GetUserDetails_Result CheckLoginStatus(string mobileno = "", string username = "", string pwd = "") { //string pwd=""; USP_GetUserDetails_Result userdetails = InventoryEntities.USP_GetUserDetails(username, pwd, mobileno).FirstOrDefault(); return(userdetails); }
public ActionResult CreateCylinderDetails(FormCollection frm) { try { usp_CylinderMasterGetByID_Result cylinder = new usp_CylinderMasterGetByID_Result(); TryUpdateModel(cylinder); //bool b= int.TryParse(frm["WLCapacityUOMID"], out re); string barcode = cylinder.CylindeNumber.ToString() + cylinder.VendorID.ToString() + cylinder.VendorBranchID.ToString(); logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; object result = InventoryEntities.usp_CylinderMasterInsertUpdate(cylinder.CylindeNumber, barcode, cylinder.ManufacturerID, cylinder.PurchaseDate, cylinder.InitialGasID, cylinder.WLCapacity, cylinder.WLCapacityUOMID, cylinder.WorkingPressure, cylinder.WorkingPressureUOMID, cylinder.TestDate, cylinder.NextTestDate, cylinder.ValveModelID, cylinder.PresentStateID, cylinder.GasInUseID, cylinder.VendorBranchID, cylinder.Size, cylinder.SizeUOMID, cylinder.CurrentLocationID, cylinder.CurrentCustomerBranchID, logindetails.Branch_Id, logindetails.Company_Id, logindetails.USer_Id, logindetails.USer_Id, cylinder.status); GenerateBarcode(barcode); return(RedirectToAction("Index")); } catch (Exception ex) { return(RedirectToAction("Index")); } }
public ActionResult EditVehicle(FormCollection frm) { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } USP_GetUserDetails_Result logindetails = new USP_GetUserDetails_Result(); if (Session["logindetails"] != null) { logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; } usp_VehicleMasterGetByID_Result vehicle = new usp_VehicleMasterGetByID_Result(); TryUpdateModel(vehicle); string result = Convert.ToString(InventoryEntities.usp_VehicleMasterInsertUpate(vehicle.VehicleID, vehicle.VehicleNumber, logindetails.Company_Id, logindetails.Branch_Id, DateTime.Now, 0, logindetails.USer_Id, DateTime.Now, vehicle.status)); return(RedirectToAction("Index")); } catch (Exception ex) { return(RedirectToAction("Index")); } }
public ActionResult VehicleUserMappingDetails(FormCollection frm) { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } VehicleUserMapping vehicleUserMapping = new VehicleUserMapping(); TryUpdateModel(vehicleUserMapping); logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; string result = Convert.ToString(InventoryEntities.usp_VehicleUserMappingInsert(vehicleUserMapping.VehicleID, vehicleUserMapping.UserD, logindetails.Branch_Id, logindetails.Company_Id, logindetails.USer_Id).FirstOrDefault()); if (result == "Vehicle Unavailable") { ModelState.AddModelError("Error", "Vehicle already assigned to the user for today"); FillViewBag(); return(View()); } else { return(RedirectToAction("VehicleUserMappingDetails")); } } catch (Exception ex) { return(View()); } }
private void FillViewBag() { logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; ViewBag.VehicleID = new SelectList(InventoryEntities.usp_VehicleMasterListGet(logindetails.Company_Id, logindetails.Branch_Id), "VehicleID", "VehicleNumber"); ViewBag.UserD = new SelectList(InventoryEntities.usp_tblUserMasterListGet(logindetails.Company_Id, logindetails.Branch_Id), "User_Id", "User_Name"); }
public ActionResult CheckLogin(login obj) { try { USP_GetUserDetails_Result userdetails = onlinetutor.USP_GetUserDetails(obj.loginID, obj.Password).FirstOrDefault(); //return RedirectToAction("Index", "Category", new { area = "Admin" }); return(Json(userdetails, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { // return Json(userdetails, JsonRequestBehavior.AllowGet); return(Content("2")); } }
public USP_GetUserDetails_Result CheckLoginStatus(string mobileno = "", string username = "", string pwd = "") { //string pwd=""; USP_GetUserDetails_Result userdetails = new USP_GetUserDetails_Result(); try { Err.ErrorLog("CheckLoginStatus called"); userdetails = InventoryEntities.USP_GetUserDetails(username, pwd, mobileno).FirstOrDefault(); Err.ErrorLog("CheckLoginStatus called end"); return(userdetails); } catch (Exception ex) { Err.ErrorLog("CheckLoginStatus Error:" + ex.Message); return(userdetails); } }
public ActionResult Index(FormCollection frm) { try { string result = string.Empty; logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; if (frm["barcodevalues"].ToString() != "") { result = Convert.ToString(InventoryEntities.usp_tblCylinderFillInsert(frm["barcodevalues"].ToString(), logindetails.USer_Id, logindetails.Branch_Id, logindetails.Company_Id)); } return(View()); } catch { return(View()); } }
// [OutputCache(Duration =1000)] public ActionResult GetCylinderList() { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } List <usp_CylinderMasterGet_Result> cylinderlist = new List <usp_CylinderMasterGet_Result>(); logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; try { cylinderlist = InventoryEntities.usp_CylinderMasterGet(logindetails.Branch_Id, logindetails.Company_Id).ToList(); return(Json(cylinderlist, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(View()); } }
public ActionResult ReportCylinderAgeAnalysis(FormCollection frm) { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } // USP_GetUserDetails_Result logindetails; logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; CylinderRecieveDeliver cylinderRecieveDeliver = new CylinderRecieveDeliver(); TryUpdateModel(cylinderRecieveDeliver); //for cylinder count location wise ReportViewer reportview = new ReportViewer(); reportview.ProcessingMode = ProcessingMode.Local; reportview.SizeToReportContent = true; List <usp_CylinderAgeAnalysisReport_Result> CylinderList = new List <usp_CylinderAgeAnalysisReport_Result>(); CylinderList = InventoryEntities.usp_CylinderAgeAnalysisReport(cylinderRecieveDeliver.StartDate, cylinderRecieveDeliver.EndDate, logindetails.Branch_Id, logindetails.Company_Id).ToList(); reportview.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\CylinderAgeAnalysisReport.rdlc"; reportview.ShowToolBar = true; reportview.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", CylinderList)); ViewBag.CylinderDetails = reportview; return(View()); } catch (Exception ex) { return(View()); } }
public ActionResult EditVehicle(int VehicleID) { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } USP_GetUserDetails_Result logindetails = new USP_GetUserDetails_Result(); if (Session["logindetails"] != null) { logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; } usp_VehicleMasterGetByID_Result vehicle = new usp_VehicleMasterGetByID_Result(); vehicle = InventoryEntities.usp_VehicleMasterGetByID(logindetails.Company_Id, logindetails.Branch_Id, VehicleID).SingleOrDefault(); return(View(vehicle)); } catch (Exception ex) { return(RedirectToAction("Index")); } }
public ActionResult Index(LoginDetails login) { try { TryUpdateModel(login); string username = Request["username"]; string password = Request["password"]; //USP_GetUserDetails_Result logindetails= InventoryEntities.USP_GetUserDetails(login.UserName, login.Password, login.Phone).FirstOrDefault(); USP_GetUserDetails_Result logindetails = InventoryEntities.USP_GetUserDetails(username, password, "").FirstOrDefault(); // return View(); if (logindetails.USer_Id == 0) { ModelState.AddModelError("Error", "Invalid User name or Password. Please try again."); return(View()); } Session["logindetails"] = logindetails; return(RedirectToAction("ReportCylinderDashboard", "CylinderDetails", new { area = "CylinderDetails" })); } catch (Exception ex) { return(RedirectToAction("Index")); } }
public ActionResult GetVehicleList() { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } USP_GetUserDetails_Result logindetails = new USP_GetUserDetails_Result(); if (Session["logindetails"] != null) { logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; } List <usp_VehicleMasterGet_Result> users = new List <usp_VehicleMasterGet_Result>(); users = InventoryEntities.usp_VehicleMasterGet(logindetails.Company_Id, logindetails.Branch_Id).ToList(); return(Json(users, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(View()); } }
public ActionResult ReportMobileWarningMessages() { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } // USP_GetUserDetails_Result logindetails; logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; ReportViewer reportview = new ReportViewer(); reportview.ProcessingMode = ProcessingMode.Local; reportview.SizeToReportContent = true; List <usp_MobileWarningMsgreportGet_Result> CylinderList = new List <usp_MobileWarningMsgreportGet_Result>(); CylinderList = InventoryEntities.usp_MobileWarningMsgreportGet(DateTime.Now.AddDays(-7), DateTime.Now, logindetails.Branch_Id, logindetails.Company_Id).ToList(); reportview.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\MobileWarningMessages.rdlc"; reportview.ShowToolBar = true; reportview.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", CylinderList)); ViewBag.CylinderDetails = reportview; return(View()); } catch (Exception ex) { return(View()); } }
public ActionResult ReportCylinderDashboard() { try { if (Session["logindetails"] == null) { Session.Abandon(); return(RedirectToAction("Index", "UserLogin", new { area = "Login" })); } // USP_GetUserDetails_Result logindetails; logindetails = (USP_GetUserDetails_Result)Session["logindetails"]; //for cylinder count location wise ReportViewer reportview = new ReportViewer(); reportview.ProcessingMode = ProcessingMode.Local; reportview.SizeToReportContent = true; List <usp_CylinderCount_Result> CylinderListCount = new List <usp_CylinderCount_Result>(); CylinderListCount = InventoryEntities.usp_CylinderCount(logindetails.Branch_Id, logindetails.Company_Id).ToList(); reportview.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\CylinderCount.rdlc"; reportview.ShowToolBar = false; reportview.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", CylinderListCount)); List <usp_CylinderCountPState_Result> CylinderCountPState = new List <usp_CylinderCountPState_Result>(); CylinderCountPState = InventoryEntities.usp_CylinderCountPState(logindetails.Branch_Id, logindetails.Company_Id).ToList(); //reportviewPstate.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\CylinderCountPState.rdlc"; reportview.LocalReport.DataSources.Add(new ReportDataSource("DataSet3", CylinderCountPState)); List <usp_CylinderCountGasInUse_Result> CylinderCountGasInUse = new List <usp_CylinderCountGasInUse_Result>(); CylinderCountGasInUse = InventoryEntities.usp_CylinderCountGasInUse(logindetails.Branch_Id, logindetails.Company_Id).ToList(); //reportviewPstate.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\CylinderCountPState.rdlc"; reportview.LocalReport.DataSources.Add(new ReportDataSource("DataSet2", CylinderCountGasInUse)); ViewBag.CylinderDetails = reportview; //cylinder count Pstatewise //ReportViewer reportviewPstate = new ReportViewer(); //reportview.ProcessingMode = ProcessingMode.Local; //reportview.SizeToReportContent = true; //ViewBag.reportviewPstate = reportviewPstate; //end ReportViewer reportview1 = new ReportViewer(); reportview1.ProcessingMode = ProcessingMode.Local; reportview1.SizeToReportContent = true; List <usp_CylinderMasterGet_Result> CylinderList = new List <usp_CylinderMasterGet_Result>(); CylinderList = InventoryEntities.usp_CylinderMasterGet(logindetails.Branch_Id, logindetails.Company_Id).ToList(); reportview1.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"\Reports\CylinderDetailLocation.rdlc"; //locationname List <ReportParameter> parameters = new List <ReportParameter>(); ReportParameter param = new ReportParameter(); param.Name = "locationname"; //parameters.Add(param); reportview1.LocalReport.SetParameters(param); reportview1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", CylinderList)); return(View()); } catch (Exception ex) { return(View()); } }