private void CreateDefaultData(CMS_Context context)
{
try
{
var hier = HierarchyData.HierarchyConfigs;
/*-- Insert Employee --*/
#region -- Employee --
if (hier.Employees != null && hier.Employees.Count > 0)
{
foreach (EmployeeConfigElement pro in hier.Employees)
{
var emp = new CMS_Employee()
{
Id = Guid.NewGuid().ToString(),
Employee_Email = pro.Email,
Employee_Phone = "",
FirstName = "FirstName",
LastName = "LastName",
IsActive = true,
BirthDate = DateTime.Now,
UpdatedDate = DateTime.Now,
CreatedDate = DateTime.Now,
Password = "******",
IsSupperAdmin = true,
};
context.CMS_Employees.Add(emp);
}
}
#endregion
context.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
public bool CreateOrUpdate(CMS_EmployeeModels model, ref string msg)
{
var result = true;
using (var cxt = new CMS_Context())
{
using (var trans = cxt.Database.BeginTransaction())
{
try
{
if (string.IsNullOrEmpty(model.Id))
{
var _Id = Guid.NewGuid().ToString();
var e = new CMS_Employee
{
Id = _Id,
BirthDate = model.BirthDate,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
Employee_Address = model.Employee_Address,
Employee_Email = model.Employee_Email,
Employee_IDCard = model.Employee_IDCard,
Employee_Phone = model.Employee_Phone,
FirstName = model.FirstName,
IsActive = model.IsActive,
LastName = model.LastName,
Password = model.Password,
UpdatedBy = model.UpdatedBy,
UpdatedDate = DateTime.Now,
ImageURL = model.ImageURL,
Level = model.Level,
Position = model.Position,
LinkFB = model.LinkFB,
LinkInstagram = model.LinkInstagram,
LinkPinterest = model.LinkPinterest,
LinkTwiter = model.LinkTwiter
};
cxt.CMS_Employees.Add(e);
}
else
{
var e = cxt.CMS_Employees.Find(model.Id);
if (e != null)
{
e.BirthDate = model.BirthDate;
e.UpdatedBy = model.UpdatedBy;
e.Employee_Address = model.Employee_Address;
e.Employee_Email = model.Employee_Email;
e.Employee_IDCard = model.Employee_IDCard;
e.Employee_Phone = model.Employee_Phone;
e.FirstName = model.FirstName;
e.LastName = model.LastName;
e.IsActive = model.IsActive;
e.Password = model.Password;
e.UpdatedDate = DateTime.Now;
e.ImageURL = model.ImageURL;
e.Position = model.Position;
e.Level = model.Level;
e.LinkTwiter = model.LinkTwiter;
e.LinkPinterest = model.LinkPinterest;
e.LinkInstagram = model.LinkInstagram;
e.LinkFB = model.LinkFB;
}
}
cxt.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
msg = "Lỗi hệ thống! Vui lòng load lại.";
result = false;
trans.Rollback();
}
finally
{
cxt.Dispose();
}
}
}
return(result);
}
public bool CreateOrUpdate(CMS_EmployeeModels model, ref string Id, ref string msg)
{
NSLog.Logger.Info("EmployeeCreateOrUpdate", model);
var Result = true;
using (var cxt = new CMS_Context())
{
try
{
if (string.IsNullOrEmpty(model.Id)) /* insert */
{
var _isExits = cxt.CMS_Employee.Any(x => x.Email.Equals(model.Email) && x.IsActive.HasValue && x.Status == (byte)Commons.EStatus.Actived);
if (_isExits)
{
msg = "Địa chỉ email đã tồn tại";
Result = false;
}
else
{
Id = Guid.NewGuid().ToString();
var e = new CMS_Employee
{
ID = Id,
Name = model.Name,
RoleID = model.RoleID,
Email = model.Email,
Password = model.Password,
IsActive = model.IsActive,
Phone = model.Phone,
PinCode = model.PinCode,
Gender = model.Gender,
Marital = model.Marital,
HiredDate = model.HiredDate,
BirthDate = model.BirthDate,
Street = model.Street,
City = model.City,
Country = model.Country,
ZipCode = model.ZipCode,
ImageUrl = model.ImageURL,
StoreID = model.StoreID,
IsSupperAdmin = model.IsSupperAdmin,
Status = (byte)Commons.EStatus.Actived,
CreatedDate = DateTime.Now,
CreatedUser = model.CreatedBy,
ModifiedUser = model.CreatedBy,
LastModified = DateTime.Now,
Quote = model.Quote,
};
cxt.CMS_Employee.Add(e);
}
}
else /* updated */
{
var e = cxt.CMS_Employee.Find(model.Id);
if (e != null)
{
var _isExits = cxt.CMS_Employee.Any(x => x.Email.Equals(model.Email) && x.Status != (byte)Commons.EStatus.Actived && x.IsActive.HasValue && x.ID == model.Id);
if (!_isExits)
{
e.Name = model.Name;
e.RoleID = model.RoleID;
e.Email = model.Email;
e.Password = model.Password;
e.IsActive = model.IsActive;
e.Phone = model.Phone;
e.PinCode = model.PinCode;
e.Gender = model.Gender;
e.Marital = model.Marital;
e.HiredDate = model.HiredDate;
e.BirthDate = model.BirthDate;
e.Street = model.Street;
e.City = model.City;
e.Country = model.Country;
e.ZipCode = model.ZipCode;
e.ImageUrl = model.ImageURL;
e.StoreID = model.StoreID;
e.IsSupperAdmin = model.IsSupperAdmin;
e.Status = (byte)Commons.EStatus.Actived;
e.ModifiedUser = model.CreatedBy;
e.LastModified = DateTime.Now;
e.Quote = model.Quote;
}
else
{
msg = "Địa chỉ email đã tồn tại";
Result = false;
}
}
else
{
Result = false;
msg = "Unable to find Discount.";
}
}
cxt.SaveChanges();
NSLog.Logger.Info("ResponseEmployeeCreateOrUpdate", new { Result, msg });
}
catch (Exception ex)
{
Result = false;
msg = "System Error.";
NSLog.Logger.Error("ErrorEmployeeCreateOrUpdate", ex);
}
}
return(Result);
}
public bool CreateOrUpdate(CMS_EmployeeModels model, ref string msg)
{
var result = true;
using (var cxt = new CMS_Context())
{
using (var trans = cxt.Database.BeginTransaction())
{
try
{
if (string.IsNullOrEmpty(model.Id))
{
var _Id = Guid.NewGuid().ToString();
var e = new CMS_Employee
{
Id = _Id,
BirthDate = model.BirthDate,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
Employee_Address = model.Employee_Address,
Employee_Email = model.Employee_Email,
Employee_IDCard = model.Employee_IDCard,
Employee_Phone = model.Employee_Phone,
FirstName = model.FirstName,
IsActive = model.IsActive,
LastName = model.LastName,
Password = model.Password,
UpdatedBy = model.UpdatedBy,
UpdatedDate = DateTime.Now,
ImageURL = model.ImageURL
};
cxt.CMS_Employee.Add(e);
}
else
{
var e = cxt.CMS_Employee.Find(model.Id);
if (e != null)
{
e.BirthDate = model.BirthDate;
e.UpdatedBy = model.UpdatedBy;
e.Employee_Address = model.Employee_Address;
e.Employee_Email = model.Employee_Email;
e.Employee_IDCard = model.Employee_IDCard;
e.Employee_Phone = model.Employee_Phone;
e.FirstName = model.FirstName;
e.LastName = model.LastName;
e.IsActive = model.IsActive;
e.Password = model.Password;
e.UpdatedDate = DateTime.Now;
e.ImageURL = model.ImageURL;
}
}
cxt.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
msg = "Vui lòng kiểm tra đường truyền";
result = false;
trans.Rollback();
}
finally
{
cxt.Dispose();
}
}
}
return(result);
}