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