public ActionResult DisplayPoleRentalList(int CompanyId, FormCollection frmcollection)
{
var userid = User.Identity.GetUserId();
var username = User.Identity.GetUserName();
RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username);
ViewBag.IsValidRole = roleAssignmentMatrix.Pole;
ViewBag.CompanySelected = "OK";
if (frmcollection.Count == 0)
{
SearchPoleInformationViewModel SearchCompanyViewModels = new SearchPoleInformationViewModel();
SearchCompanyViewModels.PoleInformationList = db.PoleInformation.SqlQuery("Select * from PoleInformations where CompanyId = '" + frmcollection["CompanyId"] + "'").ToList();
return(View(SearchCompanyViewModels));
}
else if (frmcollection.Count >= 1)
{
int parsedID = int.Parse(frmcollection["PoleInformationId"]);
SearchPoleInformationViewModel SearchPoleRentalViewModels = new SearchPoleInformationViewModel();
PoleInformation PoleRentalAssignment = new PoleInformation();
PoleInformation pole = db.PoleInformation.Find(parsedID);
db.PoleInformation.Remove(pole);
db.SaveChanges();
SearchPoleRentalViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList();
SearchPoleRentalViewModels.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == CompanyId).ToList();
return(View("ViewPoleRentals", SearchPoleRentalViewModels));
}
return(View());
}
public ActionResult AddPoleRental(FormCollection frm)
{
var origamt = frm["Amount"];
var amt = frm["Amount"].Split(',');
var newAmount = "";
foreach (var item in amt)
{
newAmount += item;
}
var userid = User.Identity.GetUserId();
var username = User.Identity.GetUserName();
RoleAssignmentMatrix roleAssignmentMatrix = db.RoleAssignmentMatrix.FirstOrDefault(m => m.UserName == username);
ViewBag.IsValidRole = roleAssignmentMatrix.Pole;
//SL.LogInfo(User.Identity.Name, Request.RawUrl, "User Added Item! (Data Entry Pole Rental) - from Terminal:" + ipaddress);
string isEdit = frm["isEdit"].ToString();
SearchPoleInformationViewModel SearchPoleRentalViewModels = new SearchPoleInformationViewModel();
PoleInformation PoleRentalAssignment = new PoleInformation();
int CompanyId = int.Parse(frm["CompanyId"].ToString());
var errors = ModelState.Values.SelectMany(v => v.Errors);
TryUpdateModel(PoleRentalAssignment);
//if (ModelState.IsValid)
//{
if (isEdit != "True")
{
PoleRentalAssignment.Amount = Convert.ToDecimal(origamt);
PoleRentalAssignment.CreatedDate = DateTime.Now;
PoleRentalAssignment.CreatedBy = userid;
PoleRentalAssignment.BillMode = frm["BillMode"];
PoleRentalAssignment.BillingMonths = frm["billingMonths"];
//PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12";
db.PoleInformation.Add(PoleRentalAssignment);
db.SaveChanges();
TempData["TransactionSuccess"] = "Add";
SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Add - from Terminal:" + ipaddress);
}
else
{
int ParsedIntID = int.Parse(frm["ID"]);
PoleRentalAssignment = db.PoleInformation.Find(ParsedIntID);
//compinfo.CompanyCode = frmcollection["CompanyCode"].ToString();
PoleRentalAssignment.Amount = Convert.ToDecimal(newAmount);
PoleRentalAssignment.StartDate = Convert.ToDateTime(frm["StartDate"].ToString());
PoleRentalAssignment.EndDate = Convert.ToDateTime(frm["EndDate"].ToString());
PoleRentalAssignment.UpdateDate = DateTime.Now;
PoleRentalAssignment.UpdatedBy = userid;
PoleRentalAssignment.BillingMonths = frm["billingMonths"];
//PoleRentalAssignment.BillingMonths = "1,2,3,4,5,6,7,8,9,10,11,12";
PoleRentalAssignment.BillMode = frm["BillMode"];
db.Entry(PoleRentalAssignment).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
TempData["TransactionSuccess"] = "Edit";
SL.LogInfo(User.Identity.Name, Request.RawUrl, "Data Entry Pole Rental- Edit - from Terminal:" + ipaddress);
//ViewBag.TransactionSuccess = "Add";
}
ViewBag.ValidatePostback = "True";
//}
//else
//{
// ViewBag.ValidatePostback = "False";
//}
ViewBag.CompanySelected = "OK";
SearchPoleRentalViewModels.CompanyList = db.Company.Where(m => m.CompanyID == CompanyId).ToList();
SearchPoleRentalViewModels.PoleInformationList = db.PoleInformation.Where(m => m.CompanyId == CompanyId).ToList();
TempData["SearchPoleRentalViewModels"] = SearchPoleRentalViewModels;
return(RedirectToAction("ViewPoleRentalsRPG", "DataEntryPoleRental"));
//return View("ViewPoleRentals", SearchPoleRentalViewModels);
}
