public bool AddAdmin(AdminsGridView amO) { try { using (var context = MangContext) { var exCnt = (from x in context.EmailMasters where x.Address == amO.Address.Trim() select x).Count(); if (exCnt > 0) { throw new Exception("address already exists"); } context.EmailMasters.Add(new EmailMaster { Address = amO.Address, ADMIN = amO.Status }); if (context.SaveChanges() > 0) { return(true); } } } catch (Exception ex) { ErrorFlag = true; ErrorMessage = ex.Message; } return(false); }
public bool EditAdmin(AdminsGridView amO) { try { using (var context = MangContext) { var sql = @"Update EmailMaster SET Address = @address, ADMIN = @status WHERE id = @id"; var rows = context.Database.ExecuteSqlCommand (sql, new SqlParameter("@address", amO.Address), new SqlParameter("@status", amO.Status), new SqlParameter("@id", amO.id)); if (rows > 0) { return(true); } } } catch (Exception ex) { ErrorFlag = true; ErrorMessage = ex.Message; } return(false); }
public AdminsGridView[] GetAdminGrid() { AdminsGridView[] grid_data = new AdminsGridView[] { }; try { grid_data = (from e in MangContext.EmailMasters select new AdminsGridView { id = e.id, Address = e.Address.Trim(), Status = e.ADMIN }).ToArray(); } catch (Exception ex) { ErrorFlag = true; ErrorMessage = ex.Message; } return(grid_data); }
private void RefreshAdminsGridview() { Role admin_role = Role.GetRole("Archived"); current_company.Refresh(); EntityList <Permission> company_permissions = current_company.GetActivePermissions(); // Create the output table. DataTable adminList = new DataTable(); adminList.Columns.Add("PermissionID"); adminList.Columns.Add("Role"); adminList.Columns.Add("First Name"); adminList.Columns.Add("Last Name"); adminList.Columns.Add("Email"); adminList.Columns.Add("Phone"); adminList.Columns.Add("Position"); foreach (Permission item in company_permissions) { DataRow new_row = adminList.NewRow(); new_row["PermissionID"] = item.permission_id; new_row["Role"] = item.role_name.role_name; new_row["First Name"] = item.admin_.first_name; new_row["Last Name"] = item.admin_.last_name; new_row["Email"] = item.admin_.email; new_row["Phone"] = item.admin_.phone; new_row["Position"] = item.company_position; adminList.Rows.Add(new_row); } AdminsGridView.DataSource = adminList; AdminsGridView.DataBind(); }
public JsonResult SaveAM(string method, int id, string address, bool status, string nav) { var rObject = new MethodResponse() { Result = true, ErrorMessage = "", Content = new Models.WorkroomsUserObject[] { } }; Helpers.AdminService service = new Helpers.AdminService(); try { if (id == 0 && method != "am_add") { throw new Exception("email id not recieved"); } if (address.Length == 0 && method != "am_delete") { throw new Exception("email address not recieved"); } var amO = new AdminsGridView() { id = id, Address = address, Status = status, }; switch (method) { case "am_add": rObject.Result = service.AddAdmin(amO); break; case "am_edit": rObject.Result = service.EditAdmin(amO); break; case "am_delete": rObject.Result = service.DeleteAdmin(amO.id); break; default: rObject.ErrorMessage = "control handler error"; rObject.Result = false; break; } } catch (Exception ex) { rObject.Result = false; rObject.ErrorMessage = ex.Message; } if (rObject.Result == true) { removeCacheHTML(nav); service.ClearAdminEmailCache(); } else { rObject.ErrorMessage = service.ErrorMessage; } return(Json(rObject)); }