public static ActionHandler DeleteRecordType(Guid id, string loggedUserId)
{
ActionHandler result = new ActionHandler {
IsSuccess = true, Message = ""
};
try
{
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var item = db.RecordType.SingleOrDefault(x => x.id == id);
if (item != null)
{
item.isDeleted = true;
item.modifiedBy = loggedUserId;
item.modifyDate = DateTime.Now;
db.SaveChanges();
}
else
{
result.IsSuccess = false;
result.Message = "Item not found!";
}
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public static ActionHandler LockUnlockUser(string aspNetMemberId, string loggedUser)
{
ActionHandler result = new ActionHandler();
try
{
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var aspNetUser = db.AspNetUsers.Where(x => x.Id == aspNetMemberId).SingleOrDefault();
var appUser = db.AppUsers.Where(x => x.aspNetUserId == aspNetMemberId).SingleOrDefault();
if (aspNetUser.LockoutEnabled)
{
aspNetUser.LockoutEnabled = false;
}
else
{
aspNetUser.LockoutEnabled = true;
}
appUser.modifyBy = loggedUser;
appUser.modifyDate = DateTime.Now;
db.SaveChanges();
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public static ActionHandler CreateUser(string eMail, string firstName, string lastName, string position, string currentUser)
{
ActionHandler result = new ActionHandler();
try
{
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var registeredUser = db.AspNetUsers.Where(x => x.Email == eMail).SingleOrDefault();
registeredUser.LockoutEnabled = false;
AppUsers u = new AppUsers();
u.id = Guid.NewGuid();
u.aspNetUserId = registeredUser.Id;
u.createdBy = currentUser;
u.createdDate = DateTime.Now;
u.firstName = firstName;
u.lastName = lastName;
u.modifyBy = currentUser;
u.modifyDate = DateTime.Now;
u.position = position;
db.AppUsers.Add(u);
db.SaveChanges();
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public static List <RecordTypeTableViewDM> GetAllRecordTypes()
{
List <RecordTypeTableViewDM> result = new List <RecordTypeTableViewDM>();
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var items = db.RecordType.Where(x => x.isDeleted == false && x.isEnabled == true);
if (items != null)
{
foreach (var i in items)
{
RecordTypeTableViewDM li = new RecordTypeTableViewDM();
li.Id = i.id;
li.SubtypeId = i.subType;
li.SubtypeName = Helpers.EnumHelper.GetEnumDescription((Enums.RecordSubTypeEnum)i.subType);
li.TypeName = i.name;
li.CreatedBy = i.createdBy;
li.CreatedOn = i.createdDate;
li.UpdatedBy = i.modifiedBy;
li.UpdatedOn = i.modifyDate;
result.Add(li);
}
}
}
return(result);
}
public static ActionHandler InsertOrUpdateRecordType(RecordTypeDM record)
{
ActionHandler result = new ActionHandler {
IsSuccess = true, Message = ""
};
try
{
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var item = db.RecordType.SingleOrDefault(x => x.id == record.Id);
if (item == null)
{
RecordType RT = new RecordType();
RT.id = record.Id;
RT.isDeleted = false;
RT.isEnabled = true;
RT.name = record.Name;
RT.subType = record.SubType;
RT.createdBy = record.CreatedBy;
RT.createdDate = DateTime.Now;
RT.modifiedBy = record.ModifiedBy;
RT.modifyDate = DateTime.Now;
db.RecordType.Add(RT);
db.SaveChanges();
}
else
{
item.name = record.Name;
item.subType = record.SubType;
item.modifiedBy = record.ModifiedBy;
item.modifyDate = DateTime.Now;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.IsSuccess = false;
result.Message = ex.Message;
}
return(result);
}
public static List <UsersDM> GetAllUsers()
{
List <UsersDM> result = new List <UsersDM>();
using (TardiRecordsEntities db = new DataLayer.TardiRecordsEntities())
{
var items = db.vw_AllUsers;
foreach (var item in items)
{
UsersDM u = new UsersDM();
u.AppUserId = item.AppUserId;
u.AspNetUserId = item.AspNetUserId;
u.FirstName = item.firstName;
u.LastName = item.lastName;
u.Email = item.Email;
u.IsLocked = item.LockoutEnabled;
u.LastChangedOn = item.modifyDate;
u.LastChangedBy = item.EditedBy;
u.Position = item.position;
result.Add(u);
}
}
return(result);
}