public static void UpdateNewOrderDetails2(System.Windows.Controls.DataGrid grid, System.Data.Linq.EntitySet <OrderDetail> targetList) { int selIndex = grid.SelectedIndex; int diffIndex = grid.Items.Count - selIndex; if (diffIndex == 1) { //add item OrderDetail newOrderDetail = GetNewOrderDetail(true); //2011-4-2 새로추가 if (newOrderDetail != null) { targetList.Add(newOrderDetail); DataManager.Submit(); } grid.SelectedIndex = -1; } else if (selIndex > -1) { OrderDetail newOrderDetail = GetNewOrderDetail(false); if (newOrderDetail != null) { targetList[selIndex] = newOrderDetail; DataManager.Submit(); } else { targetList.RemoveAt(selIndex); DataManager.Submit(); } } }
private void btnAddTransaction_Click(object sender, EventArgs e) { try { if (ConvertToInt(comboEvent.SelectedValue) == 0) { comboEvent.Focus(); } else { gvTransaction.DataSource = trnbookeventBindingSource; trnbookeventBindingSource.DataSource = new System.Data.Linq.EntitySet <trn_book_event>(); var dateNow = DateTime.Now; _ListBookEvent.Add(new trn_book_event { mbe_id = ConvertToInt(comboEvent.SelectedValue), tbe_remark = txtTransaction.Text, tbe_date = dateTransaction.Value.Date.Add(ConvertToTime(txtTime.Text)), tbe_active = true, tbe_create_by = Program.CurrentUser.mut_username, tbe_create_date = dateNow, tbe_update_by = Program.CurrentUser.mut_username, tbe_update_date = dateNow }); comboEvent.SelectedValue = 0; txtTransaction.Text = ""; gvTransaction.DataSource = trnbookeventBindingSource; trnbookeventBindingSource.DataSource = _ListBookEvent; panel1.Enabled = true; trnbookeventBindingSource.Sort = "tbe_create_date DESC"; //setRowNo(); } } catch { } }
public ActionResult Edit(int id, FormCollection collection) { //Get Item From Database ApprovalGroup group = new ApprovalGroup(); group = approvalGroupRepository.GetGroup(id); //Check Exists if (group == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check Access RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToApprovalGroup(group.ApprovalGroupId)) { return(View("Error")); } //Update Model From Form + Validate against DB try { UpdateModel(group); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } if (group.HierarchyType != "Multiple") { //ClientSubUnitTravelerType has extra field string hierarchyCode = group.HierarchyCode; if (group.HierarchyType == "ClientSubUnitTravelerType") { group.ClientSubUnitGuid = hierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys } //Check Access Rights to Hierarchy HierarchyRepository hierarchyRepository = new HierarchyRepository(); if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(group.HierarchyType, hierarchyCode, group.SourceSystemCode, groupName)) { ViewData["Message"] = "You cannot add to this hierarchy item"; return(View("Error")); } } //Create Approval Group Approval Type Items from Post values System.Data.Linq.EntitySet <ApprovalGroupApprovalTypeItem> approvalGroupApprovalTypeItems = new System.Data.Linq.EntitySet <ApprovalGroupApprovalTypeItem>(); foreach (string key in collection) { if (key.StartsWith("ApprovalGroupApprovalTypeItem") && !string.IsNullOrEmpty(collection[key])) { string[] values = collection[key].Split(','); if (values[0] != null && values[1] != null && !string.IsNullOrEmpty(values[0]) && !string.IsNullOrEmpty(values[1])) { ApprovalGroupApprovalTypeItem approvalGroupApprovalTypeItem = new ApprovalGroupApprovalTypeItem() { ApprovalGroupApprovalTypeId = int.Parse(values[0]), ApprovalGroupApprovalTypeItemValue = values[1] }; approvalGroupApprovalTypeItems.Add(approvalGroupApprovalTypeItem); } } } //Remove Approval Group Approval Type Items if not set, otherwise add new ones in group.ApprovalGroupApprovalTypeItems = (approvalGroupApprovalTypeItems != null && approvalGroupApprovalTypeItems.Count > 0) ? approvalGroupApprovalTypeItems : null; //Database Update try { approvalGroupRepository.Edit(group); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ApprovalGroup.mvc/Edit/" + group.ApprovalGroupId.ToString(); return(View("VersionError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("ListUnDeleted")); }
public ActionResult Create(ApprovalGroup group, FormCollection collection) { //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Check Access Rights to Domain Hierarchy if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(group.HierarchyType, group.HierarchyCode, group.SourceSystemCode, groupName)) { ViewData["Message"] = "You cannot add to this hierarchy item"; return(View("Error")); } //Update Model From Form + Validate against DB try { UpdateModel(group); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //ClientSubUnitTravelerType has extra field string hierarchyCode = group.HierarchyCode; if (group.HierarchyType == "ClientSubUnitTravelerType") { group.ClientSubUnitGuid = hierarchyCode; //ClientSubUnitTravelerType has 2 primarykeys } //Create Approval Group Approval Type Items from Post values System.Data.Linq.EntitySet <ApprovalGroupApprovalTypeItem> approvalGroupApprovalTypeItems = new System.Data.Linq.EntitySet <ApprovalGroupApprovalTypeItem>(); foreach (string key in collection) { if (key.StartsWith("ApprovalGroupApprovalTypeItem") && !string.IsNullOrEmpty(collection[key])) { string[] values = collection[key].Split(','); if (values[0] != null && values[1] != null && !string.IsNullOrEmpty(values[0]) && !string.IsNullOrEmpty(values[1])) { ApprovalGroupApprovalTypeItem approvalGroupApprovalTypeItem = new ApprovalGroupApprovalTypeItem() { ApprovalGroupApprovalTypeId = int.Parse(values[0]), ApprovalGroupApprovalTypeItemValue = values[1] }; approvalGroupApprovalTypeItems.Add(approvalGroupApprovalTypeItem); } } } //Add Approval Group Approval Type Items group.ApprovalGroupApprovalTypeItems = approvalGroupApprovalTypeItems; //Database Update try { approvalGroupRepository.Add(group); } catch (SqlException ex) { //Non-Unique Name if (ex.Message == "NonUniqueName") { return(View("NonUniqueNameError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } ViewData["NewSortOrder"] = 0; return(RedirectToAction("ListUnDeleted")); }
public ActionResult Edit(PolicySupplierDealCode policySupplierDealCode, FormCollection formCollection) { PolicyGroup policyGroup = new PolicyGroup(); policyGroup = policyGroupRepository.GetGroup(policySupplierDealCode.PolicyGroupId); //Check Exists if (policyGroup == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check Access Rights RolesRepository rolesRepository = new RolesRepository(); if (!rolesRepository.HasWriteAccessToPolicyGroup(policySupplierDealCode.PolicyGroupId)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Create PolicySupplierDealCodeOSIs from Post values System.Data.Linq.EntitySet <PolicySupplierDealCodeOSI> PolicySupplierDealCodeOSIs = new System.Data.Linq.EntitySet <PolicySupplierDealCodeOSI>(); foreach (string key in formCollection) { if (key.StartsWith("PolicySupplierDealCodeOSI") && !string.IsNullOrEmpty(formCollection[key])) { PolicySupplierDealCodeOSI policySupplierDealCodeOSI = new PolicySupplierDealCodeOSI() { PolicySupplierDealCodeOSIDescription = formCollection[key], PolicySupplierDealCodeOSISequenceNumber = int.Parse(key.Replace("PolicySupplierDealCodeOSI_", "")) }; PolicySupplierDealCodeOSIs.Add(policySupplierDealCodeOSI); } } if (PolicySupplierDealCodeOSIs != null && PolicySupplierDealCodeOSIs.Count > 0) { policySupplierDealCode.PolicySupplierDealCodeOSIs = PolicySupplierDealCodeOSIs; } //Update PolicySupplierDealCode Model From Form try { UpdateModel(policySupplierDealCode, "PolicySupplierDealCode"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { policySupplierDealCodeRepository.Update(policySupplierDealCode); } catch (SqlException ex) { //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/PolicySupplierDealCode.mvc/Edit/" + policySupplierDealCode.PolicySupplierDealCodeId; return(View("VersionError")); } //Generic Error ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } //Return to Form return(RedirectToAction("List", new { id = policySupplierDealCode.PolicyGroupId })); }
public ActionResult Edit(GDSEndWarningConfigurationVM gdsEndWarningConfigurationVM, FormCollection formCollection) { //Get Item GDSEndWarningConfiguration gdsEndWarningConfiguration = new GDSEndWarningConfiguration(); gdsEndWarningConfiguration = gdsEndWarningConfigurationRepository.GetGroup(gdsEndWarningConfigurationVM.GDSEndWarningConfiguration.GDSEndWarningConfigurationId); //Check Exists if (gdsEndWarningConfiguration == null) { ViewData["ActionMethod"] = "EditPost"; return(View("RecordDoesNotExistError")); } //Check Access Rights if (!rolesRepository.HasWriteAccessToGDSEndWarningConfiguration()) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Create Automated Commands from Post values System.Data.Linq.EntitySet <AutomatedCommand> AutomatedCommands = new System.Data.Linq.EntitySet <AutomatedCommand>(); foreach (string key in formCollection) { if (key.StartsWith("AutomatedCommand") && !string.IsNullOrEmpty(formCollection[key])) { AutomatedCommand automatedCommand = new AutomatedCommand() { CommandText = formCollection[key], CommandExecutionSequenceNumber = int.Parse(key.Replace("AutomatedCommand_", "")) }; AutomatedCommands.Add(automatedCommand); } } //Remove Automated Commands if not set, otherwise add new ones in gdsEndWarningConfiguration.AutomatedCommands = (AutomatedCommands != null && AutomatedCommands.Count > 0) ? AutomatedCommands : null; //Update Model From Form + Validate against DB try { UpdateModel <GDSEndWarningConfiguration>(gdsEndWarningConfiguration, "GDSEndWarningConfiguration"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { gdsEndWarningConfigurationRepository.Edit(gdsEndWarningConfiguration); } catch (SqlException ex) { //Non-Unique Name if (ex.Message == "NonUniqueName") { return(View("NonUniqueNameError")); } //Versioning Error if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/GDSEndWarningConfiguration.mvc/Edit/" + gdsEndWarningConfiguration.GDSEndWarningConfigurationId; return(View("VersionError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("List")); }
public ActionResult Create(GDSEndWarningConfigurationVM GDSEndWarningConfigurationVM, FormCollection formCollection) { //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //We need to extract group from groupVM GDSEndWarningConfiguration gdsEndWarningConfiguration = new GDSEndWarningConfiguration(); gdsEndWarningConfiguration = GDSEndWarningConfigurationVM.GDSEndWarningConfiguration; if (gdsEndWarningConfiguration == null) { ViewData["Message"] = "ValidationError : missing item";; return(View("Error")); } //Create Automated Commands from Post values System.Data.Linq.EntitySet <AutomatedCommand> AutomatedCommands = new System.Data.Linq.EntitySet <AutomatedCommand>(); foreach (string key in formCollection) { if (key.StartsWith("AutomatedCommand") && !string.IsNullOrEmpty(formCollection[key])) { AutomatedCommand automatedCommand = new AutomatedCommand() { CommandText = formCollection[key], CommandExecutionSequenceNumber = int.Parse(key.Replace("AutomatedCommand_", "")) }; AutomatedCommands.Add(automatedCommand); } } if (AutomatedCommands != null && AutomatedCommands.Count > 0) { gdsEndWarningConfiguration.AutomatedCommands = AutomatedCommands; } //Update Model From Form + Validate against DB try { UpdateModel <GDSEndWarningConfiguration>(gdsEndWarningConfiguration, "GDSEndWarningConfiguration"); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { gdsEndWarningConfigurationRepository.Add(gdsEndWarningConfiguration); } catch (SqlException ex) { //Non-Unique Name if (ex.Message == "NonUniqueName") { return(View("NonUniqueNameError")); } LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } ViewData["NewSortOrder"] = 0; return(RedirectToAction("List")); }