public void NewEntry(DonatingRetrieving dr)
{
string a = "";
foreach (char item in dr.Amount)
{
if (item != 'm')
{
a = a + item;
}
else
{
break;
}
}
string query = "BloodEntry";
SqlCommand cmd = new SqlCommand(query, MyCon);
MyCon.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nameid", dr.NameID);
cmd.Parameters.AddWithValue("@Amount", dr.Amount);
cmd.Parameters.AddWithValue("@Type", dr.Type);
cmd.Parameters.AddWithValue("@ToFrom", dr.ToFrom);
cmd.Parameters.AddWithValue("@price", dr.Price);
cmd.Parameters.AddWithValue("@branch", dr.Branch);
cmd.Parameters.AddWithValue("@ondate", dr.Date);
cmd.Parameters.AddWithValue("@bloodtype", dr.BloodType);
cmd.Parameters.AddWithValue("@amout", a);
cmd.ExecuteNonQuery();
MyCon.Close();
}
public void UpdateDonatingRetrieving(DonatingRetrieving DR)
{
string a = "";
foreach (char item in DR.Amount)
{
if (item != 'm')
{
a = a + item;
}
else
{
break;
}
}
string query = "UpdatingDonatingRetriving";
MyCon.Open();
SqlCommand cmd = new SqlCommand(query, MyCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Sno", DR.Sno);
cmd.Parameters.AddWithValue("@NameID", DR.NameID);
cmd.Parameters.AddWithValue("@AB", DR.Amount);
cmd.Parameters.AddWithValue("@TypeOf", DR.Type);
cmd.Parameters.AddWithValue("@ToFrom", DR.ToFrom);
cmd.Parameters.AddWithValue("@Price", DR.Price);
cmd.Parameters.AddWithValue("@Branch", DR.Branch);
cmd.Parameters.AddWithValue("@Ondate", DR.Date);
cmd.Parameters.AddWithValue("@bloodtype", DR.BloodType);
cmd.Parameters.AddWithValue("@amout", int.Parse(a));
cmd.ExecuteNonQuery();
MyCon.Close();
}
public void RegisterDonationRetrieving(string name, string Amount, string bloodtype, string type, string toFro, string Price, string Branch, DateTime dt)
{
DonatingRetrieving dr = new DonatingRetrieving();
dr.NameID = name;
dr.Amount = Amount;
dr.Type = type;
dr.BloodType = bloodtype;
dr.ToFrom = toFro;
dr.Price = Price;
dr.Branch = Branch;
dr.Date = dt;
dr.NewEntry(dr);
}
public void UpdateDonationRetrieving(int sno, string name, string Amount, string bloodtype, string Type, string toFro, string Price, string Branch, DateTime dt)
{
DonatingRetrieving dr = new DonatingRetrieving();
dr.Sno = sno;
dr.NameID = name;
dr.Amount = Amount;
dr.BloodType = bloodtype;
dr.Type = Type;
dr.ToFrom = toFro;
dr.Price = Price;
dr.Branch = Branch;
dr.Date = dt;
dr.UpdateDonatingRetrieving(dr);
}
public DonatingRetrieving GetDonatingReceivingByID(int id)
{
DonatingRetrieving dr = new DonatingRetrieving();
string query = "Select * from DonatingRetriving where Sno ='" + id + "'";
MyCon.Open();
SqlCommand cmd = new SqlCommand(query, MyCon);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
dr.Sno = int.Parse(reader[0].ToString());
dr.NameID = reader[1].ToString();
dr.Amount = reader[2].ToString();
dr.Type = reader[3].ToString();
dr.ToFrom = reader[4].ToString();
dr.Price = reader[5].ToString();
dr.Branch = reader[6].ToString();
dr.Date = Convert.ToDateTime(reader[7].ToString());
}
MyCon.Close();
return(dr);
}
public DonatingRetrieving GetDonationsByID(int ID)
{
DonatingRetrieving D = new DonatingRetrieving();
return(D.GetDonatingReceivingByID(ID));
}
public DataSet SearchID(int ID)
{
DonatingRetrieving D = new DonatingRetrieving();
return(D.SearchID(ID));
}
public DataSet GetDonationRetrieving()
{
DonatingRetrieving dr = new DonatingRetrieving();
return(dr.GetAllDonatingReceiving());
}
