// GET: Services/Edit/5 public ActionResult Edit(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var service = _db.ServiceInfos.Find(id); if (service == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ViewBag.StatusList = Common.ToSelectList <Status>(service.Status); return(View(service)); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Create(Group group) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (!ModelState.IsValid) { return(View(group)); } if (_db.Groups.Any(x => x.Name == group.Name)) { ModelState.AddModelError("Name", @"Group Name already exist, try another."); return(View(group)); } _db.Groups.Add(group); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult DeleteConfirmed(int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var clientInfo = _db.ClientInfos.Find(id); if (clientInfo == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } _db.ClientInfos.Remove(clientInfo); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Deleted; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
// GET: Suppliers/Details/5 public ActionResult Details(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var suppliersInfo = _db.SuppliersInfos.Find(id); if (suppliersInfo != null) { return(View(suppliersInfo)); } TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "Id,SupplierName,SupplierEmail,SupplierPhone,SupplierAddress,SupplierMobileNo")] SuppliersInfo supplier) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { ModelState.Clear(); supplier.SupplierId = string.Format("SI-{0:000000}", _db.SuppliersInfos.Count() + 1); supplier.EntryBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; supplier.EntryDate = DateTime.Now; TryValidateModel(supplier); if (ModelState.IsValid) { _db.SuppliersInfos.Add(supplier); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } dbTransaction.Rollback(); return(View(supplier)); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Create([Bind(Include = "Id,MethodName")] PaymentMethod paymentMethod) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { ModelState.Clear(); paymentMethod.MethodId = string.Format("PI-{0:000000}", _db.PaymentMethods.Count() + 1); paymentMethod.EntryBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; paymentMethod.EntryDate = DateTime.Now; TryValidateModel(paymentMethod); if (ModelState.IsValid) { _db.PaymentMethods.Add(paymentMethod); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } dbTransaction.Rollback(); return(View(paymentMethod)); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
// GET: Employees/Details/5 public ActionResult Details(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var employee = _db.EmployeeBasicInfos.Find(id); if (employee == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var imageToShow = !string.IsNullOrWhiteSpace(employee.ImageUrl) ? employee.ImageUrl : "/Content/template/img/avatars/default.png"; ViewBag.Designations = new SelectList(_db.EmployeeDesignations, "Id", "DesignationTitleEn", employee.EmployeeDesignationId); ViewBag.BloodGroups = Common.ToSelectList <BloodGroup>(employee.BloodGroup); ViewBag.Levels = Common.ToSelectList <EmployeeLevel>(employee.UserLevel); ViewBag.Image = System.IO.File.Exists(Server.MapPath("~" + imageToShow)) ? imageToShow : ""; return(View(employee)); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
// GET: Navigation/Edit/5 public ActionResult Edit(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var menu = _db.Menus.Find(id); if (menu == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ViewBag.Modules = Common.ToSelectList <Module>(menu.ModuleName); ViewBag.StatusList = Common.ToSelectList <Status>(menu.Status); return(View(menu)); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
// GET: PaymentMethods/Details/5 public ActionResult Details(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var paymentMethod = _db.PaymentMethods.Find(id); if (paymentMethod != null) { return(View(paymentMethod)); } TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "CountryName,CountryCode,DelStatus")] Country country) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { ModelState.Clear(); country.EntryBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; country.EntryDate = DateTime.Now; TryValidateModel(country); if (ModelState.IsValid) { _db.Countries.Add(country); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } dbTransaction.Rollback(); return(View(country)); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.Status = Common.ToSelectList <Status>(); } } }
public ActionResult CreateDbBackUp() { try { var connectionString = WebConfigurationManager.ConnectionStrings["CrmDbContext"].ConnectionString; var builder = new SqlConnectionStringBuilder(connectionString); var databaseName = builder.InitialCatalog; var backUpDirectory = Server.MapPath("~/Backup/"); var fileName = "CRM_" + DateTime.Now.ToString("yyyy-MM-dd HH.mm.ss") + ".bak"; var backupPath = Path.Combine(backUpDirectory, fileName); if (!Directory.Exists(backUpDirectory)) { Directory.CreateDirectory(backUpDirectory); } foreach (var file in Directory.GetFiles(backUpDirectory, "*.bak").Where(item => item.EndsWith(".bak"))) { System.IO.File.Delete(file); } var query = string.Format("BACKUP DATABASE [{0}] TO DISK ='{1}'", databaseName, backupPath); _db.Database.ExecuteSqlCommand(TransactionalBehavior.DoNotEnsureTransaction, query); var fileBytes = System.IO.File.ReadAllBytes(backupPath); return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int?countryId) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (countryId == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } if (!_db.Countries.Any(x => x.Id == countryId)) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } _db.Countries .Where(x => x.Id == countryId) .Update(u => new Country { DelStatus = true }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Deleted; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
// GET: Groups/Edit/5 public ActionResult Edit(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var group = _db.Groups.Find(id); ViewBag.IsGroupIsAdmin = _db.Groups.Any(x => x.Id == id && x.Name.ToLower() == "admin"); if (group != null) { return(View(group)); } TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Edit(int?id) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } var client = _db.ClientInfos.Find(id); if (client == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ViewBag.StatusList = Common.ToSelectList <Status>(); ViewBag.BranchList = new SelectList(_db.BranchInfos, "Id", "BranchName", client.BranchId); ViewBag.ReferralTypes = Common.ToSelectList <ReferralsType>(client.ReferralType); ViewBag.IsRequireSupplier = Common.ToSelectList <RequireSuppiler>(client.SupplierId == null ? (int)RequireSuppiler.No : (int)RequireSuppiler.Yes); ViewBag.ServiceList = new SelectList(_db.ServiceInfos.OrderBy(x => x.ServiceName), "Id", "ServiceName", client.ServiceId); ViewBag.WorkingStatusList = Common.ToSelectList <WorkingStatus>(client.WorkingStatus); ViewBag.SmsConfirmationList = Common.ToSelectList <SmsConfirmation>(client.SmsConfirmation); ViewBag.InfoStatusList = Common.ToSelectList <InformationUpdate>(client.InfoStatus); ViewBag.DeliveryStatusList = Common.ToSelectList <DeliveryStatus>(client.DeliveryStatus); ViewBag.StatusList = Common.ToSelectList <Status>(client.Status); return(View(client)); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Create(Menu menu) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (!ModelState.IsValid) { dbTransaction.Dispose(); ViewBag.Modules = Common.ToSelectList <Module>(); ViewBag.StatusList = Common.ToSelectList <Status>(); return(View(menu)); } _db.Menus.Add(menu); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Edit([Bind(Include = "Id,DesignationTitleEn,DesignationTitleBn,DesignationDepertment,Status")] EmployeeDesignation designation, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (_db.EmployeeDesignations.Count(x => x.Id == id) < 1) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var empDesignation = _db.EmployeeDesignations.Single(x => x.Id == id); if (empDesignation == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ModelState.Clear(); designation.DesignationId = empDesignation.DesignationId; designation.EntryBy = empDesignation.EntryBy; designation.EntryDate = empDesignation.EntryDate; designation.DelStatus = empDesignation.DelStatus; TryValidateModel(designation); if (!ModelState.IsValid) { return(View(designation)); } _db.EmployeeDesignations .Where(x => x.Id == id) .Update(u => new EmployeeDesignation { DesignationTitleEn = designation.DesignationTitleEn, DesignationTitleBn = designation.DesignationTitleBn, Status = designation.Status }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.StatusList = Common.ToSelectList <Status>(designation.Status); } } }
public ActionResult Edit([Bind(Include = "Id,SupplierName,SupplierEmail,SupplierPhone,SupplierAddress,SupplierMobileNo")] SuppliersInfo supplier, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (_db.SuppliersInfos.Count(x => x.Id == id) < 1) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var suppliersInfo = _db.SuppliersInfos.Single(x => x.Id == id); if (suppliersInfo == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ModelState.Clear(); supplier.SupplierId = suppliersInfo.SupplierId; supplier.EntryBy = suppliersInfo.EntryBy; supplier.EntryDate = suppliersInfo.EntryDate; supplier.DelStatus = suppliersInfo.DelStatus; TryValidateModel(supplier); if (!ModelState.IsValid) { return(View(supplier)); } _db.SuppliersInfos .Where(x => x.Id == id) .Update(u => new SuppliersInfo { SupplierName = supplier.SupplierName, SupplierEmail = supplier.SupplierEmail, SupplierPhone = supplier.SupplierPhone, SupplierAddress = supplier.SupplierAddress, SupplierMobileNo = supplier.SupplierMobileNo }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Edit([Bind(Include = "Id,AccountId,Date,PayerType,Amount,MethodId,PayerId,Description")] DepositViewModel deposit, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!_db.TransactionsInfos.Any(x => x.Id == id)) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!ModelState.IsValid) { return(View(deposit)); } var count = _db.TransactionsInfos .Where(x => x.Id == id) .Update(u => new TransactionsInfo { Date = deposit.Date, AccountTo = deposit.AccountId, PayerType = deposit.PayerType, PayerId = deposit.PayerId, Amount = deposit.Amount, MethodId = deposit.MethodId, Description = deposit.Description }); if (count > 0) { _db.UpdateBalance(_db.BankAccounts.Find(deposit.AccountId), (double)deposit.Amount); } dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.Accounts = new SelectList(_db.BankAccounts.ToList(), "Id", "AccountName", deposit.AccountId); ViewBag.PayerTypes = Common.ToSelectList <PayerType>(deposit.PayerType); ViewBag.PaymentMethods = new SelectList(_db.PaymentMethods.ToList(), "Id", "MethodName", deposit.MethodId); } } }
public ActionResult Edit([Bind(Include = "Id,MethodName")] PaymentMethod paymentMethod, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (_db.PaymentMethods.Count(x => x.Id == id) < 1) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var method = _db.PaymentMethods.Single(x => x.Id == id); if (method == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } ModelState.Clear(); paymentMethod.MethodId = method.MethodId; paymentMethod.CurrentValue = method.CurrentValue; paymentMethod.EntryBy = method.EntryBy; paymentMethod.EntryDate = method.EntryDate; paymentMethod.DelStatus = method.DelStatus; TryValidateModel(paymentMethod); if (!ModelState.IsValid) { return(View(paymentMethod)); } _db.PaymentMethods .Where(x => x.Id == id) .Update(u => new PaymentMethod { MethodName = paymentMethod.MethodName }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Edit([Bind(Include = "Id,BranchName,BranchCode,Status")] BranchInfo branchInfo, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.BadRequest; return(RedirectToAction("Index")); } if (_db.BranchInfos.Count(x => x.Id == id) < 1) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var branch = _db.BranchInfos.Single(x => x.Id == id); ModelState.Clear(); branchInfo.BranchId = branch.BranchId; branchInfo.DelStatus = branch.DelStatus; branchInfo.EntryBy = branch.EntryBy; branchInfo.EntryDate = branch.EntryDate; TryValidateModel(branchInfo); if (!ModelState.IsValid) { return(View(branchInfo)); } _db.BranchInfos .Where(x => x.Id == id) .Update(u => new BranchInfo { BranchName = branchInfo.BranchName, BranchCode = branchInfo.BranchCode, Status = branchInfo.Status }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.StatusList = Common.ToSelectList <Status>(branchInfo.Status); } } }
public ActionResult Edit([Bind(Include = "Id,AccountFrom,AccountTo,Date,Amount,MethodId,Description")] TransferViewModel transfer, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!_db.TransactionsInfos.Any(x => x.Id == id && x.TransactionType == TransactionType.Transfer)) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!ModelState.IsValid) { return(View(transfer)); } var count = _db.TransactionsInfos .Where(x => x.Id == id) .Update(u => new TransactionsInfo { Date = transfer.Date, AccountTo = transfer.AccountTo, AccountFrom = transfer.AccountFrom, Amount = transfer.Amount, MethodId = transfer.MethodId, Description = transfer.Description }); if (count > 0) { _db.UpdateBalance(_db.BankAccounts.Find(transfer.AccountFrom), (double)transfer.Amount, BalanceMode.Decrement); _db.UpdateBalance(_db.BankAccounts.Find(transfer.AccountTo), (double)transfer.Amount); } dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.FromAccounts = new SelectList(_db.BankAccounts.ToList(), "Id", "AccountName", transfer.AccountFrom); ViewBag.ToAccounts = new SelectList(_db.BankAccounts.ToList(), "Id", "AccountName", transfer.AccountTo); ViewBag.PaymentMethods = new SelectList(_db.PaymentMethods.ToList(), "Id", "MethodName", transfer.MethodId); } } }
public ActionResult Create([Bind(Include = "Id,BranchId,ReferralType,AgentId,SupplierId,FirstName,LastName,ContactNo,Referral,ReferralContactNo,ServiceId,AirLineId,OldFlightDate,ChangeFlightDate,AirLinePnr,GdsPnr,NewFlightDate,CollageName,CourseName,EmailAddress,ServiceCharge,Cost,Profit,Discount,DoneBy,WorkingStatus,DeliveryStatus,InfoStatus,Remark,VenueFromId,VenueToId,SmsNo,CountryId")] ClientInfo client) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { ModelState.Clear(); var branch = client.BranchId == null?_db.BranchInfos.First(x => x.BranchName == "Head" && x.BranchCode == "main") : _db.BranchInfos.First(x => x.Id == client.BranchId); client.CustomerId = string.Format("{0}{1:000000}{2:MMyy}", branch.BranchCode.ToUpper(), _db.ClientInfos.Count() + 1, DateTime.Now ); client.EntryBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; client.ServedBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; client.WorkingStatus = WorkingStatus.Pending; client.Status = Status.Inactive; client.InfoStatus = InformationUpdate.NotUpdated; client.DeliveryStatus = DeliveryStatus.NotDelivery; client.SmsConfirmation = SmsConfirmation.NotSendingSms; client.EntryDate = DateTime.Now; //use default branch as head if branch id not selected client.BranchId = branch.Id; client.FullName = client.LastName != null?string.Format("{0} {1}", client.FirstName, client.LastName) : client.FirstName; TryValidateModel(client); if (!ModelState.IsValid) { return(View(client)); } _db.ClientInfos.Add(client); _db.SaveChanges(); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.BranchList = new SelectList(_db.BranchInfos, "Id", "BranchName"); ViewBag.ReferralTypes = Common.ToSelectList <ReferralsType>(); ViewBag.IsRequireSupplier = Common.ToSelectList <RequireSuppiler>(RequireSuppiler.No); ViewBag.ServiceList = new SelectList(_db.ServiceInfos.OrderBy(x => x.ServiceName), "Id", "ServiceName"); } } }
public ActionResult AgentInfoReport() { try { ViewBag.Agents = new SelectList(_db.AgentInfos.ToList(), "Id", "AgentName"); return(View()); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index", "Home")); } }
public ActionResult SupplierPaymentReport() { try { ViewBag.Suppliers = new SelectList(_db.SuppliersInfos.ToList(), "Id", "SupplierName"); return(View()); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index", "Home")); } }
// GET: Agents/Create public ActionResult Create() { try { ViewBag.UserRoleList = new SelectList(_context.Roles.Where(u => !u.Name.Contains("Admin")).ToList(), "Name", "Name"); ViewBag.StatusList = Common.ToSelectList <Status>(); return(View()); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Edit(Group model, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!ModelState.IsValid) { dbTransaction.Dispose(); ViewBag.IsGroupIsAdmin = _db.Groups.Any(x => x.Id == id && x.Name.ToLower() == "admin"); return(View(model)); } if (!_db.Groups.Any(x => x.Id == id)) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var groupName = _db.Groups.Where(x => x.Id == id).Select(x => x.Name).First(); _db.Groups .Where(x => x.Id == id) .Update(u => new Group { Name = groupName.ToLower() == "admin" ? "Admin" : model.Name, Description = model.Description, Account = model.Account, Billing = model.Billing, Crm = model.Crm, Hrm = groupName.ToLower() == "admin", Report = model.Report, Setup = model.Setup }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Edit([Bind(Include = "Id,CountryName,CountryCode,DelStatus")] Country country, int?id) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (id == null) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } if (!_db.Countries.Any(x => x.Id == id)) { TempData["Toastr"] = Toastr.HttpNotFound; return(RedirectToAction("Index")); } var data = _db.Countries.Single(x => x.Id == id); ModelState.Clear(); country.DelStatus = data.DelStatus; country.EntryBy = data.EntryBy; country.EntryDate = data.EntryDate; TryValidateModel(country); if (!ModelState.IsValid) { return(View(country)); } _db.Countries .Where(x => x.Id == id) .Update(u => new Country { CountryName = country.CountryName, CountryCode = country.CountryCode }); dbTransaction.Commit(); TempData["Toastr"] = Toastr.Updated; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } } }
public ActionResult Create([Bind(Include = "Id,AccountFrom,AccountTo,Date,Amount,MethodId,Description")] TransferViewModel transfer) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { if (!ModelState.IsValid) { return(View(transfer)); } ModelState.Clear(); var transaction = new TransactionsInfo(); transaction.TransactionId = string.Format("DI-{0:000000}", _db.TransactionsInfos.Count(x => x.TransactionType == TransactionType.Deposit || x.TransactionType == TransactionType.Transfer) + 1); transaction.TransactionType = TransactionType.Transfer; transaction.Date = transfer.Date; transaction.AccountTo = transfer.AccountTo; transaction.AccountFrom = transfer.AccountFrom; transaction.Amount = transfer.Amount; transaction.MethodId = transfer.MethodId; transaction.Description = transfer.Description; _db.TransactionsInfos.Add(transaction); if (_db.SaveChanges() > 0) { _db.UpdateBalance(_db.BankAccounts.Find(transfer.AccountFrom), (double)transfer.Amount, BalanceMode.Decrement); _db.UpdateBalance(_db.BankAccounts.Find(transfer.AccountTo), (double)transfer.Amount); } dbTransaction.Commit(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } catch (Exception ex) { dbTransaction.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { var accounts = new SelectList(_db.BankAccounts.ToList(), "Id", "AccountName"); ViewBag.FromAccounts = accounts; ViewBag.ToAccounts = accounts; ViewBag.PaymentMethods = new SelectList(_db.PaymentMethods.ToList(), "Id", "MethodName"); } } }
// GET: Employees/Create public ActionResult Create() { try { ViewBag.Designations = new SelectList(_db.EmployeeDesignations, "Id", "DesignationTitleEn"); ViewBag.BloodGroups = Common.ToSelectList <BloodGroup>(); ViewBag.Levels = Common.ToSelectList <EmployeeLevel>(); return(View()); } catch (Exception ex) { TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "Id,OfficeName,AgentName,ContactName,MobileNo,Address,OfficeNo,FaxNo,Email,UserName,Password")] AgentInfo agent) { using (var transaction = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { try { ModelState.Clear(); agent.AgentId = string.Format("AI-{0:000000}", _db.AgentInfos.Count() + 1); agent.EntryBy = _db.Users.First(x => x.UserName == User.Identity.Name).Id; agent.EntryDate = DateTime.Now; TryValidateModel(agent); if (ModelState.IsValid) { var user = new ApplicationUser { Email = agent.Email, UserName = agent.UserName }; var ack = _userManager.Create(user, agent.Password); if (!ack.Succeeded) { transaction.Complete(); return(View(agent)); } _userManager.AddToRole(user.Id, "Agent"); _db.AgentInfos.Add(agent); _db.SaveChanges(); transaction.Complete(); TempData["Toastr"] = Toastr.Added; return(RedirectToAction("Index")); } Transaction.Current.Rollback(); return(View(agent)); } catch (Exception ex) { Transaction.Current.Rollback(); TempData["Toastr"] = Toastr.DbError(ex.Message); return(RedirectToAction("Index")); } finally { ViewBag.StatusList = Common.ToSelectList <Status>(); } } }