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 getBreederName_cboBreederName() { cboBreederName.DataSource = null; cboBreederName.Items.Clear(); using (var B = new dbFFBEntities()) { // works below - but does not add blank line // https://stackoverflow.com/questions/11745714/how-to-add-items-to-combobox-from-entity-framework cboBreederName.DataSource = B.Breeders.Select(x => new { x.BreederID, x.BreederName }).OrderBy(x => x.BreederName).ToList(); // OrderBy(x => x.BreederName) cboBreederName.ValueMember = "BreederID"; cboBreederName.DisplayMember = "BreederName"; cboBreederName.Invalidate(); //works below but cannot select first entry //cboBreederName.DataSource = null; //cboBreederName.Items.Clear(); //using (var B = new dbFFBEntities()) //{ // // works below - but does not add blank line // // https://stackoverflow.com/questions/11745714/how-to-add-items-to-combobox-from-entity-framework // cboBreederName.DataSource = B.Breeders.ToList().OrderBy(x => x.BreederName).ToList(); // cboBreederName.ValueMember = "BreederID"; // cboBreederName.DisplayMember = "BreederName"; // end works below but cannot select first entry //try https://www.aspsnippets.com/Articles/Add-Insert-Default-First-Value-in-ComboBox-in-Windows-Forms-Application-using-C-and-VBNet.aspx //https://www.aspsnippets.com/Articles/ComboBox-Items-collection-cannot-be-modified-when-the-DataSource-property-is-set.aspx } }
List <Breeder> GetBreederDetails(int Bid) { dbFFBEntities userModel = new dbFFBEntities(); List <Breeder> retModel = new List <Breeder>(); retModel = userModel.Breeders.Where(x => x.BreederID == Bid).ToList(); return(retModel); }
List <Breeder> GetAllBreeders() { using (var B = new dbFFBEntities()) { List <Breeder> retModel = new List <Breeder>(); retModel = B.Breeders.OrderBy(x => x.BreederName).ToList(); return(retModel); } }
private List <SettingT> GetDetails(int i) { using (var B = new dbFFBEntities()) { List <SettingT> retModel = new List <SettingT>(); retModel = B.SettingTs.Where(x => x.Id == i).ToList(); return(retModel); } }
private List <SettingT> GetAll() { using (var B = new dbFFBEntities()) { List <SettingT> retModel = new List <SettingT>(); retModel = B.SettingTs.OrderBy(x => x.Key).ToList(); return(retModel); } }
private List <DogOwner> GetDetails(int intId) { using (var B = new dbFFBEntities()) { List <DogOwner> retModel = new List <DogOwner>(); retModel = B.DogOwners.Where(x => x.DogOwnerID == intId).ToList(); return(retModel); } }
private List <Litter> GetLitterDetails(int LitterId) { using (var B = new dbFFBEntities()) { List <Litter> ret = new List <Litter>(); ret = B.Litters.Where(x => x.LitterID == LitterId).ToList(); return(ret); } }
private List <Dog> GetDogDetails(int intDogId) { using (var B = new dbFFBEntities()) { List <Dog> retModel = new List <Dog>(); retModel = B.Dogs.Where(x => x.DogID == intDogId).ToList(); return(retModel); } }
private List <DogOwner> GetAll() { using (var B = new dbFFBEntities()) { B.Configuration.LazyLoadingEnabled = false; List <DogOwner> retModel = new List <DogOwner>(); retModel = B.DogOwners.OrderBy(x => x.OwnerName).ToList(); return(retModel); } }
private List <Dog> GetAll() { using (var B = new dbFFBEntities()) { B.Configuration.LazyLoadingEnabled = false; List <Dog> retModel = new List <Dog>(); retModel = B.Dogs.OrderByDescending(x => x.BirthDate).ToList(); return(retModel); } }
private List <Litter> GetAll() { using (var B = new dbFFBEntities()) { B.Configuration.LazyLoadingEnabled = false; List <Litter> ret = new List <Litter>(); ret = B.Litters.OrderByDescending(x => x.WhelpDate).ToList(); return(ret); } }
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 load_cboLitter() { cboLitter.DataSource = null; cboLitter.Items.Clear(); using (var B = new dbFFBEntities()) { cboLitter.ValueMember = "LitterID"; cboLitter.DisplayMember = "WY_sireDam"; cboLitter.DataSource = B.vw_cboSearchLitters.Select(x => new { x.LitterID, x.Yr, x.WY_sireDam }).OrderBy(x => x.Yr).ToList(); cboLitter.Invalidate(); } }
private void load_cboBreeder() { cboBreeder.DataSource = null; cboBreeder.Items.Clear(); using (var B = new dbFFBEntities()) { cboBreeder.ValueMember = "BreederID"; cboBreeder.DisplayMember = "BreederName"; cboBreeder.DataSource = B.Breeders.Select(x => new { x.BreederID, x.BreederName }).Where(x => x.BreederName.ToLower() != "__breeder").OrderBy(x => x.BreederName).ToList(); cboBreeder.Invalidate(); } }
private void load_cboDogName() { cboDogName.DataSource = null; cboDogName.Items.Clear(); using (var B = new dbFFBEntities()) { cboDogName.ValueMember = "DogID"; cboDogName.DisplayMember = "DogName"; cboDogName.DataSource = B.Dogs.Select(x => new { x.DogID, x.DogName }).OrderBy(x => x.DogName).ToList(); cboDogName.Invalidate(); } }
private void load_cboKey() { cboKey.DataSource = null; cboKey.Items.Clear(); using (var B = new dbFFBEntities()) { // https://stackoverflow.com/questions/35284946/why-do-i-get-cannot-bind-to-the-new-display-member-with-this-code cboKey.ValueMember = "Id"; cboKey.DisplayMember = "Key"; cboKey.DataSource = B.SettingTs.Select(x => new { x.Id, x.Key }).OrderBy(x => x.Key).ToList(); cboKey.Invalidate(); } }
private List <Breeder> GetBreederDetails(int intBrId) { //dbFFBEntities userModel = new dbFFBEntities(); //List<Breeder> retModel = new List<Breeder>(); //retModel = userModel.Breeders.Where(x => x.BreederID == intBrId).ToList(); //return retModel; using (var B = new dbFFBEntities()) { List <Breeder> retModel = new List <Breeder>(); retModel = B.Breeders.Where(x => x.BreederID == intBrId).ToList(); return(retModel); } }
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 load_cboSearch() { cboSearch.DataSource = null; cboSearch.Items.Clear(); using (var B = new dbFFBEntities()) { cboSearch.ValueMember = "LitterID"; cboSearch.DisplayMember = "WY_sireDam"; cboSearch.DataSource = B.vw_cboSearchLitters.Select(x => new { x.LitterID, x.Yr, x.WY_sireDam }).OrderBy(x => x.Yr).ToList(); cboSearch.Invalidate(); //cboSearch.DataSource = B.Litters // .Select(x => new { x.LitterID, x.Sire_dogID, x.Dam_dogID, x.WhelpDate }) // .Join(B.Dogs.Select(y => new { y.DogID, y.DogName) // .Where(y => y.DogID) = () } }
private void load_cboBirthDate() { cboBirthDate.DataSource = null; cboBirthDate.Items.Clear(); using (var B = new dbFFBEntities()) { //try datatable //DataTable dta = new DataTable(); //dta = B.Dogs.Select(x => new { x.DogID, x.BirthDate }).OrderBy(x => x.BirthDate); //var qry = B.Dogs.Select(x => new { x.DogID, x.BirthDate }).OrderBy(x => x.BirthDate).ToList(); //var neww = new Dog(); //neww.DogID = -1; //neww.BirthDate =01/01/1900; //https://sansknowledge.wordpress.com/2014/04/30/adding-default-value-or-empty-value-to-entity-framework-bound-combo-box/ //https://stackoverflow.com/questions/1388679/add-empty-entry-to-combobox-bound-to-entity-list/4826238#4826238 //var entity = new dbFFBEntities(); //var qry = B.Dogs.Select(x => new { x.DogID, x.BirthDate }).OrderBy(x => x.BirthDate).ToList(); //var lst = qry.ToList(); //var dot = new Dog(); //dot.DogID = -1; ; ////dot.BirthDate = new DateTime(1900, 1, 1); //dot.BirthDate = DateTime.Today; //if (dot.BirthDate.HasValue) // lst.Insert(0, dot); //cboBirthDate.DataSource = lst; //{ // EntityId = -1 //}; cboBirthDate.ValueMember = "DogID"; cboBirthDate.DisplayMember = "BirthDate"; cboBirthDate.DataSource = B.Dogs.Select(x => new { x.DogID, x.BirthDate }).OrderBy(x => x.BirthDate).ToList(); cboBirthDate.Invalidate(); } }
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 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"); } } } }
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"); } } } }