public ActionResult Edit(int id) { LookupCode model = new LookupCode(RepoLookup.FindByPK(id)); ViewBag.name = model.Nama; return(View("Form", model)); }
public async Task <LookupCode> Update(LookupCode lookupCode) { _db.LookupCode.Update(lookupCode); await _db.SaveChangesAsync(); return(lookupCode); }
protected void InsertButtonClick(object sender, CommandEventArgs e) { LookupCode biz = new LookupCode(); //biz.NewRow(); // erroneous call //dr["LookupCodeId"]= lkpCodeId.Value; if (Request.Form["lkpName"] != null) { biz["LkpFieldName"] = Request.Form["lkpName"]; } else { biz["LkpFieldName"] = lkpFieldName.Value; } biz["LkpCode"] = lkpValue.Value; biz["LkpDescription"] = lkpDescription.Value; biz["LkpOrder"] = PageUtil.ObjToInt(lkpOrder.Value); biz["LkpSuppress"] = lkpSuppress.Checked; biz["UpdatedBy"] = User.Identity.Name; biz["UpdatedTime"] = DateTime.Now; biz["EnteredBy"] = User.Identity.Name; biz["EnteredTime"] = DateTime.Now; biz.Save(); if (fieldName.SelectedIndex == 0) { Server.Transfer("AdminLookupCodes.aspx"); } else { this.Page_Load(sender, e); } }
/// <summary> /// Builds a grid populated with the current LkpFieldName /// </summary> /// <param name="lkpField"></param> private bool BuildLookupCodeList(string lkpField) { InitParamaters(); LookupCodeDa da = new LookupCodeDa(); var lkpCodes = LookupCode.GetByFieldsAsDataView <LookupCode>(new Dictionary <string, object> { { LookupCode.LkpFieldName, lkpField } }); // sort by, then alpha numeric DataColumn sortCol = new DataColumn("_Sort", typeof(int), "ISNULL(LkpOrder," + int.MaxValue + ")"); DataColumn sortCol2 = new DataColumn("_Sort2", typeof(int), "ISNULL(LookupCodeId," + int.MaxValue + ") - ISNULL(LookupCodeId," + int.MaxValue + " - 1)"); lkpCodes.Table.Columns.Add(sortCol); lkpCodes.Table.Columns.Add(sortCol2); lkpCodes.Sort = "_Sort ASC, _Sort2 ASC, " + LookupCode.LkpCode + " ASC"; // build main lookup code list LookupCodeGrid.DataSource = lkpCodes; LookupCodeGrid.DataBind(); DataSet ds = da.GetLookupCodeStats(lkpField, _diseaseName); DataTable lookupByMetadata = ds.Tables[0]; int lookupCodeCount = (int)ds.Tables[1].Rows[0][0]; int lookupDiseaseCount = (int)ds.Tables[2].Rows[0][0]; BuildLkpStats(lookupByMetadata, lookupDiseaseCount, lookupCodeCount); return(lookupCodeCount > 0); }
public static FlightId GetFlightID(bool arr, string airline, string fltnum, double offset = 0.0) { LookupCode apCode = new LookupCode(); apCode.codeContextField = CodeContext.IATA; apCode.valueField = Parameters.APT_CODE; LookupCode[] ap = { apCode }; LookupCode alCode = new LookupCode(); alCode.codeContextField = CodeContext.IATA; alCode.valueField = airline;; LookupCode[] al = { alCode }; FlightId flightID = new FlightId(); flightID.flightKindField = arr ? FlightKind.Arrival : FlightKind.Departure; flightID.airportCodeField = ap; flightID.airlineDesignatorField = al; flightID.scheduledDateField = DateTime.Now.AddDays(offset); flightID.flightNumberField = fltnum; return(flightID); }
public void RollbackDataTest() { var lookupCode = new LookupCode { Description = "desc" }; using (var dbContext = new SheriffDbContext(EnvironmentBuilder.SetupDbOptions())) { using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope2 = new TransactionScope()) { dbContext.LookupCode.Add(lookupCode); dbContext.SaveChanges(); scope2.Complete(); } //No scope complete, should rollback. } } using (var dbContext = new SheriffDbContext(EnvironmentBuilder.SetupDbOptions())) { var workSectionCode2 = dbContext.LookupCode.Find(lookupCode.Id); Assert.Null(workSectionCode2); } }
public void PersistingDataTest() { var lookupCode = new LookupCode { Description = "desc" }; using (var dbContext = new SheriffDbContext(EnvironmentBuilder.SetupDbOptions())) { using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope2 = new TransactionScope()) { dbContext.LookupCode.Add(lookupCode); dbContext.SaveChanges(); scope2.Complete(); scope.Complete(); } } } using (var dbContext = new SheriffDbContext(EnvironmentBuilder.SetupDbOptions())) { var workSectionCode2 = dbContext.LookupCode.Find(lookupCode.Id); Assert.NotNull(workSectionCode2); dbContext.Remove(workSectionCode2); dbContext.SaveChanges(); } }
public async Task <LookupCode> Add(LookupCode courtRoleCode) { await _db.LookupCode.AddAsync(courtRoleCode); await _db.SaveChangesAsync(); return(courtRoleCode); }
public void delete(LookupCode dbitem) { context.LookupCode.Remove(dbitem); var auditrail = new Auditrail { Actionnya = "Delete", EventDate = DateTime.Now, Modulenya = "Lookup Code", QueryDetail = "Delete " + dbitem.Deskripsi, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); context.SaveChanges(); }
protected void DeleteButtonClick(object sender, CommandEventArgs e) { int lkpId = int.Parse(lkpCodeId.Value); LookupCode lk = new LookupCode(); lk.Delete(lkpId); this.ResetFields(); this.Page_Load(sender, e); }
/// <summary> /// Adds a new LkpCode value for a LkpFieldName /// </summary> /// <param name="lkpField"></param> /// <param name="lkpCode"></param> /// <returns></returns> private int AddLookupCodeValue(string lkpField, string lkpCode, string lkpOrder) { LookupCode biz = new LookupCode(); biz[LookupCode.LkpFieldName] = lkpField; biz[LookupCode.LkpCode] = lkpCode; biz[LookupCode.LkpSuppress] = 0; biz[LookupCode.LkpOrder] = lkpOrder; biz.Save(); return(int.Parse(biz[biz.PrimaryKeyName].ToString())); }
public ActionResult Edit(LookupCode model) { if (ModelState.IsValid) { Context.LookupCode dbitem = RepoLookup.FindByPK(model.Id); model.setDb(dbitem); RepoLookup.save(dbitem); return(RedirectToAction("Index")); } return(View("Form", model)); }
public ActionResult Add(LookupCode model) { if (ModelState.IsValid) { Context.LookupCode dbitem = new Context.LookupCode(); model.setDb(dbitem); RepoLookup.save(dbitem); return(RedirectToAction("Index")); } return(View("Form", model)); }
/// <summary> /// Handles deleting event for record in Lookup Code Grid /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int keyIndex = e.RowIndex; string priKey = LookupCodeGrid.DataKeys[keyIndex][LookupCode.LookupCodeId].ToString(); if (!string.IsNullOrEmpty(priKey)) { int lkpCodeId = int.Parse(priKey); LookupCode biz = new LookupCode(); biz.Delete(lkpCodeId); BindLookupCodesGrid(); } }
private void flightSaktaubyValues(string propertyNameFieldtxt, string valueFieldtxt) { var todoItem = (flight)BindingContext; ServiceReference2.AMSIntegrationServiceClient proxy = new ServiceReference2.AMSIntegrationServiceClient( ServiceReference2.AMSIntegrationServiceClient.EndpointConfiguration.BasicHttpBinding_IAMSIntegrationService, "http://57.31.17.135/SITAAMSIntegrationService/v1/SITAAMSIntegrationService/"); FlightId idFl = new FlightId(); idFl.flightNumberField = todoItem.FlightNumber; idFl.scheduledDateField = todoItem.FlightSTA; idFl.flightKindField = FlightKind.Arrival; LookupCode asq = new LookupCode(); asq.codeContextField = CodeContext.IATA; asq.valueField = todoItem.CIata; ObservableCollection <LookupCode> airdEs = new ObservableCollection <LookupCode>(); airdEs.Add(asq); idFl.airlineDesignatorField = airdEs; LookupCode qsa = new LookupCode(); qsa.codeContextField = CodeContext.IATA; qsa.valueField = "TSE"; ObservableCollection <LookupCode> airportLo = new ObservableCollection <LookupCode>(); airportLo.Add(qsa); idFl.airportCodeField = airportLo; PropertyValue val1 = new PropertyValue(); val1.valueField = valueFieldtxt; val1.propertyNameField = propertyNameFieldtxt; ObservableCollection <PropertyValue> values = new ObservableCollection <PropertyValue>(); values.Add(val1); proxy.UpdateFlightCompleted += Proxy_UpdateFlightCompleted; proxy.UpdateFlightAsync(idFl, values); }
public async Task <LookupCode> Update(LookupCode lookupCode) { lookupCode.SortOrderForLocation.ThrowBusinessExceptionIfNull("SortOrderForLocation cannot be null"); var savedLookup = await Db.LookupCode.Include(lc => lc.SortOrder.Where(so => so.LookupCodeId == lookupCode.Id && so.LocationId == lookupCode.SortOrderForLocation.LocationId)) .FirstOrDefaultAsync(lc => lc.Id == lookupCode.Id); savedLookup.ThrowBusinessExceptionIfNull($"Couldn't find lookup code with id: {lookupCode.Id}"); if ((savedLookup.Code != lookupCode.Code || savedLookup.LocationId != lookupCode.LocationId) && Db.LookupCode.AsNoTracking() .Any(lc => lc.Code == lookupCode.Code && lc.LocationId == lookupCode.LocationId)) { throw new BusinessLayerException($"Attempted to create a duplicate entry."); } savedLookup.Location = await Db.Location.FindAsync(lookupCode.LocationId); Db.Entry(savedLookup).CurrentValues.SetValues(lookupCode); Db.Entry(savedLookup).Property(x => x.ExpiryDate).IsModified = false; var sortOrder = savedLookup.SortOrder.FirstOrDefault(); if (sortOrder != null) { sortOrder.SortOrder = lookupCode.SortOrderForLocation.SortOrder; await Db.SaveChangesAsync(); } else { var lookupSortOrder = new LookupSortOrder { LookupCodeId = savedLookup.Id, LocationId = lookupCode.SortOrderForLocation.LocationId, SortOrder = lookupCode.SortOrderForLocation.SortOrder }; await Db.LookupSortOrder.AddAsync(lookupSortOrder); await Db.SaveChangesAsync(); lookupCode.SortOrderForLocation = lookupSortOrder; } return(lookupCode); }
public string BindingKonsolidasi() { GridRequestParameters param = GridRequestParameters.Current; List <Context.LookupCode> items = RepoLookup.FindAll(param.Skip, 200, (param.Sortings != null ? param.Sortings.ToList() : null), param.Filters).Where(d => d.LookupCodeCategories.Category == "tms_customer_konsolidasi").ToList(); List <LookupCode> ListModel = new List <LookupCode>(); foreach (Context.LookupCode item in items) { LookupCode lc = new LookupCode(item); ListModel.Add(lc); } int total = RepoLookup.Count(param.Filters); return(new JavaScriptSerializer().Serialize(new { total = total, data = ListModel })); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void OnLookupGridRowUpdaing(object sender, GridViewUpdateEventArgs e) { GridViewRow row = LookupCodeGrid.Rows[e.RowIndex]; List <ICaisisInputControl> cicList = PageUtil.GetCaisisInputControlsInContainer(row); LookupCode biz = new LookupCode(); object priKey = LookupCodeGrid.DataKeys[e.RowIndex].Value; // Insert/No Key Present if (!priKey.ToString().Equals(string.Empty)) { int lkpCodeId = (int)priKey; biz.Get(lkpCodeId); } if (Request.Form["lkpName"] != null) { biz[LookupCode.LkpFieldName] = Request.Form["lkpName"]; } else if (!string.IsNullOrEmpty(lkpFieldName.Value)) { biz[LookupCode.LkpFieldName] = lkpFieldName.Value; } else if (!string.IsNullOrEmpty(fieldName.SelectedValue)) { biz[LookupCode.LkpFieldName] = fieldName.SelectedValue; } else { return; } // Manually Extract values to fix issues with LkpSupress foreach (ICaisisInputControl cic in cicList) { if (cic is CaisisCheckBox) { CaisisCheckBox cb = cic as CaisisCheckBox; biz[cic.Field] = cb.Checked; } else { biz[cic.Field] = cic.Value; } } biz.Save(); }
protected void AddLkpCode(object sender, EventArgs e) { bool isValid = ValidateLkpFieldName(LkpFieldName.Text); if (isValid) { LookupCode lkpCode = new LookupCode(); lkpCode[LookupCode.LkpFieldName] = LkpFieldName.Text; lkpCode[LookupCode.LkpSuppress] = 0; lkpCode[LookupCode.LkpCode] = "[enter]"; lkpCode.Save(); string lkpFieldName = PageUtil.EscapeSingleQuotes(LkpFieldName.Text); Page.ClientScript.RegisterStartupScript(this.GetType(), "Reload", "closeAndReloadLkpCode('" + lkpFieldName + "')", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "WarnDuplicateField", "alert('The " + LookupCode.LkpFieldName + " already exists, please enter a new value.')", true); } }
protected void UpdateButtonClick(object sender, CommandEventArgs e) { LookupCode biz = new LookupCode(); //biz.NewRow(); // erroneous call biz["LookupCodeId"] = lkpCodeId.Value; biz["LkpFieldName"] = lkpFieldName.Value; biz["LkpCode"] = lkpValue.Value; biz["LkpDescription"] = lkpDescription.Value; biz["LkpOrder"] = PageUtil.ObjToInt(lkpOrder.Value); biz["LkpSuppress"] = lkpSuppress.Checked; biz["UpdatedBy"] = User.Identity.Name; biz["UpdatedTime"] = DateTime.Now; biz["EnteredBy"] = User.Identity.Name; // these are required biz["EnteredTime"] = DateTime.Now; // biz.Save(); this.Page_Load(sender, e); }
public void save(LookupCode dbitem) { if (dbitem.Id == 0) //create { context.LookupCode.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Lookup Code", QueryDetail = "Add " + dbitem.Deskripsi, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.LookupCode.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Lookup Code", QueryDetail = "Edit " + dbitem.Deskripsi, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
/// <summary> /// Update lookup code record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void HandleLookupUpdate(object sender, GridViewUpdateEventArgs e) { GridView lkpCodeGrid = sender as GridView; GridViewRow updateRow = lkpCodeGrid.Rows[e.RowIndex]; // Fill dictionary from row controls CaisisGridView.ExtractCaisisInputValuesFromContainer(updateRow, e.NewValues); // Create a new biz for updating/inserting LookupCode biz = new LookupCode(); // Determine if a lookupcodeid exists object lkpCodeIdKey = lkpCodeGrid.DataKeys[e.RowIndex][LookupCode.LookupCodeId]; if (lkpCodeIdKey != null && !string.IsNullOrEmpty(lkpCodeIdKey.ToString())) { int lkpCodeId = int.Parse(lkpCodeIdKey.ToString()); biz.Get(lkpCodeId); } else { return; } // Set the lkpcode extracted from textbox foreach (string col in e.NewValues.Keys) { //if (biz.HasColumn(col)) if (biz.HasField(col)) { biz[col] = e.NewValues[col]; } } biz.Save(); // Notify the built-in update event to cancel/i.e., not bubble e.Cancel = true; }
public async Task SheriffOverrideConflictRemove() { var sheriffObject = await CreateSheriffUsingDbContext(); var newLocation = new Location { Name = "New PLace", AgencyId = "zfddf2342" }; await Db.Location.AddAsync(newLocation); await Db.SaveChangesAsync(); var startDate = DateTimeOffset.UtcNow.Date.AddHours(1); var endDate = startDate.AddHours(8); var shift = new Shift { Id = 9000665, StartDate = startDate, EndDate = endDate, LocationId = newLocation.Id, Timezone = "America/Vancouver", SheriffId = sheriffObject.Id }; Db.Shift.Add(shift); var duty = new Duty { LocationId = newLocation.Id, }; Db.Duty.Add(duty); await Db.SaveChangesAsync(); var dutySlot = new DutySlot { SheriffId = sheriffObject.Id, LocationId = newLocation.Id, StartDate = startDate, EndDate = endDate, DutyId = duty.Id }; Db.DutySlot.Add(dutySlot); var lookupCode = new LookupCode { Code = "zz4", Description = "gg", LocationId = newLocation.Id }; await Db.LookupCode.AddAsync(lookupCode); await Db.SaveChangesAsync(); var entity = new SheriffLeaveDto { LeaveTypeId = lookupCode.Id, SheriffId = sheriffObject.Id, StartDate = startDate, EndDate = endDate }; Assert.True(Db.Shift.Any(s => s.ExpiryDate == null && s.Id == shift.Id)); Assert.True(Db.DutySlot.Any(ds => ds.ExpiryDate == null && ds.Id == dutySlot.Id)); await _controller.AddSheriffLeave(entity, true); Assert.False(Db.Shift.Any(s => s.ExpiryDate == null && s.Id == shift.Id)); Assert.False(Db.DutySlot.Any(ds => ds.ExpiryDate == null && ds.Id == dutySlot.Id)); }
public async Task AddUpdateRemoveSheriffTraining() { var sheriffObject = await CreateSheriffUsingDbContext(); var newLocation = new Location { Name = "New PLace", AgencyId = "zfddf2342" }; await Db.Location.AddAsync(newLocation); await Db.SaveChangesAsync(); var lookupCode = new LookupCode { Code = "zz4", Description = "gg", LocationId = newLocation.Id }; await Db.LookupCode.AddAsync(lookupCode); var lookupCode2 = new LookupCode { Code = "zz", Description = "gg", LocationId = newLocation.Id }; await Db.LookupCode.AddAsync(lookupCode2); await Db.SaveChangesAsync(); var entity = new SheriffTrainingDto { TrainingTypeId = lookupCode.Id, SheriffId = sheriffObject.Id, StartDate = DateTime.UtcNow, EndDate = DateTime.UtcNow.AddHours(3) }; //Add var controllerResult = await _controller.AddSheriffTraining(entity); var response = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult); Detach(); var updateSheriffTraining = entity.Adapt <SheriffTrainingDto>(); updateSheriffTraining.StartDate = DateTime.UtcNow.AddDays(5); updateSheriffTraining.EndDate = DateTime.UtcNow.AddDays(5); updateSheriffTraining.TrainingTypeId = lookupCode2.Id; updateSheriffTraining.TrainingType = lookupCode2.Adapt <LookupCodeDto>(); updateSheriffTraining.Id = response.Id; //Update var controllerResult3 = await _controller.UpdateSheriffTraining(updateSheriffTraining); var response3 = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult3); Assert.Equal(response3.StartDate, updateSheriffTraining.StartDate); Assert.Equal(response3.EndDate, updateSheriffTraining.EndDate); Assert.Equal(response3.SheriffId, updateSheriffTraining.SheriffId); Assert.Equal(response3.TrainingTypeId, updateSheriffTraining.TrainingTypeId); //Remove var controllerResult4 = await _controller.RemoveSheriffTraining(updateSheriffTraining.Id, "expired"); HttpResponseTest.CheckForNoContentResponse(controllerResult4); var controllerResult5 = await _controller.GetSheriffForTeam(sheriffObject.Id); var response5 = HttpResponseTest.CheckForValid200HttpResponseAndReturnValue(controllerResult5); Assert.Empty(response5.Training); }
/// <summary> /// Deletes the specified lookup code. /// </summary> /// <param name="lkpCodeId"></param> private void Delete(int lkpCodeId) { LookupCode lkpCode = new LookupCode(); lkpCode.Delete(lkpCodeId); }
public ActionResult Add() { LookupCode model = new LookupCode(); return(View("Form", model)); }
public string GetKategori(LookupCode model) { model.listKategori = RepoKategori.FindAll().ToList(); return(new JavaScriptSerializer().Serialize(model.listKategori)); }
/// <summary> /// Save's all "dirty" rows as well as update/delete association to current disease /// </summary> private void Save() { // validation List <string> existingCodes = new List <string>(); List <string> duplicateCodes = new List <string>(); // check each row, need to check for associate with disease foreach (GridViewRow row in LookupCodeGrid.Rows) { int? lkpCodeId = null; object rowLkpCodeId = LookupCodeGrid.DataKeys[row.RowIndex][LookupCode.LookupCodeId]; if (!string.IsNullOrEmpty(rowLkpCodeId.ToString())) { lkpCodeId = (int)rowLkpCodeId; } bool isDirtyRow = LookupCodeGrid.DirtyGridRows.Contains(row); ICaisisInputControl lkpCodeField = row.FindControl("LkpCode") as ICaisisInputControl; // validate empty values, duplicates, etc... if (!string.IsNullOrEmpty(lkpCodeField.Value)) { if (!lkpCodeId.HasValue && existingCodes.Contains(lkpCodeField.Value, StringComparer.OrdinalIgnoreCase)) { // mark as duplicate and prevent insert duplicateCodes.Add(lkpCodeField.Value); isDirtyRow = false; lkpCodeId = null; } // track running list else { existingCodes.Add(lkpCodeField.Value); } } else { isDirtyRow = false; lkpCodeId = null; } // if dirty, update/insert if (isDirtyRow) { // update/insert LookupCode lkpCode = new LookupCode(); if (lkpCodeId.HasValue) { lkpCode.Get(lkpCodeId.Value); } else { lkpCode[LookupCode.LkpFieldName] = CurrentLkpFieldName.Value; } CICHelper.SetBOValues(row.Controls, lkpCode, -1); lkpCode.Save(); // update pri key lkpCodeId = (int)lkpCode[LookupCode.LookupCodeId]; } // continue if valid if (lkpCodeId.HasValue) { // APPLY TO DISEASE CheckBox diseaseAttribute = row.FindControl("DiseaseAttribute") as CheckBox; HiddenField diseaseAttributeId = row.FindControl("DiseaseAttributeId") as HiddenField; if (diseaseAttribute.Checked) { // only insert if key not set, as already assigned if (string.IsNullOrEmpty(diseaseAttributeId.Value)) { LookupCodeAttribute lkpCodeAttribute = new LookupCodeAttribute(); // set required lkpCodeAttribute[LookupCodeAttribute.LookupCodeId] = lkpCodeId; lkpCodeAttribute[LookupCodeAttribute.AttributeId] = _lkpDiseaseAttributeId; lkpCodeAttribute[LookupCodeAttribute.AttributeValue] = _diseaseName; lkpCodeAttribute[LookupCodeAttribute.AttributeSuppress] = 0; lkpCodeAttribute.Save(); // update hidden field diseaseAttributeId.Value = lkpCodeAttribute[LookupCodeAttribute.LookupCodeAttributeId].ToString(); } } // if unchecking and pri key set, delete else { if (!string.IsNullOrEmpty(diseaseAttributeId.Value)) { int lkpCodeAttributeId = int.Parse(diseaseAttributeId.Value); LookupCodeAttribute lkpCodeAttribute = new LookupCodeAttribute(); lkpCodeAttribute.Delete(lkpCodeAttributeId); // udpate hidden field diseaseAttributeId.Value = string.Empty; } } // APPLY FILTERS: only when NOT in disease mode if (!QueryDiseaseId.HasValue) { // APPLY TO ATTRIBUTE CheckBox applyToAttribute = row.FindControl("ApplyToAttribute") as CheckBox; HiddenField applyToAttributeId = row.FindControl("ApplyToAttributeId") as HiddenField; if (applyToAttribute.Checked) { // no udpates, just inserts if (string.IsNullOrEmpty(applyToAttributeId.Value)) { LookupCodeAttribute lkpCodeAttribute = new LookupCodeAttribute(); lkpCodeAttribute[LookupCodeAttribute.LookupCodeId] = lkpCodeId.Value; lkpCodeAttribute[LookupCodeAttribute.AttributeId] = int.Parse(FilterByAttributeNames.Value); lkpCodeAttribute[LookupCodeAttribute.AttributeValue] = FilterByAttributeValues.Value; lkpCodeAttribute[LookupCodeAttribute.AttributeSuppress] = 0; lkpCodeAttribute.Save(); applyToAttributeId.Value = lkpCodeAttribute[lkpCodeAttribute.PrimaryKeyName].ToString(); } } // if unchecking, delete only if key exists else if (!string.IsNullOrEmpty(applyToAttributeId.Value)) { LookupCodeAttribute lkpCodeAttribute = new LookupCodeAttribute(); lkpCodeAttribute.Delete(int.Parse(applyToAttributeId.Value)); applyToAttributeId.Value = string.Empty; } // APPLY TO PARENT CheckBox applyToParent = row.FindControl("ApplyToParent") as CheckBox; HiddenField applyToParentId = row.FindControl("ApplyToParentId") as HiddenField; if (applyToParent.Checked) { // no udpates, just inserts if (string.IsNullOrEmpty(applyToParentId.Value)) { LookupParentChildCode parentChildCode = new LookupParentChildCode(); parentChildCode[LookupParentChildCode.ParentCodeId] = int.Parse(FilterByParentLkpCodes.Value); parentChildCode[LookupParentChildCode.ChildCodeId] = lkpCodeId.Value; parentChildCode.Save(); applyToParentId.Value = parentChildCode[parentChildCode.PrimaryKeyName].ToString(); } } // if unchecking, delete only if key exists else if (!string.IsNullOrEmpty(applyToParentId.Value)) { LookupParentChildCode parentChildCode = new LookupParentChildCode(); parentChildCode.Delete(int.Parse(applyToParentId.Value)); applyToParentId.Value = string.Empty; } } } } // Save new CSV values var bulkLkpCodesRows = (from rowCodes in BulkLkpCodes.Text.Split(System.Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries) let lkpCode = from code in rowCodes.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries) select code.Trim() select lkpCode).SelectMany(s => s); foreach (string code in bulkLkpCodesRows) { LookupCode lkpCode = new LookupCode(); // set required fields lkpCode[LookupCode.LkpFieldName] = CurrentLkpFieldName.Value; lkpCode[LookupCode.LkpSuppress] = 0; // set code lkpCode[LookupCode.LkpCode] = code; // insert lkpCode.Save(); } // reset bulk codes BulkLkpCodes.Text = string.Empty; // refresh cache for item CacheManager.ResetLookupCodeCache(); // register warning for missing codes if (duplicateCodes.Count() > 0) { // create safe js array string[] duplicateCodesArray = duplicateCodes.Select(c => PageUtil.EscapeSingleQuotes(c)).ToArray(); string clientArray = "['" + string.Join("', '", duplicateCodesArray) + "']"; Page.ClientScript.RegisterStartupScript(this.GetType(), "duplicateCodesMessage", "warnDuplicateCodes(" + clientArray + ");", true); } }