public void LinkItemWithDonor(DonorItem item)
{
InitializeConnection();
OracleCommand cmd = new OracleCommand
{
Connection = conn,
CommandText = $"insert into Donate_to (Donor_SSN,Campaign_ID,ItemMainName,ItemName,ItemSubName)" +
$" Values({item.Donor.SSN},{item.Campaign.ID},{item.Item.Main.Name},{item.Item.Name},{item.Item.Sub.Name})",
CommandType = CommandType.Text
};
cmd.ExecuteNonQuery();
}
public void UpdateLink(DonorItem item)
{
OracleCommand cmd = new OracleCommand
{
Connection = conn,
CommandText = $"update Donate_to set Count_={item.Count}" +
$"where ItemName={item.Item.Name}, ItemMainName={item.Item.Main.Name}," +
$" ItemSubName={item.Item.Sub.Name},Donor_SSN={item.Donor.SSN},Campaign_ID={item.Campaign.ID}",
CommandType = CommandType.Text
};
cmd.ExecuteNonQuery();
}
public void DeleteLink(DonorItem item)
{
FetchTable("Donate_to");
var row = (from entry in dataSet.Tables["Donate_to"].AsEnumerable()
where entry.Field <int>("Campaign_ID") == item.Campaign.ID &&
entry.Field <int>("Donor_SSN") == item.Donor.SSN &&
entry.Field <string>("ItemName") == item.Item.Name &&
entry.Field <string>("ItemMainName") == item.Item.Main.Name &&
entry.Field <string>("ItemSubName") == item.Item.Sub.Name
select entry).Single();
dataSet.Tables["Donate_to"].Rows.Remove(row);
}
public void UpdateLink(DonorItem donorItem)
{
FetchTable("Donate_to");
var row = (from entry in dataSet.Tables["Donate_to"].AsEnumerable()
where entry.Field <int>("Campaign_ID") == donorItem.Campaign.ID &&
entry.Field <int>("Donor_SSN") == donorItem.Donor.SSN &&
entry.Field <string>("ItemName") == donorItem.Item.Name &&
entry.Field <string>("ItemMainName") == donorItem.Item.Main.Name &&
entry.Field <string>("ItemSubName") == donorItem.Item.Sub.Name
select entry).Single();
row["Count_"] = donorItem.Count;
}
public void LinkItemWithDonor(DonorItem item)
{
FetchTable("Donate_to");
DataRow row = dataSet.Tables["Donate_to"].NewRow();
row["ItemName"] = item.Item.Name;
row["ItemMainName"] = item.Item.Main.Name;
row["ItemSubName"] = item.Item.Sub.Name;
row["Donor_SSN"] = item.Donor.SSN;
row["Campaign_ID"] = item.Campaign.ID;
row["Count_"] = item.Count;
dataSet.Tables["Donate_to"].Rows.Add(row);
}
public void UpdateLink(DonorItem item)
{
InitializeConnection();
OracleCommand cmd = new OracleCommand
{
Connection = conn,
CommandText = $"update Donate_to set Count_={item.Count}" +
$"where ItemName={item.Item.Name},MainName={item.Item.Main.Name},SubName={item.Item.Sub.Name}",
CommandType = CommandType.Text
};
cmd.ExecuteNonQuery();
}
public void DeleteLink(DonorItem item)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = @"delete from donate_to where donar_ssn=:ssn and
ItemMainName=:MainName and ItemSubName=:SubName and
itemName=:name";
cmd.Parameters.Add("ssn", item.Donor.SSN);
cmd.Parameters.Add("MainName", item.Item.Main.Name);
cmd.Parameters.Add("SubName", item.Item.Sub.Name);
cmd.Parameters.Add("name", item.Item.Name);
cmd.ExecuteNonQuery();
}
public void DeleteLink(DonorItem item)
{
throw new NotImplementedException();
}
public void LinkItemWithDonor(DonorItem item)
{
throw new NotImplementedException();
}
public void DeleteLink(DonorItem item)
{
dbLayer.DeleteLink(item);
}
public void UpdateLink(DonorItem donorItem)
{
dbLayer.UpdateLink(donorItem);
}
public void LinkItemWithDonor(DonorItem item)
{
dbLayer.LinkItemWithDonor(item);
}
public void UpdateLink(DonorItem donorItem)
{
throw new NotImplementedException();
}
