public void UpdateLocation(TblLocation location) { TblLocation updateLocation = GetLocationbyId(location.LocationId); updateLocation.LocationName = location.LocationName; dbContext.SaveChanges(); }
public void DeleteLocation(int locationId) { TblLocation updateLocation = GetLocationbyId(locationId); updateLocation.isDeleted = true; dbContext.SaveChanges(); }
public async Task <IActionResult> PutTblLocation(int id, TblLocation tblLocation) { if (id != tblLocation.LocationId) { return(BadRequest()); } _context.Entry(tblLocation).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblLocationExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <TblLocation> > PostTblLocation(TblLocation tblLocation) { _context.TblLocations.Add(tblLocation); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblLocation", new { id = tblLocation.LocationId }, tblLocation)); }
public IActionResult PostTblContactOnlyLocation([FromBody] TblLocation nContactOnlyLocation) { if (nContactOnlyLocation != null) { var hasData = this.repository.InsertTblContactOnlyLocationToDataBase(nContactOnlyLocation); if (hasData != null) { return(new JsonResult(hasData, DefaultJsonSettings)); } } return(new StatusCodeResult(500)); }
public IActionResult PutTblLocationToDataBase(int key, [FromBody] TblLocation uLocation) { if (uLocation != null) { var hasData = this.repository.UpdateTblLocationToDataBase(key, uLocation); if (hasData != null) { return(new JsonResult(hasData, DefaultJsonSettings)); } } return(new StatusCodeResult(500)); }
private void cmbLocation_SelectionChangeCommitted(object sender, EventArgs e) { //if selected is valid, render location name in textbox. else, clear it if (Convert.ToInt32(cmbLocation.SelectedValue) != 0) { TblLocation selectedLocation = new TblLocation(); selectedLocation = _locationService.GetLocationbyId(Convert.ToInt32(cmbLocation.SelectedValue)); txtLocationName.Text = selectedLocation.LocationName.Trim(); } else { txtLocationName.Clear(); } }
private void btnAdd_Click(object sender, EventArgs e) { try { TblLocation tblLocation = new TblLocation(); tblLocation.LocationName = txtLocationName.Text.Trim(); _locationService.SaveLocation(tblLocation); MessageBox.Show("Location Successfully Saved"); } catch (Exception a) { } }
private void btnSave_Click(object sender, EventArgs e) { try { TblLocation tblLocation = new TblLocation(); tblLocation.LocationName = txtLocationName.Text.Trim(); tblLocation.LocationId = Convert.ToInt32(cmbLocation.SelectedValue); _locationService.UpdateLocation(tblLocation); MessageBox.Show("Location Successfuly Updated"); } catch (Exception a) { throw a; } }
public TblLocation InsertTblLocationToDataBase(TblLocation nLocation) { try { if (nLocation != null) { nLocation.CreateDate = this.DateOfServer; nLocation.Creator = nLocation.Creator ?? "someone"; this.Context.TblLocation.Add(nLocation); return(this.Context.SaveChanges() > 0 ? this.GetTblLocationWithKey(nLocation.LocationId) : null); } } catch (Exception ex) { Debug.WriteLine("Has error " + ex.ToString()); } return(null); }
public TblLocation UpdateTblLocationToDataBase(int LocationID, TblLocation uLocation) { try { var dbLocation = this.Context.TblLocation.Find(LocationID); if (dbLocation != null) { uLocation.CreateDate = dbLocation.CreateDate; uLocation.ModifyDate = this.DateOfServer; uLocation.Modifyer = uLocation.Modifyer ?? "someone"; this.Context.Entry(dbLocation).CurrentValues.SetValues(uLocation); return(this.Context.SaveChanges() > 0 ? this.GetTblLocationWithKey(LocationID) : null); } } catch (Exception ex) { Debug.WriteLine("Has error " + ex.ToString()); } return(null); }
public TblContact InsertTblContactOnlyLocationToDataBase(TblLocation nContactOnlyLocation) { try { if (nContactOnlyLocation != null) { if (this.GetTblLocations.Where(x => x.LocationName.Trim().ToLower() == nContactOnlyLocation.LocationName.Trim().ToLower()).Any()) { return(null); } string LocationCode = "OZ" + ((this.GetTblLocations.Where(x => x.LocationCode.StartsWith("OZ"))?.Count() ?? 1) + 1).ToString("0"); var nContact = new TblContact() { ContactName = "", ContactPhone = "", CreateDate = this.DateOfServer, Creator = nContactOnlyLocation.Creator ?? "someone", LocationNavigation = new TblLocation() { CreateDate = this.DateOfServer, Creator = nContactOnlyLocation.Creator ?? "someone", LocationAddress = nContactOnlyLocation.LocationAddress, LocationCode = LocationCode, LocationName = nContactOnlyLocation.LocationName } }; this.Context.TblContact.Add(nContact); return(this.Context.SaveChanges() > 0 ? this.GetTblContactWithKey(nContact.ContactId) : null); } } catch (Exception ex) { Debug.WriteLine("Has error " + ex.ToString()); } return(null); }
public void ClearForm() { btnAdd.Show(); btnSave.Hide(); //load combobox lstLocation = _locationService.GetLocations(); TblLocation item = new TblLocation(); item.LocationName = "---Select Location--"; item.LocationId = 0; lstLocation.Add(item); cmbLocation.DataSource = lstLocation; cmbLocation.ValueMember = "LocationId"; cmbLocation.DisplayMember = "LocationName"; cmbLocation.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown; cmbLocation.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cmbLocation.AutoCompleteSource = AutoCompleteSource.ListItems; cmbLocation.SelectedValue = 0; //till here }
public int InsertTblLocation(TblLocation lc) { return(ld.InsertLocation(lc)); }
public IActionResult Put(string id, [FromBody] TblLocation uLocation) { return(new JsonResult(this.repository.UpdateAsync(uLocation, id).Result, this.DefaultJsonSettings)); }
public IActionResult Post([FromBody] TblLocation nLocation) { return(new JsonResult(this.repository.AddAsync(nLocation).Result, this.DefaultJsonSettings)); }
public void SaveLocation(TblLocation location) { dbContext.TblLocation.Add(location); dbContext.SaveChanges(); }
public TblLocation GetLocationbyId(int locationId) { TblLocation location = dbContext.TblLocation.FirstOrDefault(p => p.isDeleted == false && p.LocationId == locationId); return(location); }
public int UpdateTblLocation(TblLocation lc) { return(ld.Updatelocation(lc)); }