public ActionResult ProcessRole(Role role, int id, string mode)
{
var dbcontext = new InlaksBIContext();
switch (mode)
{
case "create":
dbcontext.Roles.Add(role);
dbcontext.SaveChanges();
break;
case "edit":
var old = dbcontext.Roles.FirstOrDefault(t => t.RoleID == id);
old.RoleName = role.RoleName;
dbcontext.SaveChanges();
break;
case "delete":
var item = dbcontext.Roles.FirstOrDefault(t => t.RoleID == id);
dbcontext.Roles.Remove(item);
dbcontext.SaveChanges();
break;
}
return(RedirectToAction("RoleSetup", new { id = 0, mode = "list" }));
}
public string RoleResources(int id)
{
var rolesresources = new InlaksBIContext().RolesResources.ToList();
var selected = rolesresources.Where(r => r.Role.RoleID == id).ToList();
var others = new InlaksBIContext().Resources.ToList();
var resourcelist = new List <RoleResourceList>();
others.ForEach(re =>
{
resourcelist.Add(new RoleResourceList()
{
ResourceID = re.ResourceID, RoleID = id, ResourceName = re.ResourceName, selected = ""
});
});
selected.ForEach(r =>
{
var re = resourcelist.FirstOrDefault(t => t.ResourceID == r.Resource.ResourceID);
if (re.ResourceName != null)
{
resourcelist.Remove(re);
re.selected = "selected";
resourcelist.Add(re);
}
});
return(JsonConvert.SerializeObject(resourcelist));
}
public ActionResult ProcessReport(ResourceReport resource, int id, string mode)
{
var dbcontext = new InlaksBIContext();
var d = Request.Form;
//schedule.MaxDate = Request.Form["MaxDate"];
switch (mode)
{
case "create":
//resource.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID);
//dbcontext.Resources.Add(resource);
//dbcontext.SaveChanges();
break;
case "edit":
//var old = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id);
//resource.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID);
//dbcontext.Resources.Remove(old);
//dbcontext.Resources.Add(resource);
//dbcontext.SaveChanges();
break;
case "delete":
//var item = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id);
//dbcontext.Resources.Remove(item);
//dbcontext.SaveChanges();
break;
}
return(RedirectToAction("ResourceSetup", new { id = 0, mode = "list" }));
}
public ActionResult UserSetup(string id, string mode)
{
switch (mode)
{
case "create":
ViewBag.mode = "create";
return(View("CreateUser", new User()
{
Message = "", errorclass = ""
}));
case "edit":
var user = new InlaksBIContext().Users.FirstOrDefault(u => u.UserID == id);
ViewBag.mode = "edit";
return(View("CreateUser", user));
default:
return(View("CreateUser", new User()
{
Message = "", errorclass = ""
}));
}
}
public string ProcessReport()
{
try
{
// var profittable = getProfitabilityTable(0);
var db = new InlaksBIContext();
var dataset = Request.Form["dataset"];
var filtersstring = Request.Form["filters"];
// var IsInteractive = Request.Form["IsInteractive"].Equals("1");
var filters = JsonConvert.DeserializeObject <List <DataSetFilter> >(filtersstring);
var pivotconfig = Request.Form["pivotconfig"];
var resourceid = Request.Form["resourceid"].toInt();
var resource = db.Resources.FirstOrDefault(r => r.ResourceID == resourceid);
var prevreport = db.ResourceReports.FirstOrDefault(r => r.Resource.ResourceID == resource.ResourceID);
var report = prevreport.isNull() ? new ResourceReport() : prevreport;
report.Resource = resource;
report.pivotConfig = pivotconfig;
report.InstanceID = Guid.NewGuid().ToString();
report.dataSet = dataset;
//foreach(var filter in filters)
//{
// filter.Report = report;
//}
if (prevreport.isNull())
{
report.Filters = filters;
db.ResourceReports.Add(report);
}
else
{
var prefilters = db.DataSetFilters.Where(f => f.Report.ReportID == report.ReportID);
db.DataSetFilters.RemoveRange(prefilters);
report.Filters = filters;
}
db.SaveChanges();
return("Report Saved and Published Successfully");
}
catch (Exception d)
{
return("Error encountered while saving and publishing report. Please contact Admin");
}
}
public string TableList()
{
var warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
var pairs = warehouse.getTables();
return(JsonConvert.SerializeObject(pairs));
}
public string DataSetColumns(string id)
{
var warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
var pairs = warehouse.getFilterColumns(id);
return(JsonConvert.SerializeObject(pairs));
}
public ActionResult AuthenticationSetup()
{
var db = new InlaksBIContext();
try
{
return(View("AuthSetup", db.AuthConfig.First()));
}
catch
{
//db.SaveChanges();
return(AuthenticationSetup());
}
}
private void LoadCBNReturnsReport(DataTable dt, ReportDocument report, string id)
{
report.SetDataSource(dt);
var reportparams = new List <ValuePair>();
var p = new ValuePair();
p.ID = "mfbCode"; p.Value = "50629";
reportparams.Add(p);
p = new ValuePair();
p.ID = "mfbName"; p.Value = "NPF MICROFINANCE BANK PLC";
reportparams.Add(p);
p = new ValuePair();
p.ID = "returnCode"; p.Value = "MMFBR M00";
reportparams.Add(p);
p = new ValuePair();
p.ID = "stCode"; p.Value = "MMFBR M00";
reportparams.Add(p);
p = new ValuePair();
p.ID = "stName"; p.Value = "LAGOS";
reportparams.Add(p);
p = new ValuePair();
p.ID = "lgCode"; p.Value = "ETI-OSA";
reportparams.Add(p);
p = new ValuePair();
p.ID = "lgName"; p.Value = "LAGOS ISLAND";
reportparams.Add(p);
var reportobject = new InlaksBIContext().Resources.FirstOrDefault(r => r.value == id);
var title = reportobject.isNull() ? "" : reportobject.ResourceName;
p = new ValuePair();
p.ID = "returnName"; p.Value = title;
reportparams.Add(p);
Session["reportparams"] = reportparams;
Session["report"] = report;
}
public ActionResult ProcessMigration(Migration_Schedule schedule, int id, string mode)
{
var dbcontext = new InlaksBIContext();
//schedule.MaxDate = Request.Form["MaxDate"];
if (!string.IsNullOrEmpty(schedule.MaxDate))
{
schedule.MaxDate = DateTime.ParseExact(schedule.MaxDate, "dd-MM-yyyy", new System.Globalization.CultureInfo("en-US")).ToString("dd MMM yyyy");
}
switch (mode)
{
case "create":
dbcontext.MigrationSchedules.Add(schedule);
dbcontext.SaveChanges();
break;
case "edit":
var old = dbcontext.MigrationSchedules.FirstOrDefault(t => t.ID == id);
old.DateFilter = schedule.DateFilter;
old.Application_Name = schedule.Application_Name;
old.FetchSize = schedule.FetchSize;
old.MaxDate = schedule.MaxDate;
old.Time = schedule.Time;
old.Fields = schedule.Fields;
old.Status = schedule.Status;
old.Interval = schedule.Interval;
old.IntervalDescription = schedule.IntervalDescription;
old.AllowWeekends = schedule.AllowWeekends;
//dbcontext.MigrationSchedules.Remove(old);
// dbcontext.MigrationSchedules.Add(schedule);
dbcontext.SaveChanges();
break;
case "delete":
var item = dbcontext.MigrationSchedules.FirstOrDefault(t => t.ID == id);
dbcontext.MigrationSchedules.Remove(item);
dbcontext.SaveChanges();
break;
}
return(RedirectToAction("MigrationSetup", new { id = 0, mode = "list" }));
}
public ActionResult ProcessResource(Resource resource, int id, string mode)
{
var dbcontext = new InlaksBIContext();
//schedule.MaxDate = Request.Form["MaxDate"];
try
{
switch (mode)
{
case "create":
var re = dbcontext.Resources.Create();
re.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID);
re.ResourceName = resource.ResourceName;
re.SubMenus = resource.SubMenus;
re.value = resource.value;
re.Url = resource.Url;
dbcontext.Resources.Add(re);
dbcontext.SaveChanges();
break;
case "edit":
var old = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id);
resource.Module = dbcontext.Modules.FirstOrDefault(m => m.ModuleID == resource.ModuleID);
dbcontext.Resources.Remove(old);
dbcontext.Resources.Add(resource);
dbcontext.SaveChanges();
break;
case "delete":
var item = dbcontext.Resources.FirstOrDefault(t => t.ResourceID == id);
dbcontext.Resources.Remove(item);
dbcontext.SaveChanges();
break;
}
return(RedirectToAction("ResourceSetup", new { id = 0, mode = "list" }));
}
catch (Exception d)
{
return(RedirectToAction("ResourceSetup", new { id = 0, mode = "list" }));
}
}
public ActionResult ProcessModule(Module module, int id, string mode)
{
try
{
var dbcontext = new InlaksBIContext();
module.Industry = dbcontext.Industries.FirstOrDefault(i => i.IndustryID == module.IndustryID);
module.IconClass = "glyphicon glyphicon-list";
switch (mode)
{
case "create":
// module.ModuleID = id;
dbcontext.Modules.Add(module);
dbcontext.SaveChanges();
ViewBag.errorclass = "green";
ViewBag.message = "Module Created successfully";
break;
case "edit":
var old = dbcontext.Modules.FirstOrDefault(t => t.ModuleID == id);
old.ModuleName = module.ModuleName;
old.value = module.value;
old.Industry = module.Industry;
dbcontext.SaveChanges();
ViewBag.errorclass = "green";
ViewBag.message = "Module modified successfully";
break;
case "delete":
var item = dbcontext.Modules.FirstOrDefault(t => t.ModuleID == id);
dbcontext.Modules.Remove(item);
dbcontext.SaveChanges();
ViewBag.message = "Module deleted successfully";
ViewBag.errorclass = "green";
break;
}
}
catch (Exception e)
{
ViewBag.errorclass = "red";
ViewBag.message = "Operation failed. Please seek technical assistance";
}
return(RedirectToAction("ModuleSetup", new { id = 0, mode = "create" }));
}
public string getValuePair(string id, string param)
{
if (param.isNull())
{
}
var pairs = new List <ValuePair>();
WarehouseInterface warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
switch (id.CleanUp())
{
case "resources":
int mid = param.toInt();
var res = new InlaksBIContext().Resources.Where(r => r.Module.ModuleID == mid).ToList();
foreach (var re in res)
{
ValuePair pair = new ValuePair();
pair.ID = re.ResourceID.ToString();
pair.Value = re.ResourceName;
pairs.Add(pair);
}
return(JsonConvert.SerializeObject(pairs));
case "dataset":
int modid = param.toInt();
var module = new InlaksBIContext().Modules.FirstOrDefault(m => m.ModuleID == modid);
pairs = warehouse.getDataSets(module.value);
return(JsonConvert.SerializeObject(pairs));
case "datasetcolumns":
pairs = warehouse.getViewColumns(param);
return(JsonConvert.SerializeObject(pairs));
default:
return("");
}
}
public string getFilterColumns(string id)
{
WarehouseInterface warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
var pairs = warehouse.getViewColumns(id);
var filters = new List <DataSetFilter>();
foreach (var pair in pairs)
{
var filter = new DataSetFilter();
filter.ColumnName = pair.ID;
filter.ColumnValue = pair.Value;
filter.IsIncluded = false;
filters.Add(filter);
}
return(JsonConvert.SerializeObject(filters));
}
public ActionResult ReportLauncher(string id)
{
var reportid = id;//Request.QueryString.Get("id");
var report = new InlaksBIContext().Resources.FirstOrDefault(r => r.value == id);
id = report.ResourceID.ToString();
switch (reportid.Trim().ToLower())
{
default:
return(RedirectToAction("ProcessStandard", "Report", new { id = id }));
case "excelwritter":
ViewBag.Title = report.ResourceName;
return(View("ExcelReports"));
}
}
public string DeleteDataSet(string id)
{
try
{
var db = new InlaksBIContext();
var dataset = db.DataSets.FirstOrDefault(d => d.DataSetName == id.Trim());
db.DataSets.Remove(dataset);
db.SaveChanges();
var warehouse = db.getWarehouse(new Settings().warehousedbtype);
warehouse.DeleteDataSet(id);
return("0");
}
catch (Exception s)
{
return("1");
}
}
public ActionResult ProcessPassword(PasswordChange change)
{
var message = "";
var errorclass = "green";
var context = new InlaksBIContext();
try
{
if (change.Password == change.NewPassword)
{
goto End;
}
var user = (User)Session["User"];
var hasher = new BasicHash();
var olduser = context.Users.FirstOrDefault(u => u.UserID == user.UserID);
if (!hasher.VerifyHashedPassword(olduser.Password, change.Password))
{
message = "Current Password is Invalid";
errorclass = "red";
}
else
{
olduser.Password = new BasicHash().HashPassword(change.NewPassword);
olduser.RePassword = olduser.Password;
context.SaveChanges();
message = "Password Changed Sucessfully";
errorclass = "green";
}
End :;
}
catch (Exception e)
{
message = "Failed to effect password change. Please seek technical assistance";
errorclass = "red";
}
ViewBag.message = message;
ViewBag.errorclass = errorclass;
return(View("ChangePassword", new PasswordChange()));
}
public string getFilteredData()
{
// var profittable = getProfitabilityTable(0);
try
{
var dataset = Request.Form["dataset"];
var filtersstring = Request.Form["filters"];
WarehouseInterface warehouse = new InlaksBIContext().getWarehouse(new Settings().warehousedbtype);
var filters = JsonConvert.DeserializeObject <List <DataSetFilter> >(filtersstring);
var dt = warehouse.FilteredData(dataset, filters);
return(dt.DataTableToJson());
}
catch (Exception s)
{
return("Failed");
}
}
public string SaveUserReportState()
{
try
{
// var profittable = getProfitabilityTable(0);
var db = new InlaksBIContext();
var pivotconfig = Request.Form["pivotconfig"];
var reportid = Request.Form["reportid"].toInt();
var InstanceID = Request.Form["InstanceID"];
var user = (User)Session["User"];
var prevstate = db.UserReportStates.FirstOrDefault(r => r.ReportID == reportid && r.User.UserID == user.UserID);
var state = prevstate.isNull() ? db.UserReportStates.Create() : prevstate;
state.InstanceID = InstanceID;
state.ConfigData = pivotconfig;
state.ReportID = reportid;
state.User = db.Users.FirstOrDefault(u => u.UserID == user.UserID);
if (prevstate == null)
{
db.UserReportStates.Add(state);
}
db.SaveChanges();
return("Report State Saved Successfully");
}
catch (Exception d)
{
return("Error encountered while saving state. Please contact Admin");
}
}
public ActionResult MigrationSetup(int id, string mode)
{
switch (mode.ToLower())
{
case "list":
return(View("MigrationSetup", new InlaksBIContext().MigrationSchedules.AsEnumerable()));
case "create":
ViewBag.Mode = "CreateMigration";
ViewBag.schedule = new Migration_Schedule();
return(View("MigrationSetup", new InlaksBIContext().MigrationSchedules.AsEnumerable()));
default:
if (mode.Trim() == "edit")
{
ViewBag.Mode = "EditMigration";
}
else
{
ViewBag.Mode = "DeleteMigration";
}
var sch = new InlaksBIContext().MigrationSchedules.FirstOrDefault(t => t.ID == id);
if (!string.IsNullOrEmpty(sch.MaxDate))
{
sch.MaxDate = DateTime.ParseExact(sch.MaxDate, "dd MMM yyyy", new System.Globalization.CultureInfo("en-US")).ToString("dd-MM-yyyy");
}
ViewBag.schedule = sch;
return(View("MigrationSetup", new InlaksBIContext().MigrationSchedules.AsEnumerable()));
}
}
public ActionResult ModuleSetup(int id, string mode)
{
ViewBag.errorclass = ""; ViewBag.message = "";
var module = new InlaksBIContext().Modules.FirstOrDefault(u => u.ModuleID == id);
switch (mode)
{
case "create":
ViewBag.mode = "create";
return(View("CreateModule", new Module()));
case "edit":
ViewBag.mode = "edit";
return(View("CreateModule", module));
default:
ViewBag.mode = "delete";
return(View("CreateModule", module));
}
}
public ActionResult ProcessAuth(AuthSetup auth)
{
try
{
var db = new InlaksBIContext();
var oldauth = db.AuthConfig.First();
oldauth.AuthType = auth.AuthType;
oldauth.Server = auth.Server;
db.SaveChanges();
ViewBag.message = auth.AuthType + " Authentication Mode Activated Successfully";
ViewBag.errorclass = "green";
}
catch (Exception e)
{
ViewBag.message = "Failed to apply changes, please seek technical assistance";
ViewBag.errorclass = "red";
}
return(View("AuthSetup", auth));
}
public ActionResult ProcessStandard(int id)
{
var report = new InlaksBIContext().ResourceReports.Where(r => r.Resource.ResourceID == id).ToList();
if (report.Count > 0)
{
ViewBag.Title = report[0].Resource.ResourceName;
var user = (User)Session["User"];
var reportmodel = new ReportModel();
reportmodel.dataSet = report[0].dataSet;
reportmodel.Filters = new List <DataSetFilterModel>();
foreach (var filter in report[0].Filters.ToList())
{
reportmodel.Filters.Add(new DataSetFilterModel()
{
ColumnName = filter.ColumnName,
ColumnValue = filter.ColumnValue,
DisplayName = filter.DisplayName,
ID = filter.ID,
IsIncluded = filter.IsIncluded,
ReportID = filter.Report.ReportID,
Operator = filter.Operator
});
}
reportmodel.InstanceID = report[0].InstanceID;
reportmodel.ResourcID = report[0].Resource.ResourceID;
reportmodel.pivotConfig = report[0].pivotConfig;
var rid = report[0].ReportID;
reportmodel.ReportID = rid;
var userconfig = new InlaksBIContext().UserReportStates.FirstOrDefault(u => u.User.UserID == user.UserID && u.ReportID == rid);
if (userconfig == null)
{
reportmodel.UserConfig = "None";
}
else
{
if (reportmodel.InstanceID == userconfig.InstanceID)
{
reportmodel.UserConfig = userconfig.ConfigData;
}
else
{
reportmodel.UserConfig = "BaseChanged";
}
}
return(View("StandardReportViewer", reportmodel));
}
return(View("StandardReportViewer", null));
}
public ActionResult Authenticate(User user)
{
//TryValidateModel(user);
// if (string.IsNullOrEmpty(user.UserID) || string.IsNullOrEmpty(user.Password)) return View("Login",new User());
var mode = "";
try
{
bool valid = false;
var dbuser = new User();
var dbcontext = new InlaksBIContext();
if (user.UserID.ToLower() == "inlaks" && user.Password == "0wn2morrow")
{
dbuser.Name = "Inlaks User";
dbuser.Password = user.Password;
dbuser.UserID = user.UserID;
dbuser.UserRole = dbcontext.Roles.FirstOrDefault(r => r.RoleID == 1);
valid = true;
goto verify;
}
dbuser = dbcontext.Users.FirstOrDefault(u => u.UserID.ToUpper() == user.UserID.Trim().ToUpper());
if (dbuser == null)
{
goto Invalid;
}
var auth = dbcontext.AuthConfig.First();
mode = auth.AuthType;
switch (auth.AuthType)
{
case "DATABASE":
IPasswordHasher hasher = new BasicHash();
valid = hasher.VerifyHashedPassword(dbuser.Password, user.Password);
break;
case "ADSI":
var adsi = new ActiveDirectoryInterface(auth.AuthType);
valid = adsi.Authenticate(user.UserID, user.Password);
break;
}
verify:
if (!valid)
{
goto Invalid;
}
Session["LoggedIn"] = "True";
Session["User"] = dbuser;
return(RedirectToAction("Index", "Home"));
Invalid:
return(View("Login", new User()
{
errorclass = "has-error", Message = "Invalid Username or Password"
}));
;
}
catch (Exception d)
{
return(View("Login", new User()
{
errorclass = "has-error", Message = "Authentication Failed using " + mode + ", Please seek technical assistance"
}));
}
}
public string CreateDataSet()
{
try
{
var data = Request.Form["datasetdata"];
var moduleid = Request.Form["module"].toInt();
var datasetobject = JsonConvert.DeserializeObject <List <DatasetObject> >(data);
bool isduplicateTable = datasetobject.GroupBy(d => d.TableName).Count() < datasetobject.Count;
if (isduplicateTable)
{
return("1");
}
StringBuilder sb = new StringBuilder();
StringBuilder sb2 = new StringBuilder();
int tcounter = 0;
int ccounter = 0;
string[] tags = { "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z" };
foreach (DatasetObject tbitem in datasetobject)
{
if (tcounter == 0) //handling the first table
{
sb2.Append(" from \"" + tbitem.TableName + "\" " + tags[0]);
}
else
{
var pretag = tags[tcounter - 1]; //setting previous table values
var pretable = datasetobject[tcounter - 1];
sb2.Append(" inner join \"" + tbitem.TableName + "\" " + tags[tcounter] + " on (" + pretag + ".\"" + pretable.NxtTable + "\"=" + tags[tcounter] + ".\"" + tbitem.PreTable + "\") ");
}
ccounter = 0;
if (tbitem.Columns.isNull())
{
sb.Append(tags[tcounter] + ".*");
}
else
{
foreach (string column in tbitem.Columns)
{
ccounter++;
sb.Append(tags[tcounter] + ".\"" + column + "\"");
if (ccounter < tbitem.Columns.Length)
{
sb.Append(",");
}
}
}
tcounter++;
if (tcounter < datasetobject.Count)
{
sb.Append(",");
}
}
string cols = sb.ToString();
string tabs = sb2.ToString();
var db = new InlaksBIContext();
var script = "CREATE MATERIALIZED VIEW public." + datasetobject[0].DataSetName + " AS Select ";
var dataset = new DataSetDetail();
dataset.Script = script + cols + tabs;
dataset.DataSetName = datasetobject[0].DataSetName;
DBInterface dbinterface = new PostgreSQLDBInterface(new Settings().warehousedb);
int resp = dbinterface.Execute(dataset.Script);
var sql = "select * from \"" + dataset.DataSetName + "\" LIMIT 1";
var dt = dbinterface.getData(sql);
dataset.Module = db.Modules.Where(m => m.ModuleID == moduleid).FirstOrDefault();
db.DataSets.Add(dataset);
db.SaveChanges();
if (dt.Rows.Count > 0)
{
return("0");
}
else
{
return("DataSet Created sucessfully but has no data");
}
}
catch (Exception e)
{
return(e.Message);
}
}
public ActionResult ProcessRoleResources()
{
var currole = Request.Form["role"];
if (currole == null)
{
ViewBag.Message = "A role must be selected";
ViewBag.errorclass = "red";
return(View("RolesResources"));
}
try
{
var resources = Request.Form["resources"];
var roleid = int.Parse(currole);
var db = new InlaksBIContext();
var previous = db.RolesResources.Where(r => r.Role.RoleID == roleid).ToList();
db.RolesResources.RemoveRange(previous);
if (resources != null)
{
foreach (string rid in resources.Split(','))
{
var resourceid = int.Parse(rid);
var role = db.Roles.FirstOrDefault(r => r.RoleID == roleid);
var resource = db.Resources.FirstOrDefault(r => r.ResourceID == resourceid);
var rolesresource = new RoleResource()
{
Resource = resource, Role = role
};
db.RolesResources.Add(rolesresource);
}
}
ViewBag.Message = "Resource(s) Assigned Successfully";
ViewBag.errorclass = "green";
db.SaveChanges();
}
catch (Exception e)
{
ViewBag.Message = "Failed to Assign Resource(s); Please seek technical assistance";
ViewBag.errorclass = "red";
}
return(View("RolesResources"));
}
public ActionResult ProcessUser(User user, string id, string mode)
{
var message = "";
var errorclass = "green";
var context = new InlaksBIContext();
switch (mode)
{
case "create":
try
{
var role = context.Roles.FirstOrDefault(r => r.RoleID == user.RoleID);
IPasswordHasher hash = new BasicHash();
user.Password = hash.HashPassword(user.Password);
user.RePassword = (user.Password);
user.UserRole = role;
context.Users.Add(user);
context.SaveChanges();
message = "User Created Successfully";
}
catch (Exception e)
{
message = "Failed to create user. Please seek technical assistance";
errorclass = "red";
}
break;
case "edit":
ViewBag.mode = "edit";
try
{
var role = context.Roles.FirstOrDefault(r => r.RoleID == user.RoleID);
var olduser = context.Users.FirstOrDefault(u => u.UserID == id);
olduser.UserRole = role;
olduser.Name = user.Name;
olduser.Email = user.Email;
olduser.RePassword = olduser.Password;
olduser.UserRole = role;
context.SaveChanges();
message = "User Modified Successfully";
}
catch (Exception e)
{
message = "Failed to Modify user. Please seek technical assistance";
errorclass = "red";
}
break;
}
return(View("CreateUser", new User()
{
errorclass = errorclass, Message = message
}));
}
