public List <AppCompositeRoleViewModel> GetAppCompositeRoleList()
{
List <AppCompositeRoleViewModel> result = new List <AppCompositeRoleViewModel>();
var help = NewFormData();
try
{
using (var context = new PYMFEEEntities())
{
var appCompositeRoles = context.AppCompositeRoles.ToList();
foreach (var appCompositeRole in appCompositeRoles)
{
AppCompositeRoleViewModel appCompositeRoleViewModel = new AppCompositeRoleViewModel();
MVMMappingService.MoveData(appCompositeRole, appCompositeRoleViewModel);
var statusHelp = help.StatusValueHelp.Where(m => m.ValueKey == appCompositeRole.Status).FirstOrDefault();
appCompositeRoleViewModel.StatusText = statusHelp.ValueText;
result.Add(appCompositeRoleViewModel);
}
}
}
catch (Exception ex)
{
}
return(result);
}
public override AppCompositeRoleViewModel GetDetail(int id)
{
AppCompositeRoleViewModel result = NewFormData();
var userInfo = UserService.GetSessionUserInfo();
try
{
using (var context = new PYMFEEEntities())
{
var appMenu = context.AppCompositeRoles.Where(m => m.ID == id).FirstOrDefault();
if (appMenu != null)
{
MVMMappingService.MoveData(appMenu, result);
var appItems = context.AppCompositeRoleItems.Where(m => m.CompositeRoleID == id).ToList();
if (appItems != null)
{
if (appItems.Count > 0)
{
var newAppMenuItems = new List <AppMenuViewModel>();
foreach (var appMenuItem in result.AppMenuItems)
{
var roleDisplay = appItems.Where(m => m.RoleID == appMenuItem.RoleForDisplay).FirstOrDefault();
if (roleDisplay != null)
{
appMenuItem.CheckRoleForDisplay = true;
}
var roleManage = appItems.Where(m => m.RoleID == appMenuItem.RoleForManage).FirstOrDefault();
if (roleManage != null)
{
appMenuItem.CheckRoleForManage = true;
}
newAppMenuItems.Add(appMenuItem);
}
//Update Parent Check Box
newAppMenuItems = UpdateParentList(newAppMenuItems);
}
}
}
}//End Context
}
catch (Exception ex)
{
}
return(result);
}
public override ValidationResult SaveDelete(PaymentItemsViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
result = ValidateFormData(formData, modelState);
if (result.ErrorFlag)
{
return(result);
}
try
{
using (TransactionScope scope = new TransactionScope())
{
var entPYMItems = new PAYMENT_ITEMS();
//Copy data from viewmodel to model - for header
MVMMappingService.MoveData(formData, entPYMItems);
using (var context = new PYMFEEEntities())
{
//Delete header
context.Entry(entPYMItems).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
//Delete item
context.PAYMENT_ITEMS_CHAGE.RemoveRange(context.PAYMENT_ITEMS_CHAGE.Where(m => m.COMPANY_CODE == entPYMItems.COMPANY_CODE && m.PAYMENT_ITEMS_ID == entPYMItems.ID));
context.SaveChanges();
}
//Commit Header and Item
scope.Complete();
result.Message = ResourceText.SuccessfulDelete;
result.MessageType = "S";
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
private static List <AppMenuViewModel> GetAppMenuUnder(AppMenu parent, List <AppMenu> appMenus, int level = 0)
{
List <AppMenuViewModel> result = new List <AppMenuViewModel>();
ResourceManager rm = new ResourceManager(typeof(ResourceText));
try
{
var newLevel = level + 1;
var appMenuUnderList = appMenus.Where(m => m.ParentMenuCode == parent.MenuCode).ToList();
if (appMenuUnderList.Count > 0)
{
appMenuUnderList = appMenuUnderList.OrderBy(m => m.Sequence).ToList();
foreach (var appMenuUnder in appMenuUnderList)
{
AppMenuViewModel appMenu = new AppMenuViewModel();
MVMMappingService.MoveData(appMenuUnder, appMenu);
appMenu.Level = newLevel;
appMenu.MenuText = rm.GetString(appMenu.ResourceName);
if (!string.IsNullOrEmpty(appMenuUnder.RoleForManage) || appMenuUnder.MenuType.Equals("GROUP", StringComparison.OrdinalIgnoreCase))
{
appMenu.IsRoleForManage = true;
}
if (!string.IsNullOrEmpty(appMenuUnder.RoleForDisplay) || appMenuUnder.MenuType.Equals("GROUP", StringComparison.OrdinalIgnoreCase))
{
appMenu.IsRoleForDisplay = true;
}
result.Add(appMenu);
var appMenuNextUnderList = GetAppMenuUnder(appMenuUnder, appMenus, newLevel);
if (appMenuNextUnderList.Count > 0)
{
result.AddRange(appMenuNextUnderList);
}
}
}
}
catch (Exception ex)
{
}
return(result);
}
public override ValidationResult SaveDelete(AppCompositeRoleViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
try
{
if (formData.ID <= 0)
{
result.Message = ValidatorMessage.id_not_found;
result.ModelStateErrorList.Add(new ModelStateError("", result.Message));
result.ErrorFlag = true;
return(result);
}
using (TransactionScope scope = new TransactionScope())
{
using (var context = new PYMFEEEntities())
{
var appCompositeRole = new AppCompositeRole();
MVMMappingService.MoveData(formData, appCompositeRole);
context.Entry(appCompositeRole).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
//Delete Items
context.AppCompositeRoleItems.RemoveRange(context.AppCompositeRoleItems.Where(m => m.CompositeRoleID == appCompositeRole.ID).ToList());
context.SaveChanges();
scope.Complete();
}//End Transaction
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
public List <PaymentItemsViewModel> GetPaymentItemsList(string companyCode)
{
List <PaymentItemsViewModel> pymItemsList = new List <PaymentItemsViewModel>();
try
{
using (var context = new PYMFEEEntities())
{
var entPaymentItems = (from m in context.PAYMENT_ITEMS orderby m.COMPANY_CODE, m.GROUP_SEQ_CHANNELS select m).ToList();
var entCompany = (from m in context.COMPANies where m.IsPaymentFee == true select m).ToList();
var entUsers = (from m in context.USERS select m).ToList();
if (!string.IsNullOrEmpty(companyCode))
{
entPaymentItems = entPaymentItems.Where(m => m.COMPANY_CODE == companyCode).ToList();
entCompany = entCompany.Where(m => m.BAN_COMPANY == companyCode).ToList();
}
int seq = 1;
foreach (var item in entPaymentItems)
{
var getUsers = entUsers.Where(m => m.USERID == item.LASTMODIFIED_BY).FirstOrDefault();
var getCompany = entCompany.Where(m => m.BAN_COMPANY == item.COMPANY_CODE).FirstOrDefault();
PaymentItemsViewModel pymItemsModel = new PaymentItemsViewModel();
MVMMappingService.MoveData(item, pymItemsModel);
pymItemsModel.COMPANY_NAME = getCompany == null ? "" : getCompany.COMPANY_NAME_EN;
pymItemsModel.LASTMODIFIED_BY_NAME = getUsers == null ? "" : getUsers.NAME;
pymItemsModel.ITEM = seq;
pymItemsList.Add(pymItemsModel);
seq++;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(pymItemsList);
}
public override PaymentItemsViewModel GetDetail(int id)
{
PaymentItemsViewModel pymItemsModel = NewFormData();
//User Type
User userInfo = UserService.GetSessionUserInfo();
try
{
using (var context = new PYMFEEEntities())
{
var entPymItems = (from m in context.PAYMENT_ITEMS where m.ID == id select m).FirstOrDefault();
if (entPymItems != null)
{
MVMMappingService.MoveData(entPymItems, pymItemsModel);
pymItemsModel.LASTMODIFIED_BY = userInfo.UserCode;
pymItemsModel.LASTMODIFIED_DATE = DateTime.Now;
var entPymItemsCharge = (from n in context.PAYMENT_ITEMS_CHAGE where n.COMPANY_CODE == entPymItems.COMPANY_CODE && n.PAYMENT_ITEMS_ID == id orderby n.SEQUENCE select n).ToList();
foreach (var item in entPymItemsCharge)
{
PaymentItemsChargeViewModel pymChargeModel = new PaymentItemsChargeViewModel();
MVMMappingService.MoveData(item, pymChargeModel);
pymChargeModel.ChargeTypeList = ValueHelpService.GetValueHelp(ConstantVariableService.CHARGETYPE).ToList();
pymChargeModel.IsActionList = ValueHelpService.GetValueHelp(ConstantVariableService.ISACTIONTYPE);
pymItemsModel.pymItemsChargeList.Add(pymChargeModel);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(pymItemsModel);
}
public override ValidationResult SaveEdit(PaymentItemsViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
try
{
result = ValidateFormData(formData, modelState);
//Error
if (result.ErrorFlag)
{
return(result);
}
using (TransactionScope scope = new TransactionScope())
{
PAYMENT_ITEMS entPYMItems = new PAYMENT_ITEMS();
//Copy data from viewmodel to model - for header
MVMMappingService.MoveData(formData, entPYMItems);
//Save Header
using (var context = new PYMFEEEntities())
{
context.Entry(entPYMItems).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
#region Update any Table
//Update
//#region //FEE_ACCRUED_PLAN_ITEM
//var entaccr = context.FEE_ACCRUED_PLAN_ITEM.Where(m => m.PAYMENT_ITEMS_NAME == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entaccr)
//{
// FEE_ACCRUED_PLAN_ITEM ent_accr_item = new FEE_ACCRUED_PLAN_ITEM();
// ent_accr_item = context.FEE_ACCRUED_PLAN_ITEM.Find(accr.ACCRUED_ITEM_ID) ;
// ent_accr_item.PAYMENT_ITEMS_NAME = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.CCT_CODE = entPYMItems.CCT_CODE;
// ent_accr_item.COST_CENTER = entPYMItems.COST_CENTER;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// ent_accr_item.CHANNELS = entPYMItems.CHANNELS;
// context.FEE_ACCRUED_PLAN_ITEM.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
//#region//FEE_ACCRUED_PLAN_ITEM_SUB
//var entaccrsub = context.FEE_ACCRUED_PLAN_ITEM_SUB.Where(m => m.PAYMENT_ITEMS_NAME == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entaccrsub)
//{
// FEE_ACCRUED_PLAN_ITEM_SUB ent_accr_item = new FEE_ACCRUED_PLAN_ITEM_SUB();
// ent_accr_item = context.FEE_ACCRUED_PLAN_ITEM_SUB.Find(accr.ID);
// ent_accr_item.PAYMENT_ITEMS_NAME = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.CCT_CODE = entPYMItems.CCT_CODE;
// ent_accr_item.COST_CENTER = entPYMItems.COST_CENTER;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// ent_accr_item.CHANNELS = entPYMItems.CHANNELS;
// context.FEE_ACCRUED_PLAN_ITEM_SUB.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
//#region //FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG
//var entaccrup = context.FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG.Where(m => m.FEE == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entaccrup)
//{
// FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG ent_accr_item = new FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG();
// ent_accr_item = context.FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG.Find(accr.ID);
// ent_accr_item.FEE = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.CCT_CODE = entPYMItems.CCT_CODE;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// context.FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
//#region//FEE_INVOICE
//var entinv = context.FEE_INVOICE.Where(m => m.PAYMENT_ITEMS_NAME == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entinv)
//{
// FEE_INVOICE ent_accr_item = new FEE_INVOICE();
// ent_accr_item = context.FEE_INVOICE.Find(accr.ID);
// ent_accr_item.PAYMENT_ITEMS_NAME = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.CCT_CODE = entPYMItems.CCT_CODE;
// ent_accr_item.COST_CENTER = entPYMItems.COST_CENTER;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// ent_accr_item.CHANNELS = entPYMItems.CHANNELS;
// context.FEE_INVOICE.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
//#region //FEE_INVOICE_ITEM
//var entinvitem = context.FEE_INVOICE_ITEM.Where(m => m.PAYMENT_ITEMS_NAME == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entinvitem)
//{
// FEE_INVOICE_ITEM ent_accr_item = new FEE_INVOICE_ITEM();
// ent_accr_item = context.FEE_INVOICE_ITEM.Find(accr.INV_ITEM_NO);
// ent_accr_item.PAYMENT_ITEMS_NAME = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.COST_CENTER = entPYMItems.COST_CENTER;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// ent_accr_item.CHANNELS = entPYMItems.CHANNELS;
// context.FEE_INVOICE_ITEM.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
//#region//FEE_INVOICE_UPLOAD_ITEM_LOG
//var entinvtup = context.FEE_INVOICE_UPLOAD_ITEM_LOG.Where(m => m.FEE == entPYMItems.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == entPYMItems.COMPANY_CODE).ToList();
//foreach (var accr in entinvtup)
//{
// FEE_INVOICE_UPLOAD_ITEM_LOG ent_accr_item = new FEE_INVOICE_UPLOAD_ITEM_LOG();
// ent_accr_item = context.FEE_INVOICE_UPLOAD_ITEM_LOG.Find(accr.ID);
// ent_accr_item.FEE = entPYMItems.PAYMENT_ITEMS_NAME;
// ent_accr_item.CCT_CODE = entPYMItems.CCT_CODE;
// ent_accr_item.FUND_CODE = entPYMItems.FUND_CODE;
// ent_accr_item.GL_ACCOUNT = entPYMItems.GL_ACCOUNT;
// ent_accr_item.CHANNELS = entPYMItems.CHANNELS;
// context.FEE_INVOICE_UPLOAD_ITEM_LOG.Attach(ent_accr_item);
// context.Entry(ent_accr_item).State = System.Data.Entity.EntityState.Modified;
// context.SaveChanges();
//}
//#endregion
#endregion
//Save Item
int sequence = 1;
foreach (var item in formData.pymItemsChargeList)
{
var entPYMItemsCharge = new PAYMENT_ITEMS_CHAGE();
item.PAYMENT_ITEMS_ID = entPYMItems.ID;
item.SEQUENCE = sequence;
item.COMPANY_CODE = formData.COMPANY_CODE;
item.PAYMENT_ITEMS_NAME = formData.PAYMENT_ITEMS_NAME;
MVMMappingService.MoveData(item, entPYMItemsCharge);
if (item.DeleteFlag)
{
ValidationResult resultdel = new ValidationResult();
resultdel = ValidateDeleteData(formData);
//Error
if (resultdel.ErrorFlag)
{
return(resultdel);
}
else
{
if (entPYMItemsCharge.ID != 0)
{
//Delete item
context.Entry(entPYMItemsCharge).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
}
else
{
entPYMItemsCharge.SEQUENCE = sequence;
sequence++;
if (entPYMItemsCharge.ID != 0)
{
context.Entry(entPYMItemsCharge).State = System.Data.Entity.EntityState.Modified;
}
else
{
context.PAYMENT_ITEMS_CHAGE.Add(entPYMItemsCharge);
}
}
context.SaveChanges();
}
}
//Commit Header and Item
scope.Complete();
result.Message = ResourceText.SuccessfulEdit;
result.MessageType = "S";
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
public override ValidationResult SaveCreate(PaymentItemsViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
try
{
result = ValidateFormData(formData, modelState);
//Error
if (result.ErrorFlag)
{
return(result);
}
using (TransactionScope scope = new TransactionScope())
{
var entPYMItems = new PAYMENT_ITEMS();
//Generate Auto Code
GeneratePaymentItemCode(formData);
//Copy data from viewmodel to model - for header
MVMMappingService.MoveData(formData, entPYMItems);
//Save Header
using (var context = new PYMFEEEntities())
{
context.PAYMENT_ITEMS.Add(entPYMItems);
context.SaveChanges();
//Save Item
//Copy data from viewmodel to model - for line item
int sequence = 1;
foreach (var item in formData.pymItemsChargeList)
{
if (item.DeleteFlag)
{
continue;
}
var entPYMItemsCharge = new PAYMENT_ITEMS_CHAGE();
item.PAYMENT_ITEMS_ID = entPYMItems.ID;
item.SEQUENCE = sequence;
item.COMPANY_CODE = formData.COMPANY_CODE;
item.PAYMENT_ITEMS_NAME = formData.PAYMENT_ITEMS_NAME;
MVMMappingService.MoveData(item, entPYMItemsCharge);
context.PAYMENT_ITEMS_CHAGE.Add(entPYMItemsCharge);
context.SaveChanges();
sequence++;
}
}
scope.Complete();
result.Message = ResourceText.SuccessfulSave;
result.MessageType = "S";
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
public override ValidationResult SaveEdit(AppCompositeRoleViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
try
{
result = ValidateFormData(formData, modelState);
//Error
if (result.ErrorFlag)
{
return(result);
}
if (formData.ID <= 0)
{
result.Message = ValidatorMessage.id_not_found;
result.ModelStateErrorList.Add(new ModelStateError("", result.Message));
result.ErrorFlag = true;
return(result);
}
using (TransactionScope scope = new TransactionScope())
{
using (var context = new PYMFEEEntities())
{
var appCompositeRole = new AppCompositeRole();
MVMMappingService.MoveData(formData, appCompositeRole);
context.Entry(appCompositeRole).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
//Delete Items
context.AppCompositeRoleItems.RemoveRange(context.AppCompositeRoleItems.Where(m => m.CompositeRoleID == appCompositeRole.ID).ToList());
context.SaveChanges();
//Save Items
if (appCompositeRole.ID > 0)
{
List <string> roleList = new List <string>();
if (!string.IsNullOrEmpty(formData.AppMenuSelectedJSON))
{
roleList = GetRoleListFromJSON(formData.AppMenuSelectedJSON);
List <AppCompositeRoleItem> items = new List <AppCompositeRoleItem>();
foreach (var role in roleList)
{
if (string.IsNullOrEmpty(role))
{
continue;
}
var item = new AppCompositeRoleItem();
item.CompositeRoleID = appCompositeRole.ID;
item.RoleID = role;
items.Add(item);
}
if (items.Count > 0)
{
context.AppCompositeRoleItems.AddRange(items);
context.SaveChanges();
}
}
}//End Save Items
scope.Complete();
}//End Transaction
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
public override ValidationResult SaveEdit(AssignUserRoleViewModel formData, ModelStateDictionary modelState)
{
ValidationResult result = new ValidationResult();
try
{
result = ValidateFormData(formData, modelState);
//Error
if (result.ErrorFlag)
{
return(result);
}
var _context = new PYMFEEEntities();
#region signal
//var signal = _context.UserSignatures.Where(m => m.Username == formData.UserName).FirstOrDefault();
//if (signal != null)
//{
// formData.AssignUserRoleItem.PhotoFileName = signal.SignatureFileName;
//}
#endregion
using (TransactionScope scope = new TransactionScope())
{
//Save Header
using (var context = new PYMFEEEntities())
{
//Save Item
foreach (var item in formData.AssignUserRoleItemList)
{
var _entAssignUserRoleItem = new UserRole();
item.CREATE_BY = formData.CREATE_BY;
item.CREATE_DATE = formData.CREATE_DATE;
item.MODIFIED_BY = formData.MODIFIED_BY;
item.MODIFIED_DATE = formData.MODIFIED_DATE;
MVMMappingService.MoveData(item, _entAssignUserRoleItem);
_entAssignUserRoleItem.USERID = formData.AssignUserCode;
if (item.DeleteFlag)
{
if (_entAssignUserRoleItem.ID != 0)
{
context.Entry(_entAssignUserRoleItem).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
else
{
if (_entAssignUserRoleItem.ID != 0)
{
context.Entry(_entAssignUserRoleItem).State = System.Data.Entity.EntityState.Modified;
}
else
{
context.UserRoles.Add(_entAssignUserRoleItem);
}
context.SaveChanges();
}
//context.SaveChanges();
}
#region Manage UserSignature
////UserSignature
//var _entUserSignature = new UserSignature();
//_entUserSignature.Username = formData.UserName;
//_entUserSignature.CreateBy = formData.CREATE_BY;
//_entUserSignature.CreateDate = formData.CREATE_DATE;
//_entUserSignature.LastModifyBy = formData.MODIFIED_BY;
//_entUserSignature.LastModifyDate = formData.MODIFIED_DATE;
//_entUserSignature.SignatureFileName = formData.Photo.PhotoSavedFilename;
//if (formData.Photo.DeletedPhotoFlag)
//{
// if (signal != null)
// {
// context.Entry(signal).State = System.Data.Entity.EntityState.Deleted;
// context.SaveChanges();
// }
//}
//else
//{
// if (!string.IsNullOrEmpty(formData.Photo.PhotoSavedFilename))
// {
// if (signal != null)
// {
// context.Entry(_entUserSignature).State = System.Data.Entity.EntityState.Modified;
// }
// else
// {
// context.UserSignatures.Add(_entUserSignature);
// }
// context.SaveChanges();
// }
//}
#endregion
}
//Commit Header and Item
scope.Complete();
//Manage photo file
ManagePhotoFile(formData);
result.Message = ResourceText.SuccessfulEdit;
result.MessageType = "S";
}
}
catch (Exception ex)
{
result.Message = ex.ToString();
result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString()));
result.ErrorFlag = true;
}
return(result);
}
public AssignUserRoleViewModel GetDetail(int recordKey, string formState, string assignUserRoleCode, string assignUserType)
{
AssignUserRoleViewModel assignUserRole = NewFormData();
assignUserRole.FormState = formState;
assignUserRole.FormAction = formState;
var userInfo = UserService.GetSessionUserInfo();
try
{
using (var context = new PYMFEEEntities())
{
var assignUserRoleList = GetAssignUserRoleList(assignUserRoleCode).FirstOrDefault();
assignUserRole.AssignUserCode = assignUserRoleList.AssignUserCode;
assignUserRole.AssignUserName = assignUserRoleList.AssignUserName;
assignUserRole.UserName = assignUserRoleList.UserName;
assignUserRole.AssignUserType = assignUserType;
assignUserRole.CREATE_BY = userInfo.UserCode;
assignUserRole.CREATE_DATE = DateTime.Now;
//Get line item
List <UserRole> assignUserRoleItemList = (from m in context.UserRoles
where m.USERID == assignUserRoleCode
select m).OrderBy(m => m.CompositeRoleID).ToList();
//var appComposite = context.AppCompositeRoles.Where(m => m.Status == ConstantVariableService.ConfigStatusActive).OrderBy(m => m.Name).ToList();
var appComposite = context.AppCompositeRoles.OrderBy(m => m.Name).ToList();
foreach (var item in assignUserRoleItemList)
{
AssignUserRoleItemViewModel assignUserRoleItem = new AssignUserRoleItemViewModel();
MVMMappingService.MoveData(item, assignUserRoleItem);
assignUserRoleItem.CompositeRoleID = item.CompositeRoleID;
assignUserRoleItem.CompositeRoleList = appComposite;
assignUserRoleItem.StatusText = ValueHelpService.GetValueHelpText("CONFIGSTATUS", appComposite.SingleOrDefault(m => m.ID == item.CompositeRoleID).Status).ValueText;
assignUserRole.AssignUserRoleItemList.Add(assignUserRoleItem);
//Get line item
}
////Setting Signature
//var UserSignal = context.UserSignatures.Where(m => m.Username == assignUserRole.UserName).FirstOrDefault();
////Photo
//if (UserSignal != null )
//{
// string documentPath = AttachmentService.GetDocumentFilePath(AssignUserRoleViewModel.ProcessCode);
// //Check file is existing
// string filePath = System.Web.HttpContext.Current.Server.MapPath(documentPath);
// string file = Path.Combine(filePath, UserSignal.SignatureFileName);
// if (System.IO.File.Exists(file))
// {
// assignUserRole.Photo.PreviewPhoto = VirtualPathUtility.ToAbsolute(documentPath + "/" + UserSignal.SignatureFileName);
// }
//}
}
}
catch (Exception ex)
{
}
return(assignUserRole);
}
