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