public string DeleteSavedAdvertisement(PropSaveAdvertisements objAdvSaved)
{
SqlCommand cmd = new SqlCommand("proc_SaveAdvertisements", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Con.Open();
try
{
cmd.Parameters.AddWithValue("@ID", objAdvSaved.ID);
cmd.Parameters.AddWithValue("@action", "DeleteRecord");
int a = cmd.ExecuteNonQuery();
objCon.Con.Close();
if (a > 0)
{
return(a.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
catch (Exception showError)
{
throw showError;
}
finally
{
cmd.Dispose();
objCon.Con.Close();
objCon.Con.Dispose();
}
}
/// <summary>
/// This Method is used to save advertisements by Consumer for future references
/// </summary>
/// <param name="objAdvSaved"></param>
/// <returns></returns>
public string InsertSaveAdvertisement(PropSaveAdvertisements objAdvSaved, int zipCode, int jtype)
{
SqlCommand cmd = new SqlCommand("proc_SaveAdvertisements", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Con.Open();
try
{
cmd.Parameters.AddWithValue("@ConsumerID", objAdvSaved.ConsumerID);
cmd.Parameters.AddWithValue("@AdvertisementID", objAdvSaved.AdvertisementID);
cmd.Parameters.AddWithValue("@Zipcode", zipCode);
cmd.Parameters.AddWithValue("@jobType", jtype);
cmd.Parameters.AddWithValue("@action", "Add");
int a = cmd.ExecuteNonQuery();
objCon.Con.Close();
if (a > 0)
{
return(a.ToString());
}
else
{
return(ClsCommon.InactiveValue.ToString());
}
}
catch (Exception showError)
{
throw showError;
}
finally
{
cmd.Dispose();
objCon.Con.Close();
objCon.Con.Dispose();
}
}
public string DeleteSavedAdts(int ID)
{
string str = string.Empty;
PropSaveAdvertisements objSave = new PropSaveAdvertisements();
objSave.ConsumerID = Convert.ToInt16(Session["consumer"].ToString());
objSave.ID = ID;
BllinnerPage objSaveads = new BllinnerPage();
str = objSaveads.DeleteRecord(objSave);
return(str);
}
public string InsertSavedAdts(int AdvertisementID, int zipCode, int jtype)
{
string str = string.Empty;
PropSaveAdvertisements objSave = new PropSaveAdvertisements();
objSave.ConsumerID = Convert.ToInt16(Session["consumer"].ToString());
objSave.AdvertisementID = AdvertisementID;
BllinnerPage objSaveads = new BllinnerPage();
str = objSaveads.RecordInsert(objSave, zipCode, jtype);
return(str);
}
public string DeleteRecord(PropSaveAdvertisements objProperty)
{
DllinnerPage objDal = new DllinnerPage();
try
{
return(objDal.DeleteSavedAdvertisement(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string RecordInsert(PropSaveAdvertisements objProperty, int zipCode, int jtype)
{
DllinnerPage objDal = new DllinnerPage();
try
{
return(objDal.InsertSaveAdvertisement(objProperty, zipCode, jtype));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
