public string LogError(LogErrorModel logErrorModel)
{
string success;
try
{
using (var mdb = new OggleBoobleMySqContext())
{
mdb.ErrorLogs.Add(new ErrorLog()
{
PkId = Guid.NewGuid().ToString(),
ActivityCode = logErrorModel.ActivityCode,
ErrorMessage = logErrorModel.ErrorMessage,
CalledFrom = logErrorModel.CalledFrom,
Severity = logErrorModel.Severity,
VisitorId = logErrorModel.VisitorId,
Occured = DateTime.Now
});
mdb.SaveChanges();
success = "ok";
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public string RegisterUser(RegisteredUser registeredUserModel)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
RegisteredUser dbRegisteredUser = db.RegisteredUsers.Where(u => u.UserName == registeredUserModel.UserName).FirstOrDefault();
if (dbRegisteredUser != null)
{
success = "user name already exists";
}
else
{
registeredUserModel.Pswrd = HashSHA256(registeredUserModel.Pswrd);
registeredUserModel.Created = DateTime.Now;
//registeredUserModel.IpAddress = Helpers.GetIPAddress();
db.RegisteredUsers.Add(registeredUserModel);
db.SaveChanges();
success = "ok";
}
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public VerifyVisitorSuccessModel verifyVisitorId(string visitorId)
{
VerifyVisitorSuccessModel visitorSuccessModel = new VerifyVisitorSuccessModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
var dbVisitor = db.Visitors.Where(v => v.VisitorId == visitorId).FirstOrDefault();
if (dbVisitor == null)
{
visitorSuccessModel.Exists = false;
}
else
{
visitorSuccessModel.Exists = true;
visitorSuccessModel.IpAddress = dbVisitor.IpAddress;
}
visitorSuccessModel.Success = "ok";
}
}
catch (Exception ex)
{
visitorSuccessModel.Success = Helpers.ErrorDetails(ex);
}
return(visitorSuccessModel);
}
public RefModel Get(string refType)
{
var refs = new RefModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
IList <Ref> dbrefs = db.Refs.Where(r => r.RefType == refType).OrderBy(r => r.RefDescription).ToList();
foreach (Ref r in dbrefs)
{
refs.refItems.Add(new RefItem()
{
RefCode = r.RefCode,
RefType = r.RefType,
RefDescription = r.RefDescription
});
}
refs.Success = "ok";
}
}
catch (Exception ex)
{
refs.Success = Helpers.ErrorDetails(ex);
}
return(refs);
}
/// helper apps
private string GetUniqueRefCode(string refDescription, OggleBoobleMySqContext db)
{
if (refDescription.Length < 3)
{
refDescription = refDescription.PadRight(3, 'A');
}
var refCode = refDescription.Substring(0, 3).ToUpper();
Ref exists = new Ref();
while (exists != null)
{
exists = db.Refs.Where(r => r.RefCode == refCode).FirstOrDefault();
if (exists != null)
{
char nextLastChar = refCode.Last();
if (nextLastChar == ' ')
{
nextLastChar = 'A';
}
if (nextLastChar == 'Z')
{
nextLastChar = 'A';
}
else
{
nextLastChar = (char)(((int)nextLastChar) + 1);
}
refCode = refCode.Substring(0, 2) + nextLastChar;
}
}
return(refCode);
}
public ActivityReportModel ActivityReport()
{
var activityReport = new ActivityReportModel();
try
{
using (var db = new OggleBoobleMySqContext())
{
db.EventLogs.RemoveRange(db.EventLogs.Where(e => e.VisitorId == "ec6fb880-ddc2-4375-8237-021732907510"));
db.SaveChanges();
List <DailyActivityReport> activityItems = db.DailyActivity.ToList();
foreach (var activityItem in activityItems)
{
activityReport.Items.Add(new ActiviyItem()
{
IpAddress = activityItem.IpAddress,
City = activityItem.City,
Region = activityItem.Region,
Country = activityItem.Country,
Event = activityItem.Event,
CalledFrom = activityItem.CalledFrom,
Detail = activityItem.Detail,
HitDate = activityItem.HitDate,
HitTime = activityItem.HitTime
});
}
activityReport.HitCount = db.EventLogs.Where(h => h.Occured > DateTime.Today).Count();
}
activityReport.Success = "ok";
}
catch (Exception ex) { activityReport.Success = Helpers.ErrorDetails(ex); }
return(activityReport);
}
public MetricsMatrixResults MetricsMatrixReport()
{
var metricsMatrixResults = new MetricsMatrixResults();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
db.PageHits.RemoveRange(db.PageHits.Where(h => h.VisitorId == "ec6fb880-ddc2-4375-8237-021732907510"));
db.ImageHits.RemoveRange(db.ImageHits.Where(i => i.VisitorId == "ec6fb880-ddc2-4375-8237-021732907510"));
db.SaveChanges();
//VwPageHit vwPageHit = dbm.VwPageHits.FirstOrDefault();
List <MetricsMatrix> matrices = db.VwMetricsMatrices.ToList();
foreach (MetricsMatrix matrix in matrices)
{
metricsMatrixResults.MatrixRows.Add(new MatrixRowModel()
{
Column = matrix.Column,
Today = matrix.Today,
Yesterday = matrix.Yesterday,
Two_Days_ago = matrix.Two_Days_ago,
Three_Days_ago = matrix.Three_Days_ago,
Four_Days_ago = matrix.Four_Days_ago,
Five_Days_ago = matrix.Five_Days_ago,
Six_Days_ago = matrix.Six_Days_ago
});
}
metricsMatrixResults.Success = "ok";
}
}
catch (Exception ex) { metricsMatrixResults.Success = Helpers.ErrorDetails(ex); }
return(metricsMatrixResults);
}
public RoleModel GetUserRoles(string userName, string whichType)
{
RoleModel roleModel = new RoleModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
if (whichType == "Assigned")
{
var x = db.UserRoles.Where(ur => ur.UserName == userName).Select(ur => ur.RoleName).ToList();
roleModel.RoleNames = db.UserRoles.Where(ur => ur.UserName == userName).Select(ur => ur.RoleName).ToList();
}
if (whichType == "Available")
{
List <string> assigned = db.UserRoles.Where(ur => ur.UserName == userName).Select(ur => ur.RoleName).ToList();
List <string> allRoles = db.Roles.Select(r => r.RoleName).ToList();
foreach (string alreadyAssignedRole in assigned)
{
allRoles.Remove(alreadyAssignedRole);
}
roleModel.RoleNames = allRoles;
}
roleModel.Success = "ok";
}
}
catch (Exception ex)
{
roleModel.Success = Helpers.ErrorDetails(ex);
}
return(roleModel);
}
public ErrorLogReportModel ErrorLogReport()
{
ErrorLogReportModel errorLog = new ErrorLogReportModel();
try
{
using (var mdb = new OggleBoobleMySqContext())
{
errorLog.ErrorRows = mdb.vwErrorReportRows.ToList();
//(from e in mdb.ErrorLogItems
// join v in mdb.Visitors on e.VisitorId equals v.VisitorId
// select new ErrorLogItem()
// {
// VisitorId = v.VisitorId,
// City = v.City,
// Country = v.Country,
// CalledFrom = e.CalledFrom,
// ActivityCode = e.ActivityCode,
// Severity = e.Severity,
// Occured = e.Occured,
// At = e.Occured.ToShortDateString(),
// On = e.Occured.AddHours(2).ToShortTimeString(),
// ErrorMessage = e.ErrorMessage
// }).OrderByDescending(e => e.Occured).Take(500).ToList();
errorLog.Success = "ok";
}
}
catch (Exception ex)
{
errorLog.Success = Helpers.ErrorDetails(ex);
}
return(errorLog);
}
public LogEventActivitySuccessModel LogEventActivity(LogEventModel logEventModel)
{
LogEventActivitySuccessModel logEventActivitySuccess = new LogEventActivitySuccessModel();
try
{
using (var mdb = new OggleBoobleMySqContext())
{
//--logEventModel.EventDetail = mdb.CategoryFolders.Where(f => f.Id == logEventModel.PageId).FirstOrDefault().FolderName;
mdb.EventLogs.Add(new EventLog()
{
EventCode = logEventModel.EventCode,
EventDetail = logEventModel.EventDetail,
CalledFrom = logEventModel.CalledFrom,
PageId = logEventModel.PageId,
VisitorId = logEventModel.VisitorId,
Occured = DateTime.Now
});
mdb.SaveChanges();
}
logEventActivitySuccess.Success = "ok";
}
//catch (SystemException sex) {
// //if (ex.Message.Contains("reference not set"))
// {
// logEventActivitySuccess.Success = "reference not set. Source: " + sex.Source;
// }
//}
catch (Exception ex)
{
logEventActivitySuccess.Success = Helpers.ErrorDetails(ex);
}
return(logEventActivitySuccess);
}
public string LogFeedBack(FeedBackModel feedBackModel)
{
string success = "";
try
{
using (var mdb = new OggleBoobleMySqContext())
{
mdb.FeedBacks.Add(new FeedBack()
{
FeedBackComment = feedBackModel.FeedBackComment,
FeedBackType = feedBackModel.FeedBackType,
PageId = feedBackModel.PageId,
FeedBackEmail = feedBackModel.FeedBackEmail,
VisitorId = feedBackModel.VisitorId,
Occured = DateTime.Now
});
mdb.SaveChanges();
success = "ok";
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public GetInfoSuccessModel GeFolderIdFromtPageName(string folderName)
{
GetInfoSuccessModel getInfoSuccess = new GetInfoSuccessModel();
try
{
using (OggleBoobleMySqContext dbm = new OggleBoobleMySqContext())
{
CategoryFolder categoryFolder = dbm.CategoryFolders.Where(f => f.FolderName == folderName).FirstOrDefault();
if (categoryFolder != null)
{
getInfoSuccess.PageId = categoryFolder.Id;
getInfoSuccess.Success = "ok";
}
else
{
getInfoSuccess.Success = "page not found";
}
}
}
catch (Exception ex)
{
getInfoSuccess.Success = Helpers.ErrorDetails(ex);
}
return(getInfoSuccess);
}
public RefItem Get(string refCode, string refType)
{
var refItem = new RefItem();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
Ref dbref = db.Refs.Where(r => r.RefType == refType && r.RefCode == refCode).FirstOrDefault();
if (dbref == null)
{
refItem.Success = "ref not found";
}
else
{
refItem.RefCode = dbref.RefCode;
refItem.RefDescription = dbref.RefDescription;
refItem.Success = "ok";
}
}
}
catch (Exception ex)
{
refItem.Success = Helpers.ErrorDetails(ex);
}
return(refItem);
}
public GetInfoSuccessModel GetVisitorIdFromIP(string ipAddress)
{
GetInfoSuccessModel getInfoSuccess = new GetInfoSuccessModel();
try
{
using (OggleBoobleMySqContext dbm = new OggleBoobleMySqContext())
{
Visitor visitor = dbm.Visitors.Where(v => v.IpAddress == ipAddress).FirstOrDefault();
if (visitor != null)
{
getInfoSuccess.VisitorId = visitor.VisitorId;
getInfoSuccess.Success = "ok";
}
else
{
getInfoSuccess.Success = "not found";
}
}
}
catch (Exception ex)
{
getInfoSuccess.Success = Helpers.ErrorDetails(ex);
}
return(getInfoSuccess);
}
public string VerifyLogin(string userName, string passWord)
{
string success = "";
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
string encryptedPassword = HashSHA256(passWord);
RegisteredUser dbRegisteredUser = db.RegisteredUsers.Where(u => u.UserName == userName && u.Pswrd == encryptedPassword).FirstOrDefault();
if (dbRegisteredUser != null)
{
//--record Login
success = "ok";
}
else
{
dbRegisteredUser = db.RegisteredUsers.Where(u => u.UserName == userName).FirstOrDefault();
if (dbRegisteredUser == null)
{
success = "user name not found";
}
else
{
success = "password fail";
}
}
}
return(success);
}
public LatestImageHitsReportModel LatestImageHits()
{
var imageHitsReportModel = new LatestImageHitsReportModel();
try
{
using (var db = new OggleBoobleMySqContext())
{
db.ImageHits.RemoveRange(db.ImageHits.Where(i => i.VisitorId == "ec6fb880-ddc2-4375-8237-021732907510"));
List <vwImageHit> imageHits = db.vwImageHits.ToList();
foreach (vwImageHit imageHit in imageHits)
{
imageHitsReportModel.Items.Add(new LatestImageHitsItem()
{
IpAddress = imageHit.IpAddress,
City = imageHit.City,
Region = imageHit.Region,
Country = imageHit.Country,
FolderName = imageHit.FolderName,
PageId = imageHit.PageId,
HitTime = imageHit.HitTime,
Link = imageHit.Link
});
}
imageHitsReportModel.HitCount = db.ImageHits.Where(h => h.HitDateTime > DateTime.Today).Count();
}
imageHitsReportModel.Success = "ok";
}
catch (Exception ex) { imageHitsReportModel.Success = Helpers.ErrorDetails(ex); }
return(imageHitsReportModel);
}
public string Post(RefItem refItem)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
Ref @ref = new Ref();
@ref.RefType = refItem.RefType;
@ref.RefCode = GetUniqueRefCode(refItem.RefDescription, db);
@ref.RefDescription = refItem.RefDescription;
db.Refs.Add(@ref);
db.SaveChanges();
//refModel.RefCode = @ref.RefCode;
success = "ok";
}
}
catch (Exception ex)
{
success = ex.Message;
}
return(success);
}
public List <string> UserPermissions(string userName)
{
List <string> roles = null;
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
roles = db.UserRoles.Where(r => r.UserName == userName).Select(r => r.RoleName).ToList();
}
return(roles);
}
public AddVisitorSuccessModel AddVisitor(AddVisitorModel visitorData)
{
var addVisitorSuccess = new AddVisitorSuccessModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
CategoryFolder categoryFolder = db.CategoryFolders.Where(f => f.Id == visitorData.PageId).FirstOrDefault();
if (categoryFolder != null)
{
addVisitorSuccess.PageName = categoryFolder.FolderName;
}
var existingVisitor = db.Visitors.Where(v => v.IpAddress == visitorData.IpAddress).FirstOrDefault();
if (existingVisitor != null)
{
addVisitorSuccess.VisitorId = existingVisitor.VisitorId;
addVisitorSuccess.IsNewVisitor = false;
}
else
{
// We have a new visitor!
//string dnsHostName = Dns.GetHostName();
//IPHostEntry ipEntry = Dns.GetHostEntry(dnsHostName);
//IPAddress[] iPAddresses = ipEntry.AddressList;
//string ipAddress = iPAddresses[iPAddresses.Length - 1].ToString();
string newVisitorId = Guid.NewGuid().ToString();
Visitor newVisitor = new Visitor()
{
VisitorId = newVisitorId,
InitialPage = visitorData.PageId,
City = visitorData.City,
Country = visitorData.Country,
GeoCode = visitorData.GeoCode,
Region = visitorData.Region,
InitialVisit = DateTime.Now,
IpAddress = visitorData.IpAddress
};
db.Visitors.Add(newVisitor);
db.SaveChanges();
addVisitorSuccess.VisitorId = newVisitorId;
addVisitorSuccess.IsNewVisitor = true;
}
addVisitorSuccess.Success = "ok";
}
}
catch (Exception ex)
{
addVisitorSuccess.Success = Helpers.ErrorDetails(ex);
}
return(addVisitorSuccess);
}
public UsersModel GetUsers()
{
UsersModel users = new UsersModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
users.UserNames = db.RegisteredUsers.Select(r => r.UserName).ToList();
users.Success = "ok";
}
}
catch (Exception ex) { users.Success = Helpers.ErrorDetails(ex); }
return(users);
}
public RoleModel GetRoles()
{
var roleModel = new RoleModel();
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
roleModel.RoleNames = db.Roles.Select(r => r.RoleName).ToList();
roleModel.Success = "ok";
}
}
catch (Exception ex) { roleModel.Success = Helpers.ErrorDetails(ex); }
return(roleModel);
}
public LogVisitSuccessModel LogVisit(string visitorId)
{
LogVisitSuccessModel visitSuccessModel = new LogVisitSuccessModel();
try
{
using (OggleBoobleMySqContext dbm = new OggleBoobleMySqContext())
{
DateTime lastVisitDate = DateTime.MinValue;
List <Visit> visitorVisits = dbm.Visits.Where(v => v.VisitorId == visitorId).ToList();
if (visitorVisits.Count() > 0)
{
lastVisitDate = dbm.Visits.Where(v => v.VisitorId == visitorId).OrderByDescending(v => v.VisitDate).FirstOrDefault().VisitDate;
}
if ((lastVisitDate == DateTime.MinValue) || ((DateTime.Now - lastVisitDate).TotalHours > 12))
{
Visitor visitor = dbm.Visitors.Where(v => v.VisitorId == visitorId).FirstOrDefault();
if (visitor != null)
{
dbm.Visits.Add(new Visit()
{
VisitorId = visitorId,
VisitDate = DateTime.Now // .AddMilliseconds(getrandom.Next())
});
dbm.SaveChanges();
visitSuccessModel.IsNewVisitor = true;
if (lastVisitDate == DateTime.MinValue)
{
visitSuccessModel.WelcomeMessage = "Welcome New Visitor";
}
else
{
//if(v)
visitSuccessModel.WelcomeMessage = "Welcome Back ";
}
}
}
visitSuccessModel.Success = "ok";
}
}
catch (Exception ex)
{
visitSuccessModel.Success = Helpers.ErrorDetails(ex);
}
return(visitSuccessModel);
}
public string Put(RefItem refItem)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
Ref @ref = db.Refs.Where(r => r.RefCode == refItem.RefCode).First();
@ref.RefDescription = refItem.RefDescription;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = ex.Message; }
return(success);
}
public string UpdateRoleName(string roleName, string newName)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
Role roleToUpdate = db.Roles.Where(r => r.RoleName == roleName).First();
roleToUpdate.RoleName = newName;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public bool IsInRole(string userName, string roleName)
{
bool isInRole = false;
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
var isAdmin = db.UserRoles.Where(r => r.UserName == userName && r.RoleName == "Oggle Admin");
if (isAdmin != null)
{
return(true);
}
UserRole userRole = db.UserRoles.Where(r => r.UserName == userName && r.RoleName == roleName).FirstOrDefault();
isInRole = userRole != null;
}
return(isInRole);
}
public string RemoveUserRole(string userName, string roleName)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
UserRole roleToDelete = db.UserRoles.Where(r => r.UserName == userName && r.RoleName == roleName).First();
db.UserRoles.Remove(roleToDelete);
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public ErrorLogReportModel ErrorLogReport()
{
ErrorLogReportModel errorLog = new ErrorLogReportModel();
try
{
using (var mdb = new OggleBoobleMySqContext())
{
errorLog.ErrorRows = mdb.vwErrorReportRows.ToList();
errorLog.Success = "ok";
}
}
catch (Exception ex)
{
errorLog.Success = Helpers.ErrorDetails(ex);
}
return(errorLog);
}
public ImageHitSuccessModel LogImageHit(logImageHItDataModel logImageHItData)
{
ImageHitSuccessModel imageHitSuccess = new ImageHitSuccessModel();
try
{
//System.Threading.Thread.Sleep(1000);
if (imageHitControllerBusy)
{
imageHitSuccess.Success = "imageHitController Busy";
}
else
{
imageHitControllerBusy = true;
using (OggleBoobleMySqContext dbm = new OggleBoobleMySqContext())
{
//DateTime utcDateTime = DateTime.UtcNow.AddMilliseconds(getrandom.Next());
//imageHitSuccess.HitDateTime = utcDateTime;
dbm.ImageHits.Add(new ImageHit()
{
VisitorId = logImageHItData.VisitorId,
PageId = logImageHItData.PageId,
ImageLinkId = logImageHItData.LinkId,
HitDateTime = DateTime.Now
});
dbm.SaveChanges();
imageHitSuccess.UserImageHits = dbm.ImageHits.Where(h => h.VisitorId == logImageHItData.VisitorId).Count();
imageHitSuccess.UserPageHits = dbm.PageHits.Where(h => h.VisitorId == logImageHItData.VisitorId).Count();
imageHitSuccess.ImageHits = dbm.ImageHits.Where(h => h.ImageLinkId == logImageHItData.LinkId).Count();
imageHitControllerBusy = false;
}
}
imageHitSuccess.Success = "ok";
}
catch (DbEntityValidationException dbEx)
{
imageHitSuccess.Success = Helpers.ErrorDetails(dbEx);
}
catch (Exception ex)
{
imageHitSuccess.Success = Helpers.ErrorDetails(ex);
}
return(imageHitSuccess);
}
public MostActiveUsersModel MostActiveUsersReport()
{
var mostActiveUsersReport = new MostActiveUsersModel();
try
{
using (var db = new OggleBoobleMySqContext())
{
db.ImageHits.RemoveRange(db.ImageHits.Where(i => i.VisitorId == "ec6fb880-ddc2-4375-8237-021732907510"));
var mostActiveUserItems = db.MostActiveUsersForToday.ToList();
foreach (vwMostActiveUsersForToday mostActiveUserItem in mostActiveUserItems)
{
mostActiveUsersReport.Items.Add(new MostActiveUsersItem()
{
IpAddress = mostActiveUserItem.IpAddress,
City = mostActiveUserItem.City,
Region = mostActiveUserItem.Region,
Country = mostActiveUserItem.Country,
ImageHitsToday = mostActiveUserItem.ImageHitsToday,
TotalImageHits = mostActiveUserItem.TotalImageHits,
PageHitsToday = mostActiveUserItem.PageHitsToday,
TotalPageHits = mostActiveUserItem.TotalPageHits,
LastHit = mostActiveUserItem.LastHit,
InitialVisit = mostActiveUserItem.InitialVisit,
UserName = mostActiveUserItem.UserName
});
}
//mostActiveUsersReport.Items = db.Database.SqlQuery<MostActiveUsersItem>(
// "select IpAddress, City, Region, Country, " +
// "max(date_format(HitDateTime, '%m/%d/%Y')) as 'LastHit', max(date_format(HitDateTime, '%h:%i.%s')) as hitTime, count(*) imageHits " +
// "from OggleBooble.ImageHit ih " +
// "join OggleBooble.Visitor v on ih.VisitorId = v.VisitorId " +
// "where HitDateTime between current_date and current_date + 1 " +
// "group by IpAddress, City, Region, Country " +
// "order by imageHits desc;").ToList();
mostActiveUsersReport.HitCount = mostActiveUsersReport.Items.Count();
}
mostActiveUsersReport.Success = "ok";
}
catch (Exception ex) { mostActiveUsersReport.Success = Helpers.ErrorDetails(ex); }
return(mostActiveUsersReport);
}
public string AddRole(string roleName)
{
string success = "";
try
{
using (OggleBoobleMySqContext db = new OggleBoobleMySqContext())
{
db.Roles.Add(new Role()
{
RoleName = roleName
});
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
