public override PaymentItemsViewModel NewFormData() { PaymentItemsViewModel model = new PaymentItemsViewModel(); try { var userInfo = UserService.GetSessionUserInfo(); var list = new List <SelectListItem>(); using (var context = new PYMFEEEntities()) { var getCompanyList = (from data in context.COMPANies where data.IsPaymentFee == true orderby data.Bussiness_Unit select data).ToList(); list.AddRange(getCompanyList.Select(com => new SelectListItem { Value = com.BAN_COMPANY.ToString(), Text = com.COMPANY_NAME_EN.ToString() }).ToList()); model.CompanyLst = list; var pym_List = ValueHelpService.GetValueHelp(ConstantVariableService.ISACTIONTYPE); model.IsActionList = pym_List; var durationList = ValueHelpService.GetValueHelp(ConstantVariableService.DURATIONTYPE, ConstantVariableService.ConfigStatusActive); model.DurationList = durationList; } model.CREATE_BY = userInfo.UserCode; model.CREATE_DATE = DateTime.Now; //model.LASTMODIFIED_BY = userInfo.UserCode; //model.LASTMODIFIED_DATE = DateTime.Now; model.ChannelsList = ValueHelpService.GetValueHelp("CHANNELS").ToList(); } catch (Exception) { throw; } return(model); }
public ValidationResult ValidateDeleteData(PaymentItemsViewModel formData, bool flagMain = false) { ValidationResult result = new ValidationResult(); try { using (var context = new PYMFEEEntities()) { //Get item => deleteFlag != true var itemList = formData.pymItemsChargeList.Where(m => m.DeleteFlag == true).ToList(); foreach (var item in itemList) { var inv_item_ent = (from m in context.FEE_INVOICE_ITEM where m.PAYMENT_ITEMS_CODE == formData.PAYMENT_ITEMS_CODE && m.PAYMENT_ITEMS_FEE_ITEM.Contains(item.PAYMENT_ITEMS_FEE_NAME) && m.COMPANY_CODE == formData.COMPANY_CODE select m).FirstOrDefault(); if (inv_item_ent != null) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.cannot_request_delete, item.PAYMENT_ITEMS_FEE_NAME))); result.ErrorFlag = true; } } } } catch (Exception ex) { throw ex; } return(result); }
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 static List <AppMenu> GetSideMenu(User user) { List <AppMenu> userMenuList = new List <AppMenu>(); try { using (var context = new PYMFEEEntities()) { var appMenus = (from m in context.AppMenus select m).ToList(); //Check menu which user have role to display var roleMenuList = appMenus.Where(b => user.RoleList.Any(a => a.RoleID.Equals(b.RoleForDisplay, StringComparison.OrdinalIgnoreCase)) || user.RoleList.Any(a => a.RoleID.Equals(b.RoleForManage, StringComparison.OrdinalIgnoreCase))).ToList(); //var groupMenuList = appMenus.Where(b => b.MenuType.Equals("GROUP", StringComparison.OrdinalIgnoreCase)).ToList(); var groupMenuList = appMenus.Where(b => b.MenuType == "GROUP").ToList(); //Find parent menu int maxParent = 10; //Prevent infinity loop foreach (var item in roleMenuList) { bool findParent = true; int countParent = 0; var parentMenuCode = item.ParentMenuCode; userMenuList.Add(item); while (findParent && !string.IsNullOrEmpty(parentMenuCode) && countParent < maxParent) { AppMenu parentMenu = appMenus.FirstOrDefault(b => b.MenuCode.Equals(parentMenuCode, StringComparison.OrdinalIgnoreCase)); if (!parentMenu.MenuCode.Equals(ConstantVariableService.RootMenuCode, StringComparison.OrdinalIgnoreCase)) { findParent = true; parentMenuCode = parentMenu.ParentMenuCode; userMenuList.Add(parentMenu); } else { findParent = false; } countParent++; } } //Remove duplicate menu userMenuList = userMenuList.Distinct().ToList(); } } catch (Exception ex) { } return(userMenuList); }
public static void ManageAttachment(List <AttachmentViewModel> attachmentList) { try { //User userInfo = UserService.GetSessionUserInfo(); using (TransactionScope scope = new TransactionScope()) { using (var context = new PYMFEEEntities()) { //Save attachment foreach (var attachmentViewModel in attachmentList) { var attachment = new Attachment(); MVMMappingService.MoveData(attachmentViewModel, attachment); if (attachmentViewModel.DeleteFlag) { if (attachment.ID != 0) { context.Entry(attachment).State = System.Data.Entity.EntityState.Deleted; } } else { if (attachment.ID != 0) { context.Entry(attachment).State = System.Data.Entity.EntityState.Modified; } else { attachment.AttachDate = DateTime.Now; attachment.AttachBy = ""; context.Attachments.Add(attachment); } } context.SaveChanges(); } } scope.Complete(); } //Move file AttachmentService.ManageFile(attachmentList); } catch (Exception ex) { } }
public string InitialGetRoleStatus(int roleID) { AssignUserRoleItemViewModel roleItem = new AssignUserRoleItemViewModel(); var context = new PYMFEEEntities(); var appComposite = context.AppCompositeRoles.Where(m => m.ID == roleID).OrderBy(m => m.Name).FirstOrDefault(); var valueStatus = ValueHelpService.GetValueHelpText("CONFIGSTATUS", appComposite.Status); if (valueStatus != null) { roleItem.StatusText = valueStatus.ValueText; } return(roleItem.StatusText); }
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 static List <ValueHelpViewModel> GetValueHelp(string valueType, string status = "") { List <ValueHelpViewModel> valueHelpList = new List <ValueHelpViewModel>(); try { if (string.IsNullOrEmpty(status)) { status = ConstantVariableService.ConfigStatusActive;; } using (var context = new PYMFEEEntities()) { IOrderedQueryable <ValueHelp> valueHelps; if (string.Equals(valueType, "ALL", StringComparison.OrdinalIgnoreCase)) { valueHelps = (from m in context.ValueHelps where m.Status == status select m).OrderBy(m => m.Sequence); } else { valueHelps = (from m in context.ValueHelps where m.ValueType == valueType && m.Status == status select m).OrderBy(m => m.Sequence); } foreach (var value in valueHelps) { ValueHelpViewModel valueHelp = new ValueHelpViewModel(); valueHelp.ID = value.ID; valueHelp.ValueKey = value.ValueKey; valueHelp.ValueText = value.ValueText; valueHelp.ValueType = value.ValueType; valueHelp.Status = value.Status; valueHelpList.Add(valueHelp); } } } catch (Exception ex) { } return(valueHelpList); }
public static int?GetColumnLength <T>(String columnName) { int?result = null; using (var context = new PYMFEEEntities()) { var entType = typeof(T); var objectContext = ((IObjectContextAdapter)context).ObjectContext; var items = objectContext.MetadataWorkspace.GetItems(DataSpace.CSpace); if (items == null) { return(null); } var q = items .Where(m => m.BuiltInTypeKind == BuiltInTypeKind.EntityType) .SelectMany(meta => ((EntityType)meta).Properties .Where(p => p.Name == columnName && p.TypeUsage.EdmType.Name == "String")); var queryResult = q.Where(p => { var match = p.DeclaringType.Name == entType.Name; if (!match) { match = entType.Name == p.DeclaringType.Name; } return(match); }) .Select(sel => sel.TypeUsage.Facets["MaxLength"].Value) .ToList(); if (queryResult.Any()) { String checkMaxText = queryResult.First().ToString(); if (checkMaxText.ToUpper().IndexOf("MAX") >= 0) { result = 1000; } else { result = Convert.ToInt32(queryResult.First()); } } return(result); } }
public static List <AppSingleRole> GetRole(string username) { List <AppSingleRole> roleList = new List <AppSingleRole>(); AppSingleRole role = new AppSingleRole(); #if DEBUG //For test, add super admin role role = new AppSingleRole(); role.RoleID = ConstantVariableService.RoleSuperAdmin; roleList.Add(role); roleList = GetSuperAdminSingleRole(); #endif try { using (var context = new PYMFEEEntities()) { var user = (from m in context.USERS where m.USERNAME == username select m).FirstOrDefault(); string userId = user == null ? "" : user.USERID; var userCompRoleList = (from m in context.UserRoles join n in context.AppCompositeRoles on m.CompositeRoleID equals n.ID where m.USERID == userId //&& //n.Status == ConstantVariableService.ConfigStatusActive select m).ToList(); if (userCompRoleList.Any()) { foreach (var compRole in userCompRoleList) { var compRoleItemList = (from m in context.AppCompositeRoleItems where m.CompositeRoleID == compRole.CompositeRoleID select m).ToList(); foreach (var compRoleItem in compRoleItemList) { role = new AppSingleRole(); role.RoleID = compRoleItem.RoleID; roleList.Add(role); } } } } } catch (Exception ex) { } return(roleList); }
//For test user without manage data role public static List <AppSingleRole> GetDisplaySingleRole() { List <AppSingleRole> roleList = new List <AppSingleRole>(); try { using (var context = new PYMFEEEntities()) { roleList = (from m in context.AppSingleRoles where m.RoleID.Contains("Role_DS") select m).ToList(); } } catch (Exception ex) { } return(roleList); }
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); }
public AssignUserRoleItemViewModel InitialItem() { AssignUserRoleItemViewModel assignUserRoleItemViewModel = new AssignUserRoleItemViewModel(); List <AssignUserRoleItemViewModel> assignUserRoleItemList = new List <AssignUserRoleItemViewModel>(); try { var context = new PYMFEEEntities(); //var appComposite = context.AppCompositeRoles.Where(m => m.Status == ConstantVariableService.ConfigStatusActive).OrderBy(m => m.Name).ToList(); var appComposite = context.AppCompositeRoles.OrderBy(m => m.Name).ToList(); assignUserRoleItemViewModel.CompositeRoleList = appComposite; } catch (Exception ex) { } return(assignUserRoleItemViewModel); }
public static List <AppMenuViewModel> GetAppMenu() { List <AppMenuViewModel> userMenuList = new List <AppMenuViewModel>(); try { using (var context = new PYMFEEEntities()) { var appMenus = (from m in context.AppMenus select m).ToList(); var parentMenus = appMenus.Where(m => m.ParentMenuCode == null).FirstOrDefault(); userMenuList = GetAppMenuUnder(parentMenus, appMenus); } } catch (Exception ex) { } return(userMenuList); }
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 static List <AppSingleRole> GetSuperAdminSingleRole() { List <AppSingleRole> roleList = new List <AppSingleRole>(); try { using (var context = new PYMFEEEntities()) { roleList = (from m in context.AppSingleRoles select m).ToList(); } } catch (Exception ex) { } var role = new AppSingleRole(); role.RoleID = ConstantVariableService.RoleSuperAdmin; roleList.Add(role); return(roleList); }
public List <AssignUserRoleViewModel> GetAssignUserRoleList(string _userRoleCode = "")//(string userRole, string userRoleCode = "") { List <AssignUserRoleViewModel> assignUserRoleList = new List <AssignUserRoleViewModel>(); ValueHelpViewModel valueHelp = new ValueHelpViewModel(); try { using (var context = new PYMFEEEntities()) { var userRol = string.IsNullOrEmpty(_userRoleCode)? (from user in context.UserRoles select user).ToList() : (from user in context.UserRoles where user.USERID == _userRoleCode select user).ToList();; var assignUserRoleEmp = string.IsNullOrEmpty(_userRoleCode) ? (from emp in context.USERS select emp).ToList() : (from emp in context.USERS where emp.USERID == _userRoleCode select emp).ToList(); foreach (var item in assignUserRoleEmp) { string _getIcon = Convert.ToString(userRol.Where(m => m.USERID == item.USERID).FirstOrDefault()); var assign = new AssignUserRoleViewModel(); string icon = ""; if (!string.IsNullOrEmpty(item.USERID) && !string.IsNullOrEmpty(_getIcon)) { icon = "<i class=\"fa fa-check-circle\" style=\"color: #4277f4; font-size: 20px\"></i>"; } assign.AssignUserCode = item.USERID; assign.AssignUserName = item.USERNAME; assign.UserName = item.USERNAME; assign.AssignUserRoleIcon = icon; assign.AssignAvailableReason = ValidatorMessage.cannot_assignuserrole_action; assignUserRoleList.Add(assign); } } } catch (Exception ex) { } return(assignUserRoleList); }
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 void GeneratePaymentItemCode(PaymentItemsViewModel formData) { try { string fee = formData.PAYMENT_ITEMS_NAME.Trim(); string pymName = fee.Replace(" ", "").Length > 14 ? fee.Replace(" ", "").Substring(0, 15) : fee.Replace(" ", ""); using (var context = new PYMFEEEntities()) { var entpymItemsData = (from m in context.PAYMENT_ITEMS select m).ToList(); var getNewpymItems = entpymItemsData.Where(m => m.COMPANY_CODE == formData.COMPANY_CODE).ToList(); if (getNewpymItems.Any()) { //int seqgetNewpymItems = getNewpymItems.Count() + 1; //formData.GROUP_SEQ_CHANNELS = seqgetNewpymItems; formData.GROUP_SEQ_CHANNELS = getNewpymItems.Max(m => m.GROUP_SEQ_CHANNELS) + 1; formData.SEQ_CHANNELS = (getNewpymItems.Where(m => m.CHANNELS == formData.CHANNELS).ToList()).Any() ? getNewpymItems.Where(m => m.CHANNELS == formData.CHANNELS).FirstOrDefault().SEQ_CHANNELS : getNewpymItems.ToList().GroupBy(m => m.SEQ_CHANNELS).ToList().Max(m => m.Key) + 1; formData.PAYMENT_ITEMS_CODE = formData.COMPANY_CODE + pymName + DateTime.Now.Date.ToString("yyyymmdd") + "_" + formData.GROUP_SEQ_CHANNELS; } else { formData.PAYMENT_ITEMS_CODE = formData.COMPANY_CODE + pymName + DateTime.Now.Date.ToString("yyyymmdd"); } } } catch (Exception ex) { throw ex; } }
public PaymentItemsViewModel InitialListSearch() { PaymentItemsViewModel model = new PaymentItemsViewModel(); try { model.COMPANY_CODE = ""; var list = new List <SelectListItem>(); using (var context = new PYMFEEEntities()) { var getCompanyList = (from data in context.COMPANies where data.IsPaymentFee == true orderby data.Bussiness_Unit select data).ToList(); list.AddRange(getCompanyList.Select(com => new SelectListItem { Value = com.BAN_COMPANY.ToString(), Text = com.COMPANY_NAME_EN.ToString() }).ToList()); model.CompanyLst = list; } } catch (Exception ex) { throw ex; } return(model); }
public override ValidationResult ValidateFormData(PaymentItemsViewModel formData, ModelStateDictionary modelState) { ValidationResult result = new ValidationResult(); //User Type User user = UserService.GetSessionUserInfo(); try { #region mark delete //if (string.Equals(formData.FormAction, ConstantVariableService.FormActionDelete, StringComparison.OrdinalIgnoreCase)) //{ // using (var context = new PYMFEEEntities()) // { // //FEE_ACCRUED_PLAN_ITEM // var fund_inAccr = (from m in context.FEE_ACCRUED_PLAN_ITEM where m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == m.COMPANY_CODE select m).ToList(); // //FEE_ACCRUED_PLAN_ITEM_SUB // var fund_inAccrSub = (from m in context.FEE_ACCRUED_PLAN_ITEM_SUB where m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == m.COMPANY_CODE select m).ToList(); // //FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG // var fund_inAccrUpload = (from m in context.FEE_ACCRUED_PLAN_UPLOAD_ITEM_LOG where m.FEE == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == formData.COMPANY_CODE select m).ToList(); // //FEE_INVOICE // var fund_inInv = (from m in context.FEE_INVOICE where m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == formData.COMPANY_CODE select m).ToList(); // //FEE_INVOICE_ITEM // var fund_inInvitem = (from m in context.FEE_INVOICE_ITEM where m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == formData.COMPANY_CODE select m).ToList(); // //FEE_INVOICE_UPLOAD_ITEM_LOG // var fund_inInvupload = (from m in context.FEE_INVOICE_UPLOAD_ITEM_LOG where m.FEE == formData.PAYMENT_ITEMS_NAME && m.COMPANY_CODE == formData.COMPANY_CODE select m).ToList(); // if ( // fund_inAccr.Any() || fund_inAccrSub.Any() || fund_inAccrUpload.Any() || fund_inInv.Any() || fund_inInvitem.Any() || fund_inInvupload.Any() // ) // { // result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.cannot_request_delete, formData.PAYMENT_ITEMS_NAME))); // result.ErrorFlag = true; // } // } //} //else //{ } #endregion if (!modelState.IsValid) { result.ModelStateErrorList = UtilityService.GetModelStateErrors(modelState); result.ErrorFlag = true; } else { //Get item => deleteFlag != true var itemList = formData.pymItemsChargeList.Where(m => m.DeleteFlag != true).ToList(); if (itemList == null || !itemList.Any()) //Check list is null or empty { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.item_listnull_error, ResourceText.TitlePaymentItemList))); result.ErrorFlag = true; } else { //Check item int line = 1; foreach (var item in itemList) { //charge id not empty if (item.PAYMENT_ITEMS_FEE_NAME == null) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.item_notempty_seq_at_error, ResourceText.PAYMENT_ITEMS_FEE_ITEM, line.ToString()))); result.ErrorFlag = true; } else { item.PAYMENT_ITEMS_FEE_NAME = item.PAYMENT_ITEMS_FEE_NAME.Trim(); } //charge id not empty if (item.CHARGE_TYPE == null) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.item_notempty_seq_at_error, ResourceText.Charge, line.ToString()))); result.ErrorFlag = true; } //charge id not empty if (item.IS_ACTIVE == null) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.item_notempty_seq_at_error, ResourceText.Isactive, line.ToString()))); result.ErrorFlag = true; } if (user.AuthorizeAdmin != ConstantVariableService.AuthorizeAdmin && item.IS_ACTIVE == false) { InvoiceService servoice_inv = new InvoiceService(); var noneActivePro = servoice_inv.GetPaymentItemsList(formData.COMPANY_CODE, 1, DateTime.Now.Date.Month, 2018, DateTime.Now.Date.Year, formData.PAYMENT_ITEMS_NAME, "0", 0); if (noneActivePro.Any()) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.cannot_action_status_cancel_error, ResourceText.Isactive, formData.PAYMENT_ITEMS_NAME, line.ToString()))); result.ErrorFlag = true; } } var dupPaymentItem = itemList.GroupBy(m => string.IsNullOrEmpty(m.PAYMENT_ITEMS_FEE_NAME) ? m.PAYMENT_ITEMS_FEE_NAME : m.PAYMENT_ITEMS_FEE_NAME.Trim()).Where(m => m.Count() > 1).ToList(); foreach (var itemDup in dupPaymentItem) { string payment_name = string.IsNullOrEmpty(item.PAYMENT_ITEMS_FEE_NAME) ? item.PAYMENT_ITEMS_FEE_NAME : item.PAYMENT_ITEMS_FEE_NAME.Trim(); //--wainting test upload invoice if (payment_name == itemDup.Key) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.item_duplicate_error, ResourceText.PAYMENT_ITEMS_FEE_ITEM + " " + itemDup.Key, line.ToString()))); result.ErrorFlag = true; } } line++; } using (var context = new PYMFEEEntities()) { //Dup In Data Invoice if (formData.FormAction == ConstantVariableService.FormActionCreate || formData.FormAction == ConstantVariableService.FormActionCopy) { var pymItems = (from m in context.PAYMENT_ITEMS where m.COMPANY_CODE == formData.COMPANY_CODE && m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME.Trim() select m).ToList(); if (pymItems.Any()) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.duplicate_error, ResourceText.PAYMENT_ITEMS_CODE + " " + formData.PAYMENT_ITEMS_NAME))); result.ErrorFlag = true; } } //Dup In Data Invoice if (formData.FormAction == ConstantVariableService.FormActionEdit) { var pymItems = (from m in context.PAYMENT_ITEMS where m.COMPANY_CODE == formData.COMPANY_CODE && m.PAYMENT_ITEMS_NAME == formData.PAYMENT_ITEMS_NAME.Trim() && m.ID != formData.ID select m).ToList(); if (pymItems.Any()) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.duplicate_error, ResourceText.PAYMENT_ITEMS_CODE + " " + formData.PAYMENT_ITEMS_NAME))); result.ErrorFlag = true; } } //Delete Action if (formData.FormAction == ConstantVariableService.FormActionDelete) { var inv_ent = (from m in context.FEE_INVOICE where m.PAYMENT_ITEMS_CODE == formData.PAYMENT_ITEMS_CODE select m).FirstOrDefault(); if (inv_ent != null) { result.ModelStateErrorList.Add(new ModelStateError("", string.Format(ValidatorMessage.cannot_request_delete, formData.PAYMENT_ITEMS_NAME))); result.ErrorFlag = true; } } } } } } catch (Exception ex) { throw ex; } 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(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 static User GetUserInfo(string username, bool backgroundProcess = false) { User user = new User(); user.ADUser = username; try { using (var context = new PYMFEEEntities()) { //var employee = (from m in context.USERS // where m.ADUser == user.ADUser && // m.EmpStatus == "3" //Active // select m).FirstOrDefault(); //if (employee != null) //{ // user.UserType = ConstantVariableService.UserTypeEmployee; // user.UserCode = employee.EmpNo; // user.DisplayNameTH = employee.TitleTH + employee.FirstnameTH + " " + employee.LastnameTH; // user.DisplayNameEN = employee.TitleEN + employee.FirstnameEN + " " + employee.LastnameEN; // user.Email = employee.Email; //} ////Not employee then check with agent //if (string.IsNullOrEmpty(user.UserCode)) //{ // var agent = (from m in context.AgentInfoes // join n in context.AgentMasters on m.AgentCode equals n.AgentCode // where m.ADUser == user.ADUser && // m.Status == ConstantVariableService.AgentStatusOpen // select new { AgentInfo = m, AgentMaster = n }).FirstOrDefault(); // if (agent != null) // { // user.UserType = ConstantVariableService.UserTypeAgent; // user.UserCode = agent.AgentMaster.AgentCode; // user.DisplayNameTH = agent.AgentMaster.Name; // user.DisplayNameEN = agent.AgentInfo.NameEN; // user.Email = agent.AgentInfo.Email; // } //} ////Not employee, agent then check with external audit //if (string.IsNullOrEmpty(user.UserCode)) //{ // var today = DateTime.Today; // var externalAudit = (from m in context.ExternalAudits // where m.ADUser == user.ADUser && // m.ADuserStartDate <= today && // m.ADUserEndDate >= today // select m).FirstOrDefault(); // if (externalAudit != null) // { // user.UserType = ConstantVariableService.UserTypeExternalAudit; // user.UserCode = externalAudit.ExternalAuditCode; // user.DisplayNameTH = externalAudit.NameTH; // user.DisplayNameEN = externalAudit.NameEN; // user.Email = externalAudit.Email; // } //} //Not employee, agent then check with user employee if (string.IsNullOrEmpty(user.UserCode)) { var today = DateTime.Today; var emp = (from m in context.USERS where m.USERNAME == username select m).FirstOrDefault(); if (emp != null) { user.UserType = ""; user.UserCode = emp.USERID; user.DisplayNameTH = emp.NAME; user.DisplayNameEN = emp.NAME; user.Email = emp.Email; var userRole = (from r in context.UserRoles where r.USERID == user.UserCode select r).FirstOrDefault(); var compositeRole = (from n in context.AppCompositeRoles select n).ToList(); var chkAuthirizeAdmin = compositeRole.Where(c => c.ID == (userRole == null?0: userRole.CompositeRoleID)).FirstOrDefault(); user.AuthorizeAdmin = (chkAuthirizeAdmin == null?"": chkAuthirizeAdmin.Name); } } if (!backgroundProcess) { if (!string.IsNullOrEmpty(user.UserCode)) { user.RoleList = GetRole(username); user.SideMenuHTML = GetSideMenuHTML(user); } } } } catch (Exception ex) { } // For test role for display only // if (string.Equals(username, "BOONRAWD_LOCAL\\user_spst04", StringComparison.OrdinalIgnoreCase)) // { // user.RoleList = GetDisplaySingleRole(); // user.SideMenuHTML = GetSideMenuHTML(user); // } // End for test role display only //user.RoleList = GetRole(username); //user.SideMenuHTML = GetSideMenuHTML(user); return(user); }
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 List <DahsboardBarchartViewModel> GetDataBarchartChannels() { List <DahsboardBarchartViewModel> dashboardList = new List <DahsboardBarchartViewModel>(); try { using (var contex = new PYMFEEEntities()) { var ent_inv = (from m in contex.FEE_INVOICE orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); var max_acc = (from m in contex.FEE_ACCRUED_PLAN_ITEM orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); var ent_pym = (from m in contex.PAYMENT_ITEMS select m).ToList(); var get_pym = ent_pym.GroupBy(g => g.PAYMENT_ITEMS_NAME).ToList(); var getmax_acc = (max_acc.Any() ? max_acc.Max(n => (n.ACCRUED_YEAR * 12) + n.ACCRUED_MONTH) : 0); var ent_acc = (from m in contex.FEE_ACCRUED_PLAN_ITEM where ((m.ACCRUED_YEAR * 12) + m.ACCRUED_MONTH) == getmax_acc orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); int monthS = 1; int monthE = DateTime.Now.Month; int yearS = 2018; int yearE = DateTime.Now.Year; int diffMonth = (((yearE * 12) + monthE) - ((yearS * 12) + monthS)) + 1; int mnth = monthS; int yr = yearS; var culture = CultureInfo.GetCultureInfo("en-US"); var dateTimeInfo = DateTimeFormatInfo.GetInstance(culture); foreach (var item in get_pym) { var get_pymLst = ent_pym.Where(p => p.PAYMENT_ITEMS_NAME == item.Key).ToList(); //for (int i = 1; i <= diffMonth; i++) //{ // if (mnth == 13) // { // mnth = 1; // yr++; // } var get_inv = ent_inv.Where(m => get_pymLst.Any(o => m.PAYMENT_ITEMS_CODE == o.PAYMENT_ITEMS_CODE) //&&((m.INV_YEAR * 12) + m.INV_MONTH) == ((yr * 12) + mnth) ).ToList(); var get_acc = ent_acc.Where(m => get_pymLst.Any(o => m.PAYMENT_ITEMS_CODE == o.PAYMENT_ITEMS_CODE) //&&((m.INV_YEAR * 12) + m.INV_MONTH) == ((yr * 12) + mnth) ).ToList(); decimal act = get_inv.Any() ? get_inv.Sum(s => (s.NET_AMOUNT ?? 0)) : 0; decimal acc = get_acc.Any() ? get_acc.Sum(s => (s.INV_AMOUNT ?? 0)) : 0; decimal sumall = act + acc; decimal sumact = (sumall == 0) ? 0 : (act / sumall) * 100; decimal sumacc = (sumall == 0) ? 0 : (acc / sumall) * 100; sumact = Math.Round(sumact, 2, MidpointRounding.AwayFromZero); sumacc = Math.Round(sumacc, 2, MidpointRounding.AwayFromZero); DahsboardBarchartViewModel model = new DahsboardBarchartViewModel(); model.PriceCatalog = item.Key; model.Actual = sumact; model.Accrued = sumacc; //model.MonthNameFee = dateTimeInfo.AbbreviatedMonthNames[mnth - 1] + yr.ToString().Substring(2, 2); //CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(mnth)+yr.ToString().Substring(2,2); model.MonthFee = 100; dashboardList.Add(model); // mnth++; //} } } } catch (Exception ex) { throw ex; } return(dashboardList); }
public ValidationResult Login(AuthenticationViewModel authen, HttpResponseBase response) { ValidationResult result = new ValidationResult(); string domainUser = ""; result.ErrorFlag = true; //Clear previous login data this.Logout(response); byte[] passwordBytes = MachineKey.Protect(Encoding.UTF8.GetBytes(authen.Password), WebConfigurationManager.AppSettings["UserdataSALT"]); string protectedPassword = UtilityService.ConvertBytesToString(passwordBytes); #if DEBUG //Test convert bytes to string and decode string enct = UtilityService.ConvertBytesToString(passwordBytes); byte[] enc2 = UtilityService.ConvertStringToBytes(enct); byte[] dc = MachineKey.Unprotect(enc2, WebConfigurationManager.AppSettings["UserdataSALT"]); string originalString = Encoding.UTF8.GetString(dc); result.ErrorFlag = false; domainUser = authen.Username; #region mark //if (authen.Username.StartsWith("user", StringComparison.OrdinalIgnoreCase)) //{ // domainUser = WebConfigurationManager.AppSettings["EmployeeDomain"] + authen.Username; //} //else if (authen.Username.StartsWith("agent", StringComparison.OrdinalIgnoreCase)) //{ // domainUser = WebConfigurationManager.AppSettings["AgentDomain"] + authen.Username; //} //else if (authen.Username.StartsWith("audit", StringComparison.OrdinalIgnoreCase)) //{ // domainUser = WebConfigurationManager.AppSettings["ExternalAuditDomain"] + authen.Username; //} #endregion string userData = string.Empty; using (var context = new PYMFEEEntities()) { var validUser = context.ValidateUser(authen.Username, authen.Password).FirstOrDefault(); if (!validUser.Equals("Non", StringComparison.OrdinalIgnoreCase)) { var userDataList = UserService.GetRole(authen.Username); if (userDataList.Any()) { userData = string.Join(",", userDataList.Select(m => m.RoleID).ToList()); } result.ErrorFlag = false; } else { result.Message = ValidatorMessage.login_fail; result.ModelStateErrorList.Add(new ModelStateError("", ValidatorMessage.login_fail)); result.ErrorFlag = true; } } //FormsAuthentication.SetAuthCookie(authen.Username, false); //var debugTicket = new FormsAuthenticationTicket(1, authen.Username, DateTime.Now, DateTime.Now.AddMinutes(20), false, "Role_MA_Invoice,Role_DS_Invoice"); //string encryptedDebugTicket = FormsAuthentication.Encrypt(debugTicket); //var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedDebugTicket); //response.Cookies.Add(authCookie); FormsAuthenticationTicket debugTicket = new FormsAuthenticationTicket ( 1, // version domainUser, // name DateTime.Now, // issueDate DateTime.Now.Add(FormsAuthentication.Timeout), // expiration false, // isPersistent userData, //"Role_MA_Invoice,Role_DS_Invoice",//protectedPassword, // userData FormsAuthentication.FormsCookiePath // cookiePath ); string encryptedDebugTicket = FormsAuthentication.Encrypt(debugTicket); var debugCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedDebugTicket) { HttpOnly = true, // always set this to true! Secure = false, }; //GenericIdentity identity = new GenericIdentity(authen.Username); //string[] roles = { debugCookie.Value }; //or do it from the person object //GenericPrincipal principal = new System.Security.Principal.GenericPrincipal(identity, roles); //HttpContext.Current.User = principal; ////response.Cookies.Set(cookie); // Create the cookie. response.Cookies.Add(debugCookie); return(result); #endif try { string systemID = WebConfigurationManager.AppSettings["SystemID"]; //string url = ""; //byte[] responseBytes; //string responsefromserver; //JObject json; //string checkResult; bool loginOk = false; string loginMessage = ValidatorMessage.login_fail; //Encode password to base64 var passwordUTF8 = System.Text.Encoding.UTF8.GetBytes(authen.Password); var passwordBase64 = System.Convert.ToBase64String(passwordUTF8); using (WebClient webClient = new WebClient()) { NameValueCollection formData = new NameValueCollection(); formData["username"] = authen.Username; formData["password"] = passwordBase64; formData["system_id"] = systemID; // //First authenticate with employee // url = WebConfigurationManager.AppSettings["ADEmployeeURL"]; // responseBytes = webClient.UploadValues(url, "POST", formData); // responsefromserver = Encoding.UTF8.GetString(responseBytes); // json = JObject.Parse(responsefromserver); // checkResult = json["result"].Value<string>(); // if (string.Equals(checkResult, "success", StringComparison.OrdinalIgnoreCase)) // { // domainUser = WebConfigurationManager.AppSettings["EmployeeDomain"] + authen.Username; // loginOk = true; // } // if (!loginOk) // { // //Second authenticate with agent // url = WebConfigurationManager.AppSettings["ADAgentURL"]; // responseBytes = webClient.UploadValues(url, "POST", formData); // responsefromserver = Encoding.UTF8.GetString(responseBytes); // json = JObject.Parse(responsefromserver); // checkResult = json["result"].Value<string>(); // if (string.Equals(checkResult, "success", StringComparison.OrdinalIgnoreCase)) // { // domainUser = WebConfigurationManager.AppSettings["AgentDomain"] + authen.Username; // loginOk = true; // } // } // if (!loginOk) // { // //Third authenticate with external audit // url = WebConfigurationManager.AppSettings["ADExternalAuditURL"]; // responseBytes = webClient.UploadValues(url, "POST", formData); // responsefromserver = Encoding.UTF8.GetString(responseBytes); // json = JObject.Parse(responsefromserver); // checkResult = json["result"].Value<string>(); // if (string.Equals(checkResult, "success", StringComparison.OrdinalIgnoreCase)) // { // domainUser = WebConfigurationManager.AppSettings["ExternalAuditDomain"] + authen.Username; loginOk = true; // } // } //Check UserRole string _userData = string.Empty; if (loginOk) { using (var context = new PYMFEEEntities()) { var userDataList = UserService.GetRole(authen.Username); if (userDataList.Any()) { _userData = string.Join(",", userDataList.Select(m => m.RoleID).ToList()); } var entUser = (from m in context.USERS where m.USERNAME == authen.Username select m).FirstOrDefault(); string userId = entUser == null ? "" : entUser.USERID; var userCompRoleList = (from m in context.UserRoles join n in context.AppCompositeRoles on m.CompositeRoleID equals n.ID //Older UserName where m.USERID == userId //&& //n.Status == ConstantVariableService.ConfigStatusActive select m).ToList(); if (!userCompRoleList.Any()) { loginOk = false; loginMessage = ValidatorMessage.login_fail_no_user_role; } } } if (!loginOk) { result.Message = ValidatorMessage.login_fail; result.ModelStateErrorList.Add(new ModelStateError("", loginMessage)); result.ErrorFlag = true; } else { result.ErrorFlag = false; //Set cookie FormsAuthenticationTicket ticket = new FormsAuthenticationTicket ( 1, // version authen.Username, //domainUser, // name DateTime.Now, // issueDate DateTime.Now.Add(FormsAuthentication.Timeout), // expiration false, // isPersistent _userData, //protectedPassword, // userData FormsAuthentication.FormsCookiePath // cookiePath ); string encryptedTicket = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket) { HttpOnly = true, // always set this to true! Secure = false, }; // Create the cookie. response.Cookies.Add(cookie); } } } catch (Exception ex) { result.Message = ex.ToString(); result.ModelStateErrorList.Add(new ModelStateError("", ex.ToString())); result.ErrorFlag = true; } return(result); }
public List <AccruedDetailReportViewModel> GetInvoiceList() { List <AccruedDetailReportViewModel> modelList = new List <AccruedDetailReportViewModel>(); try { using (var context = new PYMFEEEntities()) { var ent_company = (from m in context.COMPANies where m.IsPaymentFee == true select m).ToList(); var ent_invList = (from m in context.FEE_INVOICE orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); //var ent_invItemList = (from m in context.FEE_INVOICE_ITEM orderby m.INV_MONTH, m.INV_YEAR select m).ToList(); var ent_pymList = (from m in context.PAYMENT_ITEMS where m.IS_ACTIVE == true orderby m.GROUP_SEQ_CHANNELS select m).ToList(); //var ent_pymChargeList = (from m in context.PAYMENT_ITEMS_CHAGE select m).ToList(); string getComp = "TI"; var get_invList = (from m in ent_invList where m.INV_MONTH >= 1 && m.INV_MONTH <= DateTime.Now.Date.Month && m.COMPANY_CODE == getComp select m).ToList(); ent_pymList = ent_pymList.Where(m => m.COMPANY_CODE == getComp).ToList(); var culture = CultureInfo.GetCultureInfo("en-US"); var dateTimeInfo = DateTimeFormatInfo.GetInstance(culture); var get_month = (DateTime.Now.Date.Year * 12 + DateTime.Now.Date.Month) - (DateTime.Now.Date.Year * 12 + 1); foreach (var item in ent_pymList) { var data_inv = get_invList.Where(m => m.PAYMENT_ITEMS_CODE == item.PAYMENT_ITEMS_CODE).ToList(); var model = new AccruedDetailReportViewModel(); model.FEE = "Inv. No."; for (int i = 0; i <= get_month; i++) { string inv = ""; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); inv = data_invMonth == null ? "" : data_invMonth.INV_NO; string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, inv); } model.CHARGE = "1"; modelList.Add(model); model = new AccruedDetailReportViewModel(); model.FEE = "Inv. Pro."; for (int i = 0; i <= get_month; i++) { string pro = ""; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); pro = data_invMonth == null ? "" : data_invMonth.PRO_NO; string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, pro); } model.CHARGE = "2"; modelList.Add(model); model = new AccruedDetailReportViewModel(); model.FEE = item.PAYMENT_ITEMS_NAME; for (int i = 0; i <= get_month; i++) { decimal amt = 0; //Convert.ToString(string.Format("{0:#,##0.####}", amt))); var data_invMonth = data_inv.Where(m => m.INV_MONTH == i + 1 && m.INV_YEAR == DateTime.Now.Date.Year).FirstOrDefault(); amt = data_invMonth == null ?0 :(data_invMonth.NET_AMOUNT ?? 0); string monthIndex = dateTimeInfo.AbbreviatedMonthNames[i]; model.GetType().GetProperty(monthIndex).SetValue(model, Convert.ToString(string.Format("{0:#,##0.####}", amt))); } model.CHARGE = "3"; modelList.Add(model); } } } catch (Exception ex) { throw; } return(modelList); }
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); }