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");
}
}
}
}
