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