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");
}
}
}
