private ResultStatus AddUserProfile(GEMA_TM_USER_PROFILE userProfile, ref int userProfileId)
{
_ctx.GEMA_TM_USER_PROFILE.Add(userProfile);
_ctx.SaveChanges();
userProfileId = _ctx.GEMA_TM_USER_PROFILE.Where(x => x.USER_ID_ID == userProfile.USER_ID_ID).FirstOrDefault().ID;
rs.SetSuccessStatus();
return(rs);
}
public ResultStatus Edit(GEMA_TM_USER user, GEMA_TM_USER_PROFILE userProfile, List <GEMA_TM_USER_PROFILE_SOSMED> userProfileSosmed)
{
using (var transaction = _ctx.Database.BeginTransaction())
{
try
{
int userProfileId = 0;
rs = EditUser(user, ref userProfileId);
if (rs.IsSuccess && userProfile.ADDRESS != "")
{
userProfile.ID = userProfileId;
rs = EditUserProfile(userProfile);
}
if (rs.IsSuccess && userProfileSosmed.Count > 0)
{
List <GEMA_TM_USER_PROFILE_SOSMED> userProfileSosmedNew = new List <GEMA_TM_USER_PROFILE_SOSMED>();
foreach (var item in userProfileSosmed)
{
item.USER_PROFILE_ID = userProfileId;
userProfileSosmedNew.Add(item);
}
rs = AddUserProfileSosmed(userProfileSosmedNew);
}
transaction.Commit();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
transaction.Rollback();
rs.SetErrorStatus(ex.Message);
}
}
return(rs);
}
private ResultStatus EditUserProfile(GEMA_TM_USER_PROFILE userProfile)
{
GEMA_TM_USER_PROFILE userProfileNew = _ctx.GEMA_TM_USER_PROFILE.Find(userProfile.ID);
userProfileNew.ADDRESS = userProfile.ADDRESS;
userProfileNew.BORN = userProfile.BORN;
userProfileNew.DESCRIPTION = userProfile.DESCRIPTION;
userProfileNew.GENDER = userProfile.GENDER;
userProfileNew.COMPANY = userProfile.COMPANY;
if (userProfile.PHOTO_PATH != null)
{
userProfileNew.PHOTO_PATH = userProfile.PHOTO_PATH;
}
userProfileNew.HOBBY = userProfile.HOBBY;
userProfileNew.LAST_MODIFIED_BY = userProfile.LAST_MODIFIED_BY;
userProfileNew.LAST_MODIFIED_TIME = userProfile.LAST_MODIFIED_TIME;
_ctx.Entry(userProfileNew).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
return(rs);
}
