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