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