private void Updatebutton_Click(object sender, RoutedEventArgs e)
{
try
{
BloodInventory p = new BloodInventory()
{
BloodInvenoryID = (SearchtextBox.Text),
BloodGroup = BloodGrouptextBox.Text,
NumberOfBottles = int.Parse(txtNoOfBottles.Text),
BloodBankID = (txtBloodBankId.Text),
ExpiryDate = Convert.ToDateTime(txtExpiryDate.Text),
//HospitalID = int.Parse(txtHospitalId.Text)
};
BloodInventoryBLL pb = new BloodInventoryBLL();
if (pb.EditBloodInventory(p))
{
groupBox.Visibility = Visibility.Hidden;
MessageBox.Show("Inventory data updated.", "BBMS");
}
}
catch (BloodBankExceptions ex)
{
MessageBox.Show(ex.Message, "BBMS");
}
catch (SystemException ex)
{
MessageBox.Show(ex.Message, "BBMS");
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
BloodInventoryBLL pb = new BloodInventoryBLL();
BloodInventory p = pb.Search(int.Parse(SearchtextBox.Text));
if (p != null)
{
BloodGrouptextBox.Text = p.BloodGroup;
txtBloodBankId.Text = p.BloodBankID.ToString();
txtNoOfBottles.Text = p.NumberOfBottles.ToString();
txtExpiryDate.Text = p.ExpiryDate.ToShortDateString();
// txtHospitalId.Text = p.HospitalID.ToString();
groupBox.Visibility = Visibility.Visible;
}
else
{
groupBox.Visibility = Visibility.Hidden;
MessageBox.Show
(string.Format("Blood Inventory with id {0} does not exists.", SearchtextBox.Text),
"Blood Inventory Management System");
}
}
catch (BloodBankExceptions ex)
{
MessageBox.Show(ex.Message, "Blood Inventory Management System");
}
catch (SystemException ex)
{
MessageBox.Show(ex.Message, "Blood Inventory Management System");
}
}
private void checkBloodQuantity(int id)
{
this.bloodInventoryTable = db.BloodInventories.SingleOrDefault(x => x.Id == id);
if (this.bloodInventoryTable != null)
{
this.bloodQuantity = this.bloodInventoryTable.bloodquantity ?? default(int);
this.LableStatus.Text = this.bloodGroup + " : " + this.bloodQuantity.ToString();
}
}
public bool EditBloodInventory(BloodInventory pobj)
{
try
{
BloodInventoryDL pd = new BloodInventoryDL();
return(pd.EditBloodInventory(pobj));
}
catch (BloodBankExceptions)
{
throw;
}
}
public BloodInventory Search(int searchInventory)
{
BloodInventory p = null;
try
{
// con = new SqlConnection();
//con.ConnectionString = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
cmd = new SqlCommand();
cmd.CommandText = "BBank.uspSearchBloodInventory";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@bId", searchInventory);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
p = new BloodInventory
{
BloodGroup = dr["BloodGroup"].ToString(),
NumberOfBottles = int.Parse(dr["NumberofBottles"].ToString()),
BloodBankID = (dr["BloodBankID"].ToString()),
ExpiryDate = DateTime.Parse((dr["ExpiryDate"].ToString())),
// HospitalID = int.Parse(dr["HospitalId"].ToString())
};
dr.Close();
}
}
catch (BloodBankExceptions) { throw; }
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(p);
}
private void addToBloodInventory() //only for donation
{
BloodData bdataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName);
BloodInventory bloodTable = db.BloodInventories.SingleOrDefault(x => x.bloodgroup == this.bloodGroup);
if (bloodTable != null && bdataTable != null)
{
this.date = DateTime.Now;
bloodTable.bloodquantity += 1;
bdataTable.donated += 1;
bdataTable.date = date.ToString();
bdataTable.month = int.Parse(date.Month.ToString());
db.SubmitChanges();
this.addToHistory(1);
this.LableStatus.Text = bloodTable.bloodgroup + " : Blood Donated " + bloodTable.bloodquantity.ToString();
}
}
public bool EditBloodInventory(BloodInventory pboj)
{
bool result = false;
try
{
// con = new SqlConnection();
// con.ConnectionString = ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString;
cmd = new SqlCommand();
cmd.CommandText = "BBank.uspEditBloodInventory";
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@bId", pboj.BloodInvenoryID);
cmd.Parameters.AddWithValue("@BloodGroup", pboj.BloodGroup);
cmd.Parameters.AddWithValue("@noofbottle", pboj.NumberOfBottles);
cmd.Parameters.AddWithValue("@BloodBankId", pboj.BloodBankID);
cmd.Parameters.AddWithValue("@expiryDate", pboj.ExpiryDate);
//cmd.Parameters.AddWithValue("@hid", pboj.HospitalID);
con.Open();
int noOfRowsAffected = cmd.ExecuteNonQuery();
if (noOfRowsAffected == 1)
{
result = true;
}
}
catch (BloodBankExceptions) { throw; }
catch (SqlException)
{
throw;
}
catch (SystemException)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(result);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (this.checkValidation())
{
BloodInventory bloodInvTab = db.BloodInventories.SingleOrDefault(x => x.bloodgroup == this.bloodGroup);
if (bloodInvTab != null)
{
int quantity = int.Parse(this.txtBloodQuantity.Text.ToString());
bloodInvTab.bloodquantity += quantity;
db.SubmitChanges();
this.lableStatus.Text = this.bloodGroup + " : " + bloodInvTab.bloodquantity.ToString() + "Total";
}
}
else
{
lableStatus.Text = "Validation Error";
}
}
private void updateBloodQuantity(int uReqQuantity) //only for request blood
{
BloodData bDataTable = db.BloodDatas.SingleOrDefault(x => x.userID == this.LoggedUName);
BloodInventory bloodInvTable = db.BloodInventories.SingleOrDefault(x => x.bloodgroup == this.bloodGroup);
if (bloodInvTable != null && bDataTable != null)
{
this.bloodQuantity -= uReqQuantity;
//i was here
bloodInvTable.bloodquantity = this.bloodQuantity;
//db.SubmitChanges();
bDataTable.requested += int.Parse(this.txtBloodQuantity.Text.ToString()); //it was not updating
db.SubmitChanges();
this.addToHistory(uReqQuantity);
MessageBox.Show("Request Accepted" + bDataTable.requested.ToString());
}
else
{
MessageBox.Show("DB not Updated");
}
}
