public int CampaignNotes_Insert_Update_Delete(BAL_AddCampaignNotes baddcmpdel)
{
try
{
con.Open();
cmd = new SqlCommand("SP_CampaignNotesDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@ID", baddcmpdel.Id);
int i = cmd.ExecuteNonQuery();
return(i);
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int AddCampainsNotes_Insert_Update_Delete(BAL_AddCampaignNotes baddcampnots)
{
try
{
con.Open();
cmd = new SqlCommand("SP_CampaignNotes", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@CampaignId", baddcampnots.CampaignId);
cmd.Parameters.AddWithValue("@CampaignNotes", baddcampnots.CampaignNotes);
cmd.Parameters.AddWithValue("@S_Status", baddcampnots.S_Status);
cmd.Parameters.AddWithValue("@C_Date", baddcampnots.C_Date);
int i = cmd.ExecuteNonQuery();
return(i);
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
