protected void Button1_Click(object sender, EventArgs e) { AGRODataContext db = new AGRODataContext(Server.MapPath("\\")); Inventory a = new Inventory() { IName = TextBox5.Text, Count = Convert.ToInt32(TextBox2.Text), Price = Convert.ToDouble(TextBox3.Text), MPrice = Convert.ToDouble(TextBox4.Text) }; db.Inventory.InsertOnSubmit(a); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } }
protected void WorkersTable_RowDeleting(object sender, GridViewDeleteEventArgs e) { Debug.WriteLine("WorkersTable_RowDeleting"); if (e.Keys.Contains("IdW")) { var selectedWorkerId = (int)e.Keys["IdW"]; Debug.WriteLine($"selectedWorkerId = {selectedWorkerId}"); using (var db = new AGRODataContext(Server.MapPath("\\"))) { var deletingEntity = db.Workers.FirstOrDefault(w => w.IdW == selectedWorkerId); if (deletingEntity != null) { db.Workers.DeleteOnSubmit(deletingEntity); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } } } }
protected void InventoryTable_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e) { Debug.WriteLine("InventoryTable_RowDeleting"); if (e.Keys.Contains("IdI")) { var selectedInventoryId = (int)e.Keys["IdI"]; Debug.WriteLine($"selectedInventoryId = {selectedInventoryId}"); using (var db = new AGRODataContext(Server.MapPath("\\"))) { var deletingEntity = db.Inventory.FirstOrDefault(i => i.IdI == selectedInventoryId); if (deletingEntity != null) { db.Inventory.DeleteOnSubmit(deletingEntity); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } } } }
protected void WorkersTable_RowUpdating(object sender, GridViewUpdateEventArgs e) { Debug.WriteLine("WorkersTable_RowUpdating"); var rowIdx = e.RowIndex; if (e.Keys.Contains("IdW")) { var updatingWorkerId = (int)e.Keys["IdW"]; Debug.WriteLine($"updatingWorkerId = {updatingWorkerId}"); using (var db = new AGRODataContext(Server.MapPath("\\"))) { var updatingEntity = db.Workers.FirstOrDefault(w => w.IdW == updatingWorkerId); if (updatingEntity != null) { var selectedRow = WorkersTable.Rows[rowIdx]; var fNameCtl = selectedRow.Cells[2].Controls[0] as TextBox; var sNameCtl = selectedRow.Cells[3].Controls[0] as TextBox; var tNameCtl = selectedRow.Cells[4].Controls[0] as TextBox; var wageCtl = selectedRow.Cells[5].Controls[0] as TextBox; var invCtl = selectedRow.Cells[6].FindControl("InvEditor") as DropDownList; var placeCtl = selectedRow.Cells[7].FindControl("PlaceEditor") as DropDownList; var loginCtl = selectedRow.Cells[8].Controls[0] as TextBox; var pwdCtl = selectedRow.Cells[9].Controls[0] as TextBox; updatingEntity.FName = fNameCtl?.Text; updatingEntity.TName = tNameCtl?.Text; updatingEntity.SName = sNameCtl?.Text; updatingEntity.Wage = int.TryParse(wageCtl?.Text, out int _wage) ? _wage : (int?)null; updatingEntity.Inv = int.TryParse(invCtl?.SelectedValue, out int _inv) ? _inv : (int?)null; updatingEntity.Place = int.TryParse(placeCtl?.SelectedValue, out int _place) ? _place : (int?)null; updatingEntity.Login = loginCtl?.Text; updatingEntity.Password = pwdCtl?.Text; try { db.SubmitChanges(); WorkersTable.EditIndex = -1; BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } } } }
protected void InventoryTable_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e) { Debug.WriteLine("InventoryTable_RowUpdating"); var rowIdx = e.RowIndex; if (e.Keys.Contains("IdI")) { var updatingInventoryId = (int)e.Keys["IdI"]; Debug.WriteLine($"updatingInventoryId = {updatingInventoryId}"); using (var db = new AGRODataContext(Server.MapPath("\\"))) { var updatingEntity = db.Inventory.FirstOrDefault(i => i.IdI == updatingInventoryId); if (updatingEntity != null) { var selectedRow = InventoryTable.Rows[rowIdx]; var iNameCtl = selectedRow.Cells[2].Controls[0] as TextBox; var countCtl = selectedRow.Cells[3].Controls[0] as TextBox; var priceCtl = selectedRow.Cells[4].Controls[0] as TextBox; var mPriceCtl = selectedRow.Cells[5].Controls[0] as TextBox; updatingEntity.IName = iNameCtl?.Text; updatingEntity.Count = int.TryParse(countCtl?.Text, out int _count) ? _count : (int?)null; updatingEntity.Price = double.TryParse(priceCtl?.Text, out double _price) ? _price : (double?)null; updatingEntity.MPrice = double.TryParse(mPriceCtl?.Text, out double _mPrice) ? _mPrice : (double?)null; try { db.SubmitChanges(); InventoryTable.EditIndex = -1; BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } } } }
protected void PlacesTable_RowUpdating(object sender, GridViewUpdateEventArgs e) { Debug.WriteLine("PlacesTable_RowUpdating"); var rowIdx = e.RowIndex; if (e.Keys.Contains("IdP")) { var updatingPlaceId = (int)e.Keys["IdP"]; Debug.WriteLine($"updatingPlaceId = {updatingPlaceId}"); using (var db = new AGRODataContext(Server.MapPath("\\"))) { var updatingEntity = db.Places.FirstOrDefault(p => p.IdP == updatingPlaceId); if (updatingEntity != null) { var selectedRow = PlacesTable.Rows[rowIdx]; var pNameCtl = selectedRow.Cells[2].Controls[0] as TextBox; var mPriceCtl = selectedRow.Cells[3].Controls[0] as TextBox; var cultureCtl = selectedRow.Cells[4].FindControl("CultureEditor") as DropDownList; var animalsCtl = selectedRow.Cells[5].FindControl("AnimalsEditor") as DropDownList; updatingEntity.Pname = pNameCtl?.Text; updatingEntity.MPrice = int.TryParse(mPriceCtl?.Text, out int _mPrice) ? _mPrice : (int?)null; updatingEntity.PCulture = int.TryParse(cultureCtl?.SelectedValue, out int _pCulture) ? _pCulture : (int?)null; updatingEntity.PAnimals = int.TryParse(animalsCtl?.SelectedValue, out int _pAnimals) ? _pAnimals : (int?)null; try { db.SubmitChanges(); PlacesTable.EditIndex = -1; BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } } } }
protected void Button1_Click(object sender, EventArgs e) { using (var db = new AGRODataContext(Server.MapPath("\\"))) { var wage = double.TryParse(SalaryTbx.Text, out double _wage) ? _wage : (double?)null; var inv = int.TryParse(InventaryDropDown.SelectedValue, out int _inv) ? _inv : (int?)null; var place = int.TryParse(DepartmentDropDown.SelectedValue, out int _place) ? _place : (int?)null; var a = new Workers { FName = LastNameTbx.Text, SName = FirstNameTbx.Text, TName = SurnameTbx.Text, Wage = wage, Inv = inv, Place = place, Login = LoginTbx.Text, Password = PwdTbx.Text }; db.Workers.InsertOnSubmit(a); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } }
protected void Button1_Click(object sender, EventArgs e) { using (var db = new AGRODataContext(Server.MapPath("\\"))) { var mPrice = double.TryParse(TextBox2.Text, out double _mPrice) ? _mPrice : (double?)null; var pCulture = int.TryParse(CultureDropDown.SelectedValue, out int _pCulture) ? _pCulture : (int?)null; var pAnimals = int.TryParse(AnimalsDropDown.SelectedValue, out int _pAnimals) ? _pAnimals : (int?)null; var place = new Places { Pname = TextBox1.Text.Trim(), MPrice = mPrice, PCulture = pCulture, PAnimals = pAnimals }; db.Places.InsertOnSubmit(place); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } }
protected void Button1_Click(object sender, EventArgs e) { using (var db = new AGRODataContext(Server.MapPath("\\"))) { Animals a = new Animals { AName = TextBox1.Text, MarketPrice = Convert.ToDouble(TextBox2.Text), Count = Convert.ToInt32(TextBox3.Text) }; db.Animals.InsertOnSubmit(a); try { db.SubmitChanges(); BindGrid(); } catch (Exception exception) { Debug.WriteLine($"Somethig wrong: {exception.Message}"); } } }