public static string GetNameById(Guid id)
{
try
{
UserDetailModel model = new UserDetailModel();
using (var db = new HMSEntities())
{
UserDetail entity = db.UserDetails.Find(id);
if (entity != null)
{
return(entity.FullName);
}
}
return(string.Empty);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Create(UserDetailModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
UserDetail entity = new UserDetail();
entity.FullName = model.FullName;
entity.Address = model.Address;
entity.PhoneNumber = model.PhoneNumber;
entity.DepartmentId = Department.GetByName("OPD").Id;
entity.RoleCategoryId = RoleCategory.GetByName("Genaral").Id;
entity.UserName = model.UserName;
entity.Password = model.Password;
entity.IsActive = true;
entity.IsDeleted = false;
entity.CreatedOn = DateTime.Now;
entity.CreatedBy = UserDetailSession.Id;
db.UserDetails.Add(entity);
db.SaveChanges();
isSaved = true;
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(UserDetailModel model)
{
try
{
bool isSaved = false;
if (!IsExist(model))
{
using (var db = new HMSEntities())
{
UserDetail entity = db.UserDetails.Find(model.Id);
entity.FullName = model.FullName;
entity.Address = model.Address;
entity.PhoneNumber = model.PhoneNumber;
entity.DepartmentId = UserDetailSession.DepartmentId;
entity.RoleCategoryId = UserDetailSession.RoleCategoryId;
entity.UserName = model.UserName;
entity.Password = model.Password;
entity.ModifiedOn = DateTime.Now;
entity.ModifiedBy = UserDetailSession.Id;
db.SaveChanges();
isSaved = true;
}
}
return(isSaved);
}
catch (Exception ex)
{
throw ex;
}
}
public UserDetailModel GetByParentId(Guid id)
{
try
{
UserDetailModel model = new UserDetailModel();
using (var db = new HMSEntities())
{
UserDetail entity = db.UserDetails.FirstOrDefault(t => t.DepartmentId == id);
if (entity != null)
{
model.Id = entity.Id;
model.FullName = entity.FullName;
model.Address = entity.Address;
model.PhoneNumber = entity.PhoneNumber;
model.DepartmentId = entity.DepartmentId;
model.DepartmentName = entity.Department.Name;
model.RoleCategoryId = entity.RoleCategoryId;
model.RoleCategoryName = entity.RoleCategory.Name;
model.UserName = entity.UserName;
model.Password = entity.Password;
model.IsActive = entity.IsActive;
model.IsDeleted = entity.IsDeleted;
model.CreatedOn = entity.CreatedOn;
model.CreatedBy = entity.CreatedBy;
model.ModifiedOn = entity.ModifiedOn;
model.ModifiedBy = entity.ModifiedBy;
}
}
return(model);
}
catch (Exception ex)
{
throw ex;
}
}
