public static Contributing UpdateContributing(Contributing contributing)
{
string updateContributing = "UPDATE Contributing SET FID = @FID WHERE SID = @SID";
using (SqlConnection connection = new SqlConnection(connstring))
{
connection.Open();
SqlCommand cmd = new SqlCommand(updateContributing, connection);
cmd.Parameters.AddWithValue("@FID", contributing.Fid);
cmd.Parameters.AddWithValue("@SID", contributing.Sid);
cmd.ExecuteNonQuery();
}
return(contributing);
}
public static Contributing InsertContributing(Contributing contributing)
{
string insertData = "INSERT INTO Contributing(FID,SID) VALUES(@FID, @SID)";
using (SqlConnection connection = new SqlConnection(connstring))
{
connection.Open();
SqlCommand cmd = new SqlCommand(insertData, connection);
//Adds data
cmd.Parameters.Add(new SqlParameter("@FID", contributing.Fid));
cmd.Parameters.Add(new SqlParameter("@SID", contributing.Sid));
cmd.ExecuteNonQuery();
}
return(contributing);
}
public static Contributing UpdataContributing(Contributing contributing)
{
return(DalManager.UpdateContributing(contributing));
}
public static Contributing InsertData(Contributing contributing)
{
return(DalManager.InsertContributing(contributing));
}
