public bool Edit(int id, UserProfileAdmin par)
{
bool res = false;
try
{
SBH_TM_USER_PROFILE_ADMIN a = _ctx.SBH_TM_USER_PROFILE_ADMIN.Find(id);
if (a != null)
{
a.ID = par.ID;
a.ID_USER_ADMIN = par.ID_USER_ADMIN;
a.PHOTO_PATH = par.PHOTO_PATH;
a.GENDER = par.GENDER;
a.BORN = par.BORN;
a.ADDRESS = par.ADDRESS;
a.DESCRIPTION = par.DESCRIPTION;
a.JOB = par.JOB;
a.COMPANY = par.COMPANY;
a.HOBBY = par.HOBBY;
a.LAST_MODIFIED_TIME = DateTime.Now;
a.LAST_MODIFIED_BY = "System";
_ctx.Entry(a).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
res = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(res);
}
public bool Add(UserProfileAdmin par)
{
bool res = false;
try
{
SBH_TM_USER_PROFILE_ADMIN a = new SBH_TM_USER_PROFILE_ADMIN()
{
ID = par.ID,
ID_USER_ADMIN = par.ID_USER_ADMIN,
PHOTO_PATH = par.PHOTO_PATH,
GENDER = par.GENDER,
BORN = par.BORN,
ADDRESS = par.ADDRESS,
DESCRIPTION = par.DESCRIPTION,
JOB = par.JOB,
COMPANY = par.COMPANY,
HOBBY = par.HOBBY,
CREATED_TIME = DateTime.Now,
CREATED_BY = "System",
ROW_STATUS = fn.fg.IsActive
};
_ctx.SBH_TM_USER_PROFILE_ADMIN.Add(a);
_ctx.SaveChanges();
res = true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(res);
}
public object[] Edit(int id, Register par)
{
object[] res = null;
try
{
if (par.ConfirmPassword != par.Password)
{
throw new Exception("password");
}
if (IsValidEmail(par.Email) == false)
{
throw new Exception("email");
}
SBH_TM_USER_ADMIN a = _ctx.SBH_TM_USER_ADMIN.Find(id);
SBH_TM_USER_PROFILE_ADMIN b = _ctx.SBH_TM_USER_PROFILE_ADMIN.Find(id);
if (a != null && b != null)
{
if (par.ID_GROUP != 0)
{
a.ID_GROUP = par.ID_GROUP;
}
a.USER_MAIL = par.Email;
a.USER_NAME = par.Name;
if (!string.IsNullOrWhiteSpace(par.Password) || !string.IsNullOrEmpty(par.Password))
{
a.PASSWORD = par.Password;
}
a.IS_SUPER_ADMIN = par.IsSuperAdmin;
a.ROW_STATUS = fn.fg.IsActive;
a.LAST_MODIFIED_TIME = DateTime.Now;
a.LAST_MODIFIED_BY = par.LAST_MODIFIED_BY;
_ctx.Entry(a).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
b.GENDER = par.Gender;
b.BORN = par.Born;
b.ADDRESS = par.Address;
b.DESCRIPTION = par.OtherDescription;
b.JOB = par.Job;
b.COMPANY = par.Company;
b.HOBBY = par.Hobby;
b.LAST_MODIFIED_TIME = DateTime.Now;
b.LAST_MODIFIED_BY = par.LAST_MODIFIED_BY;
_ctx.Entry(b).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
res = new object[] { true, fnn.fg.Save };
}
}
catch (Exception ex)
{
res = new object[] { false, ex.Message };
}
return(res);
}
public object[] Add(Register par)
{
object[] res = null;
try
{
if (par.ConfirmPassword != par.Password)
{
throw new Exception("password");
}
if (IsValidEmail(par.Email) == false)
{
throw new Exception("email");
}
var x = _ctx.SBH_TM_USER_ADMIN.ToList().Count();
SBH_TM_USER_ADMIN a = new SBH_TM_USER_ADMIN()
{
ID_USER_ADMIN = x.ToString(),
ID_GROUP = par.ID_GROUP,
USER_MAIL = par.Email,
USER_NAME = par.Name,
PASSWORD = par.Password,
IS_SUPER_ADMIN = par.IsSuperAdmin,
CREATED_TIME = DateTime.Now,
CREATED_BY = par.CREATED_BY == null ? par.Name : par.CREATED_BY,
ROW_STATUS = fn.fg.IsActive
};
_ctx.SBH_TM_USER_ADMIN.Add(a);
_ctx.SaveChanges();
SBH_TM_USER_PROFILE_ADMIN b = new SBH_TM_USER_PROFILE_ADMIN()
{
ID_USER_ADMIN = x,
GENDER = par.Gender,
BORN = par.Born,
ADDRESS = par.Address,
DESCRIPTION = par.OtherDescription,
JOB = par.Job,
COMPANY = par.Company,
HOBBY = par.Hobby,
CREATED_TIME = DateTime.Now,
CREATED_BY = par.CREATED_BY,
ROW_STATUS = fn.fg.IsActive
};
_ctx.SBH_TM_USER_PROFILE_ADMIN.Add(b);
_ctx.SaveChanges();
res = new object[] { true, fnn.fg.Save };
}
catch (Exception ex)
{
res = new object[] { false, ex.Message };
}
return(res);
}
public bool Delete(int id)
{
bool res = false;
try
{
SBH_TM_USER_PROFILE_ADMIN a = _ctx.SBH_TM_USER_PROFILE_ADMIN.Find(id);
a.ROW_STATUS = fn.fg.NotActive;
_ctx.Entry(a).State = System.Data.Entity.EntityState.Modified;
res = true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(res);
}
public UserProfileAdmin Retrived(int id)
{
try
{
UserProfileAdmin oA = new UserProfileAdmin();
SBH_TM_USER_PROFILE_ADMIN oB = _ctx.SBH_TM_USER_PROFILE_ADMIN
.Where(x => x.ROW_STATUS == fn.fg.IsActive && x.ID == id).FirstOrDefault();
if (oB != null)
{
oA.ID = oB.ID;
oA.ID_USER_ADMIN = oB.ID_USER_ADMIN;
oA.PHOTO_PATH = oB.PHOTO_PATH;
oA.GENDER = oB.GENDER;
oA.BORN = oB.BORN;
oA.ADDRESS = oB.ADDRESS;
oA.DESCRIPTION = oB.DESCRIPTION;
oA.JOB = oB.JOB;
oA.COMPANY = oB.COMPANY;
oA.HOBBY = oB.HOBBY;
oA.CREATED_TIME = oB.CREATED_TIME;
oA.CREATED_BY = oB.CREATED_BY;
oA.LAST_MODIFIED_TIME = oB.LAST_MODIFIED_TIME;
oA.LAST_MODIFIED_BY = oB.LAST_MODIFIED_BY;
oA.ROW_STATUS = oB.ROW_STATUS;
return(oA);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
throw new Exception(ex.Message);
}
}
