private void btnDelete_Click(object sender, EventArgs e) { //delete //https://ef.readthedocs.io/en/staging/saving/basic.html#deleting-data using (var B = new dbFFBEntities()) { var d = B.Breeders.First(x => x.BreederName == cboBreederName.Text.Trim()); d.Active = chkActive.Checked; d.BreederAddress = txtBreederAddress.Text.Trim(); d.BreederCity = txtBreederCity.Text.Trim(); d.BreederEmail = txtBreederCity.Text.Trim(); d.BreederKennel = txtBreederKennel.Text.Trim(); d.BreederName = txtBreederName.Text.Trim(); d.BreederPhone = txtBreederPhone.Text.Trim(); d.BreederState = txtBreederState.Text.Trim(); d.BreederWebSite = txtBreederWebsite.Text.Trim(); d.BreederZip = txtBreederZip.Text.Trim(); d.LastUpdateID = Environment.UserName.ToString(); d.LastUpdateTimeStamp = DateTime.Now; B.Breeders.Remove(d); var de = B.SaveChanges(); if (de == 1) { ClearAllBreederFields(); pnlDetail.Visible = false; getBreederName_cboBreederName(); MessageBox.Show("Breeder " + d.BreederName + " Deleted Successfully"); } else { MessageBox.Show("Breeder Delete Failed"); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsUpdateOperation == true) { // Update try { int Lid = Convert.ToInt32(lblLitterID.Text); } catch (Exception ex) { MessageBox.Show("Error in Update Litter: " + ex.ToString()); } } else { // Insert try { using (var B = new dbFFBEntities()) { var i = new Litter { AKCLitter = txtAKCLitterNumber?.Text.Trim().ToUpper(), Sire_dogID = Convert.ToInt32(cboSire.SelectedValue), Dam_dogID = Convert.ToInt32(cboDam.SelectedValue), LitterFemales = Convert.ToInt32(txtFemales?.Text.Trim()), LitterMales = Convert.ToInt32(txtMales.Text.Trim()), DeliverVet = txtVet.Text.Trim(), WhelpDate = dtpWhelpDate.Value, Active = chkActive.Checked, LastUpdateID = Environment.UserName.ToString(), LastUpdateTimeStamp = DateTime.Now }; B.Litters.Add(i); var sa = B.SaveChanges(); if (sa == 1) { Reset(false); //frmLitter_Load(sender, e); MessageBox.Show(strTableName + i.LitterID + " Added Successfully"); } else { MessageBox.Show(strTableName + " insert Failed"); } } } catch (Exception ex) { MessageBox.Show("Error on Insert Litter " + ex.ToString()); } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsUpdateOperation == true) { // Update int intI = Convert.ToInt32(lblID.Text); using (var B = new dbFFBEntities()) { var u = B.SettingTs.First(x => x.Id == intI); u.Key = txtKey.Text.Trim(); u.Value = txtValue.Text.Trim(); var s = B.SaveChanges(); if (s == 1) { ClearAllDetailFields(); load_cboKey(); dgvSettingsT.DataSource = GetAll(); MessageBox.Show(strTableName + u.Key + " Updated Successfully"); } else { MessageBox.Show(strTableName + " update Failed"); } } } else { // Insert using (var B = new dbFFBEntities()) { var i = new SettingT { Key = txtKey.Text.Trim(), Value = txtValue.Text.Trim() }; B.SettingTs.Add(i); var sa = B.SaveChanges(); if (sa == 1) { ClearAllDetailFields(); load_cboKey(); dgvSettingsT.DataSource = GetAll(); MessageBox.Show(strTableName + i.Key + " Added Successfully"); } } } }
private void btnDelete_Click(object sender, EventArgs e) { int myId = Convert.ToInt32(lblLitterID.Text); using (var B = new dbFFBEntities()) { var d = B.Litters.First(x => x.LitterID == myId); B.Litters.Remove(d); var de = B.SaveChanges(); if (de == 1) { Reset(false); } else { MessageBox.Show(strTableName + " delete failed"); } } }
private void btnDelete_Click(object sender, EventArgs e) { int intId = Convert.ToInt32(lblDogOwnerID.Text); using (var B = new dbFFBEntities()) { var d = B.DogOwners.First(x => x.DogOwnerID == intId); B.DogOwners.Remove(d); var de = B.SaveChanges(); if (de == 1) { ClearAllDetailFields(); load_cboName(); dgv.DataSource = GetAll(); } else { MessageBox.Show(strTableName + " delete failed"); } } }
private void btnDelete_Click(object sender, EventArgs e) { //delete //https://ef.readthedocs.io/en/staging/saving/basic.html#deleting-data int intId = Convert.ToInt32(lblID.Text); using (var B = new dbFFBEntities()) { var d = B.SettingTs.First(x => x.Id == intId); B.SettingTs.Remove(d); var de = B.SaveChanges(); if (de == 1) { ClearAllDetailFields(); load_cboKey(); dgvSettingsT.DataSource = GetAll(); } else { MessageBox.Show(strTableName + " delete failed"); } } }
private void btnUpdate_Click(object sender, EventArgs e) { if (IsUpdateOperation == true) { // this is Update //https://ef.readthedocs.io/en/staging/saving/basic.html#updating-data using (var B = new dbFFBEntities()) { var u = B.Breeders.First(x => x.BreederName == cboBreederName.Text.Trim()); u.Active = chkActive.Checked; u.BreederAddress = txtBreederAddress.Text.Trim(); u.BreederCity = txtBreederCity.Text.Trim(); u.BreederEmail = txtBreederCity.Text.Trim(); u.BreederKennel = txtBreederKennel.Text.Trim(); u.BreederName = txtBreederName.Text.Trim(); u.BreederPhone = txtBreederPhone.Text.Trim(); u.BreederState = txtBreederState.Text.Trim(); u.BreederWebSite = txtBreederWebsite.Text.Trim(); u.BreederZip = txtBreederZip.Text.Trim(); u.LastUpdateID = Environment.UserName.ToString(); u.LastUpdateTimeStamp = DateTime.Now; var s = B.SaveChanges(); if (s == 1) { ClearAllBreederFields(); pnlDetail.Visible = false; getBreederName_cboBreederName(); MessageBox.Show("Breeder " + u.BreederName + " Updated Successfully"); } else { MessageBox.Show("Breeder update Failed"); } //dbFFBEntities userModel = new dbFFBEntities(); //Breeder Brd = userModel.Breeders.First(x => x.BreederName == cboBreederName.Text); //List<Breeder> listB = new List<Breeder>(); //listB = userModel.Breeders.Where(x => x.BreederName == cboBreederName.Text).ToList(); } } else { // Insert using (var B = new dbFFBEntities()) { var i = new Breeder { BreederAddress = txtBreederAddress.Text.Trim(), BreederCity = txtBreederCity.Text.Trim(), BreederEmail = txtBreederCity.Text.Trim(), BreederKennel = txtBreederKennel.Text.Trim(), BreederName = txtBreederName.Text.Trim(), BreederPhone = txtBreederPhone.Text.Trim(), BreederState = txtBreederState.Text.Trim(), BreederWebSite = txtBreederWebsite.Text.Trim(), BreederZip = txtBreederZip.Text.Trim(), LastUpdateID = Environment.UserName.ToString(), LastUpdateTimeStamp = DateTime.Now }; B.Breeders.Add(i); var sa = B.SaveChanges(); if (sa == 1) { ClearAllBreederFields(); pnlDetail.Visible = false; getBreederName_cboBreederName(); MessageBox.Show("Breeder " + i.BreederName + " Added Successfully"); } else { MessageBox.Show("Breeder insert Failed"); } } } }
private void btnSave_Click(object sender, EventArgs e) { //int Lit = 0; //int? Lit1 = 0; if (IsUpdateOperation) { //Update //if (int.TryParse(txtLitterID.Text, out Lit)) //{ // Lit1 = Lit; //} //else //{ // Lit1 = null; //} int intI = Convert.ToInt32(lblDogID.Text); using (var B = new dbFFBEntities()) { var u = B.Dogs.First(x => x.DogID == intI); u.AKCDogId = txtAKCDogID?.Text.Trim().ToUpper(); u.DogName = txtDogName?.Text.Trim(); u.AKCDogName = txtAKCDogName?.Text.Trim().ToUpper(); u.AKCRegCertficateDate = dtpRegCertDate.Value; u.Microchip_Num = txtMicrochipNum?.Text.Trim(); u.CoatColor = txtCoatColor?.Text.Trim(); u.Markings = txtMarkings?.Text.Trim(); u.Gender = rdoMale.Checked ? "Male" : "Female"; //u.LitterId = Convert.ToInt32(txtLitterID.Text.Trim()); //u.LitterId = Lit1; u.LitterId = Convert.ToInt32(cboLitter.SelectedValue); u.BreederID = Convert.ToInt32(cboBreeder.SelectedValue); u.DogOwnerID = Convert.ToInt32(cboDogOwner.SelectedValue); //may need StringFormatter u.BirthDate = dtpBirthDate.Value; u.EarsUpStayUpDate = dtpEarsStayUp.Value; u.DeceasedDate = dtpDeceasedDate.Value; u.Active = chkActive.Checked; u.LastUpdateID = Environment.UserName; u.LastUpdateTimeStamp = DateTime.Now; var s = B.SaveChanges(); if (s == 1) { Reset(false); MessageBox.Show(strTableName + u.DogName + " Updated Successfully"); } else { //update failed MessageBox.Show(strTableName + " Update Failed"); } } } else { // Insert //if (int.TryParse(txtLitterID.Text, out Lit)) //{ // Lit1 = Lit; //} //else //{ // //Lit1 = null; // Lit1 = null; //} using (var B = new dbFFBEntities()) { var i = new Dog { DogName = txtDogName.Text.Trim(), AKCDogId = txtAKCDogID?.Text.Trim().ToUpper(), AKCDogName = txtAKCDogName?.Text.Trim().ToUpper(), AKCRegCertficateDate = dtpRegCertDate.Value, Microchip_Num = txtMicrochipNum?.Text.Trim(), CoatColor = txtCoatColor?.Text.Trim(), Markings = txtMarkings?.Text.Trim(), Gender = rdoMale.Checked ? "Male" : "Female", //LitterId = Convert.ToInt32(txtLitterID.Text.Trim()), //LitterId = Lit1, LitterId = Convert.ToInt32(cboLitter.SelectedValue), BreederID = Convert.ToInt32(cboBreeder.SelectedValue), DogOwnerID = Convert.ToInt32(cboDogOwner.SelectedValue), BirthDate = dtpBirthDate.Value, EarsUpStayUpDate = dtpEarsStayUp.Value, DeceasedDate = dtpDeceasedDate.Value, Active = chkActive.Checked, LastUpdateID = Environment.UserName, LastUpdateTimeStamp = DateTime.Now }; B.Dogs.Add(i); var sa = B.SaveChanges(); if (sa == 1) { Reset(false); MessageBox.Show(strTableName + i.DogName + " Inserted Successfully"); } else { MessageBox.Show(strTableName + " Insert failed"); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (IsUpdateOperation == true) { // Update int intI = Convert.ToInt32(lblDogOwnerID.Text); using (var B = new dbFFBEntities()) { var u = B.DogOwners.First(x => x.DogOwnerID == intI); u.OwnerName = txtOwnerName.Text.Trim(); u.OwnerAddress = txtOwnerAddress.Text.Trim(); u.OwnerCity = txtOwnerCity.Text.Trim(); u.OwnerState = txtState.Text.Trim(); u.OwnerZip = txtZip.Text.Trim(); u.OwnerPhone = txtPhone.Text.Trim(); u.OwnerEmail = txtEmail.Text.Trim(); u.Active = chkActive.Checked; u.LastUpdateID = Environment.UserName; u.LastUpdateTimeStamp = DateTime.Now; var s = B.SaveChanges(); if (s == 1) { ClearAllDetailFields(); load_cboName(); dgv.DataSource = null; dgv.DataSource = GetAll(); MessageBox.Show(strTableName + u.OwnerName + " Updated Successfully"); } else { MessageBox.Show(strTableName + " Update Failed"); } } } else { // Insert using (var B = new dbFFBEntities()) { var i = new DogOwner { OwnerName = txtOwnerName.Text.Trim(), OwnerAddress = txtOwnerAddress.Text.Trim(), OwnerCity = txtOwnerCity.Text.Trim(), OwnerState = txtState.Text.Trim(), OwnerZip = txtZip.Text.Trim(), OwnerPhone = txtPhone.Text.Trim(), OwnerEmail = txtEmail.Text.Trim(), Active = chkActive.Checked, LastUpdateID = Environment.UserName, LastUpdateTimeStamp = DateTime.Now }; B.DogOwners.Add(i); var sa = B.SaveChanges(); if (sa == 1) { ClearAllDetailFields(); load_cboName(); dgv.DataSource = null; dgv.DataSource = GetAll(); MessageBox.Show(strTableName + i.OwnerName + " Added Successfully"); } else { MessageBox.Show(strTableName + " Insert failed"); } } } }