public string SubmitCreateFuelData(FuelData FuelData) { var User = System.Web.HttpContext.Current.User.Identity.Name; FormsIdentity id = (FormsIdentity)HttpContext.Current.User.Identity; FormsAuthenticationTicket ticket = id.Ticket; string userData = ticket.UserData; string[] roles = userData.Split(','); string userRole = roles[0]; UserOpMap userOpMap = new UserOpMap(); BAL.BAL_Common bAL_Common = new BAL.BAL_Common(); userOpMap = bAL_Common.GetUserOperationMapping(HttpContext.Current.User.Identity.Name, userRole); EntitySubmittedResponse entitySubmittedResponse = new EntitySubmittedResponse(); System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); try { BAL.BAL_Fuel bAL_Fuel = new BAL.BAL_Fuel(); long fuelID = bAL_Fuel.CreateFuel(FuelData, userOpMap); entitySubmittedResponse.submited = true; entitySubmittedResponse.message = "Fuel submitted!"; return(js.Serialize("Fuel Created")); } catch (Exception ex) { entitySubmittedResponse.submited = false; entitySubmittedResponse.message = string.Format("Error occured while generating Bill with message:{0}", ex.Message); //return js.Serialize(entitySubmittedResponse); return(js.Serialize(string.Format("Error occured while generating Bill with message:{0}", ex.Message))); } }
public long CreateCustomer(Customer customer, UserOpMap userOpMap) { using (var dbContext = new ppmsEntities()) { Customer customerData = new Customer(); customerData = (from a in dbContext.Customers where a.IsActive == true && a.Id == customer.Id && a.Name == customer.Name select a).FirstOrDefault(); if (customerData == null) { try { dbContext.Customers.Add(customer); dbContext.SaveChanges(); } catch (Exception ex) { throw; } return(customer.Id); } else { throw new Exception("Customer with same data already exist !"); } } }
public string SubmitEditTankerData(TankerData TankerData) { var User = System.Web.HttpContext.Current.User.Identity.Name; FormsIdentity id = (FormsIdentity)HttpContext.Current.User.Identity; FormsAuthenticationTicket ticket = id.Ticket; string userData = ticket.UserData; string[] roles = userData.Split(','); string userRole = roles[0]; UserOpMap userOpMap = new UserOpMap(); BAL.BAL_Common bAL_Common = new BAL.BAL_Common(); userOpMap = bAL_Common.GetUserOperationMapping(HttpContext.Current.User.Identity.Name, userRole); EntitySubmittedResponse entitySubmittedResponse = new EntitySubmittedResponse(); System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); try { BAL.BAL_Tanker bAL_Tanker = new BAL.BAL_Tanker(); long tankerID = bAL_Tanker.UpdateTanker(TankerData, userOpMap); entitySubmittedResponse.submited = true; entitySubmittedResponse.message = "Tanker Data Updated Successfully!"; //return js.Serialize(entitySubmittedResponse); return(js.Serialize("Tanker Data Updated Successfully!")); } catch (Exception ex) { entitySubmittedResponse.submited = false; entitySubmittedResponse.message = string.Format("Error occured while updating tanker data with message:{0}", ex.Message); return(js.Serialize(string.Format("Error occured while updating tanker data with message:{0}", ex.Message))); } }
public long CreateFuel(FuelData fuelData, UserOpMap userOpMap) { DAL_Fuel dAL_Fuel = new DAL_Fuel(); Fuel fuel = new Fuel(); DailyFuelCost dailyFuelCost = new DailyFuelCost(); fuel.Name = fuelData.Name; fuel.Description = fuelData.Description; fuel.Type = fuelData.Type; dailyFuelCost.CostPerLiter = fuelData.CostPerLiter; return(dAL_Fuel.CreateFuel(fuel, dailyFuelCost, userOpMap)); }
public long CreateMeter(MeterData meterData, UserOpMap userOpMap) { DAL_Meter dAL_Meter = new DAL_Meter(); Meter meter = new Meter(); DailyMeterReading dailyMeterReading = new DailyMeterReading(); meter.Name = meterData.Name; meter.Description = meterData.Description; meter.FuelTypeId = meterData.FuelTypeID; dailyMeterReading.DayStartReading = meterData.DayStartReading; dailyMeterReading.DayEndReading = meterData.DayEndReading; return(dAL_Meter.CreateMeter(meter, dailyMeterReading, userOpMap)); }
public long CreateTanker(TankerData tankerData, UserOpMap userOpMap) { DAL_Tanker dAL_Tanker = new DAL_Tanker(); Tanker tanker = new Tanker(); DailyTankerReading dailyTankerReading = new DailyTankerReading(); tanker.Name = tankerData.Name; tanker.Size = tankerData.Size; tanker.Description = tankerData.Description; tanker.FuelTypeId = tankerData.FuelTypeID; dailyTankerReading.DailyStartReading = tankerData.DayStartReading; dailyTankerReading.DailyEndReading = tankerData.DayEndReading; return(dAL_Tanker.CreateTanker(tanker, dailyTankerReading, userOpMap)); }
public long UpdateMeter(Meter meter, DailyMeterReading dailyMeterReading, UserOpMap userOpMap) { using (var dbContext = new ppmsEntities()) { Meter meterData = new Meter(); meterData = (from a in dbContext.Meters where a.IsActive == true && a.Id == meter.Id select a).FirstOrDefault(); meterData.Description = meter.Description; meterData.FuelTypeId = meter.FuelTypeId; meterData.UpdatedOn = DateTime.Now; meterData.Updatedby = Convert.ToInt64(userOpMap.UserID); dbContext.SaveChanges(); DateTime today = DateTime.Now; DailyMeterReading dailyMeterReadingData = new DailyMeterReading(); dailyMeterReadingData = (from a in dbContext.DailyMeterReadings where (a.UpdatedOn.Value.Day == today.Day && a.UpdatedOn.Value.Month == today.Month && a.UpdatedOn.Value.Year == today.Year && a.MeterId == meter.Id && a.IsActive == true) select a).FirstOrDefault(); if (dailyMeterReadingData == null) { dailyMeterReading.MeterId = meter.Id; dailyMeterReading.DayStartReading = dailyMeterReading.DayStartReading; dailyMeterReading.DayEndReading = dailyMeterReading.DayEndReading; dailyMeterReading.CreatedBy = Convert.ToInt64(userOpMap.UserID); dailyMeterReading.Updatedby = Convert.ToInt64(userOpMap.UserID); dailyMeterReading.UpdatedOn = DateTime.Now; dailyMeterReading.CreatedOn = DateTime.Now; dailyMeterReading.IsActive = true; dbContext.DailyMeterReadings.Add(dailyMeterReading); dbContext.SaveChanges();//this generates the Id for DailyMeterReadings } else { dailyMeterReadingData.DayStartReading = dailyMeterReading.DayStartReading; dailyMeterReadingData.DayEndReading = dailyMeterReading.DayEndReading; dailyMeterReadingData.Updatedby = Convert.ToInt64(userOpMap.UserID); dailyMeterReadingData.UpdatedOn = DateTime.Now; dbContext.SaveChanges();//this generates the Id for DailyMeterReadings } return(dailyMeterReading.Id); } }
public long UpdateCutsomer(CustomerData customerData, UserOpMap userOpMap) { DAL_Customer dAL_Customer = new DAL_Customer(); Customer customer = new Customer(); customer.Id = customerData.Id; customer.EmailId = customerData.EmailID; customer.AddressLineOne = customerData.Addr1; customer.AddressLineTwo = customerData.Addr2; customer.ContactNumber = Convert.ToInt64(customerData.ContactNumber); customer.City = customerData.City; customer.State = customerData.State; customer.UpdatedOn = DateTime.Now; customer.Updatedby = Convert.ToInt64(userOpMap.UserID); customer.CustomerTypeId = Convert.ToInt32(customerData.Type); return(dAL_Customer.UpdateCutsomer(customer)); }
public long UpdateFuel(Fuel fuel, DailyFuelCost dailyFuelCost, UserOpMap userOpMap) { using (var dbContext = new ppmsEntities()) { Fuel fuelData = new Fuel(); fuelData = (from a in dbContext.Fuels where a.IsActive == true && a.Id == fuel.Id select a).FirstOrDefault(); fuelData.Description = fuel.Description; fuelData.Type = fuel.Type; dbContext.SaveChanges(); dailyFuelCost.CreatedBy = Convert.ToInt64(userOpMap.UserID); dailyFuelCost.Updatedby = Convert.ToInt64(userOpMap.UserID); dailyFuelCost.UpdatedOn = DateTime.Now; dailyFuelCost.CreatedOn = DateTime.Now; dailyFuelCost.IsActive = true; dbContext.DailyFuelCosts.Add(dailyFuelCost); dbContext.SaveChanges();//this generates the Id for customer return(dailyFuelCost.Id); } }
public long CreateMeter(Meter meter, DailyMeterReading dailyMeterReading, UserOpMap userOpMap) { using (var dbContext = new ppmsEntities()) { Meter meterData = new Meter(); meterData = (from a in dbContext.Meters where a.IsActive == true && a.Name == meter.Name select a).FirstOrDefault(); if (meterData == null) { //Create Meter meter.IsActive = true; meter.CreatedBy = Convert.ToInt64(userOpMap.UserID); meter.Updatedby = Convert.ToInt64(userOpMap.UserID); meter.CreatedOn = DateTime.Now; meter.UpdatedOn = DateTime.Now; dbContext.Meters.Add(meter); dbContext.SaveChanges(); int meterID = meter.Id; dailyMeterReading.CreatedBy = Convert.ToInt64(userOpMap.UserID); dailyMeterReading.Updatedby = Convert.ToInt64(userOpMap.UserID); dailyMeterReading.UpdatedOn = DateTime.Now; dailyMeterReading.CreatedOn = DateTime.Now; dailyMeterReading.IsActive = true; dailyMeterReading.MeterId = meterID; dbContext.DailyMeterReadings.Add(dailyMeterReading); dbContext.SaveChanges(); return(dailyMeterReading.Id); } else { throw new Exception("Meter already exist !"); } } }
public long CreateFuel(Fuel fuel, DailyFuelCost dailyFuelCost, UserOpMap userOpMap) { using (var dbContext = new ppmsEntities()) { Fuel fuelData = new Fuel(); fuelData = (from a in dbContext.Fuels where a.IsActive == true && a.Name == fuel.Name && a.Type == fuel.Type select a).FirstOrDefault(); if (fuelData == null) { //Create Fuel fuel.IsActive = true; fuel.CreatedBy = Convert.ToInt64(userOpMap.UserID); fuel.Updatedby = Convert.ToInt64(userOpMap.UserID); fuel.CreatedOn = DateTime.Now; fuel.UpdatedOn = DateTime.Now; dbContext.Fuels.Add(fuel); dbContext.SaveChanges(); int fuelID = fuel.Id; dailyFuelCost.CreatedBy = Convert.ToInt64(userOpMap.UserID); dailyFuelCost.Updatedby = Convert.ToInt64(userOpMap.UserID); dailyFuelCost.UpdatedOn = DateTime.Now; dailyFuelCost.CreatedOn = DateTime.Now; dailyFuelCost.IsActive = true; dailyFuelCost.FuelTypeId = fuelID; dbContext.DailyFuelCosts.Add(dailyFuelCost); dbContext.SaveChanges();//this generates the Id for customer return(dailyFuelCost.Id); } else { throw new Exception("Fuel already exist !"); } } }
public UserOpMap GetUserOperationMapping(string name, string userRole) { UserOpMap userOpMap = new UserOpMap(); UserMaster userMaster = new UserMaster(); DAL_Common dAL_Common = new DAL_Common(); userMaster = dAL_Common.GetUserdetailsByUsernameAndRole(name, userRole); if (userMaster != null) { List <Operations> operations = new List <Operations>(); operations = dAL_Common.GetOperationListForUser(userMaster.ID); if (operations != null) { userOpMap.Username = userMaster.UserName; userOpMap.UserID = Convert.ToString(userMaster.ID); userOpMap.UserRoleName = userRole; foreach (Operations op in operations) { userOpMap.OperationsList = operations; } } } return(userOpMap); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.User != null) { if (HttpContext.Current.User.Identity.IsAuthenticated) { if (HttpContext.Current.User.Identity is FormsIdentity) { HideControls(); FormsIdentity id = (FormsIdentity)HttpContext.Current.User.Identity; FormsAuthenticationTicket ticket = id.Ticket; string userData = ticket.UserData; string[] roles = userData.Split(','); HttpContext.Current.User = new GenericPrincipal(id, roles); string userRole = roles[0]; UserOpMap userOpMap = new UserOpMap(); BAL.BAL_Common bAL_Common = new BAL.BAL_Common(); userOpMap = bAL_Common.GetUserOperationMapping(HttpContext.Current.User.Identity.Name, userRole); foreach (Operations op in userOpMap.OperationsList) { var ctrl = this.FindControl(op.OperationName); switch (ctrl.ID) { case "Dashboard": Dashboard.Attributes.Add("style", "display:block"); break; case "ManageCustomer": ManageCustomer.Attributes.Add("style", "display:block"); break; case "ManageTanks": ManageTanks.Attributes.Add("style", "display:block"); break; case "ManageFuel": ManageFuel.Attributes.Add("style", "display:block"); break; case "CreateSale": CreateSale.Attributes.Add("style", "display:block"); break; case "ViewSalesReports": ViewSalesReports.Attributes.Add("style", "display:block"); break; case "ViewInventoryReports": ViewInventoryReports.Attributes.Add("style", "display:block"); break; default: ShowAllControls(); break; } } string pageName = GetCurrentPageName(); switch (pageName) { case "Dashboard": Dashboard.Attributes.Add("class", "active"); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes["class"].Replace("active", "dropdown"); break; case "ManageCustomer": ManageCustomer.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes.Add("class", "dropdown active"); break; case "ManageTanks": ManageTanks.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes.Add("class", "dropdown active"); break; case "ManageFuel": ManageFuel.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes.Add("class", "dropdown active"); break; case "CreateSale": CreateSale.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes.Add("class", "dropdown active"); break; case "InventoryReport": ViewInventoryReports.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes.Add("class", "dropdown active"); servicesMainLi.Attributes["class"].Replace("active", "dropdown"); break; case "SalesReport": ViewSalesReports.Attributes.Add("class", "active"); ViewInventoryReports.Attributes["class"].Replace("active", ""); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); reportMainLi.Attributes.Add("class", "dropdown active"); servicesMainLi.Attributes["class"].Replace("active", "dropdown"); break; case "Sale": CreateSale.Attributes.Add("class", "active"); Dashboard.Attributes["class"].Replace("active", ""); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes.Add("class", "dropdown active"); break; default: Dashboard.Attributes.Add("class", "active"); ManageCustomer.Attributes["class"].Replace("active", ""); ManageTanks.Attributes["class"].Replace("active", ""); ManageFuel.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewInventoryReports.Attributes["class"].Replace("active", ""); CreateSale.Attributes["class"].Replace("active", ""); ViewSalesReports.Attributes["class"].Replace("active", ""); reportMainLi.Attributes["class"].Replace("active", "dropdown"); servicesMainLi.Attributes["class"].Replace("active", "dropdown"); break; } } } else { FormsAuthentication.SignOut(); Response.Redirect("~/Login.aspx"); } } }