public string BlockPostAdvertisements(PropSales objSale, string associateID, int activeV) { if (associateID != null && associateID != "") { SqlCommand cmd = new SqlCommand("proc_PostAdvertisement", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); cmd.Parameters.AddWithValue("@associateID", Convert.ToInt16(associateID)); cmd.Parameters.AddWithValue("@SubCategoryId", objSale.Subcategory); cmd.Parameters.AddWithValue("@flag", activeV); cmd.Parameters.AddWithValue("@Action", "BlockedAdvt"); int a = Convert.ToInt16(cmd.ExecuteNonQuery()); objCon.Con.Close(); if (a > 0) { return(a.ToString()); } else { return(ClsCommon.InactiveValue.ToString()); } } else { return("Not Valid"); } }
public string RemoveSaleRecord(PropSales objSale, string associateID) { if (associateID != null && associateID != "") { SqlCommand cmd = new SqlCommand("proc_PostAdvertisement", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); cmd.Parameters.AddWithValue("@advertisementID", objSale.ID); cmd.Parameters.AddWithValue("@Action", "DeleteRcd"); int a = Convert.ToInt16(cmd.ExecuteNonQuery()); objCon.Con.Close(); if (a > 0) { return(a.ToString()); } else { return(ClsCommon.InactiveValue.ToString()); } } else { return("Not Valid"); } }
public string UpdateSale(int CategoryId, int SubCategoryId, string title, string Features, string address, string contactNo, string description, string countryID, string StateID, string cityID, string zipcode, float amount, int id) { string str = string.Empty; if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null) { PropSales proSale = new PropSales(); proSale.AssociateID = Convert.ToInt16(Session["associate"]); proSale.CategoryID = CategoryId; proSale.Subcategory = SubCategoryId; proSale.Title = title; proSale.Features = Features; proSale.Address = address; proSale.ContactNo = contactNo; proSale.Description = description; proSale.CountryID = countryID; proSale.StateID = StateID; proSale.CityID = cityID; //proSale.IsfeaturedID = isFeatured; proSale.Zipcode = zipcode; proSale.Amount = amount; proSale.ID = id; BllSale objSale = new BllSale(); str = objSale.RecordupdateSale(proSale, Session["associate"].ToString()); return(str); } else { return("Error in Authentication"); } }
public void ViewRecords() { List <PropSales> stq = new List <PropSales>(); string cn = ConfigurationManager.ConnectionStrings["con"].ConnectionString; using (SqlConnection con = new SqlConnection(cn)) { SqlCommand cmd = new SqlCommand("proc_DisplayAdvertisements", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@action", "SubcategoryWise"); cmd.Parameters.AddWithValue("@ZipCode", "501"); cmd.Parameters.AddWithValue("@subCategoryID", 1); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { PropSales sq = new PropSales(); sq.ID = Convert.ToInt16(dr["advertisementID"]); sq.Title = dr["title"].ToString(); sq.Address = dr["address"].ToString(); sq.Description = dr["description"].ToString(); sq.Amount = Convert.ToDouble(dr["cost"].ToString()); sq.IsfeaturedID = Convert.ToInt16(dr["isfeatured"].ToString()); sq.MainImg = dr["advMainImage"].ToString(); sq.CityName = dr["City"].ToString(); sq.Zipcode = dr["ZipCode"].ToString(); stq.Add(sq); } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(stq)); }
public string Blockadvertisements(int ID, int activeV) { string str = string.Empty; if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null) { PropSales objProperty = new PropSales(); objProperty.Subcategory = ID; BllSale ObjLeadStatus = new BllSale(); str = ObjLeadStatus.BlockedRecords(objProperty, Session["associate"].ToString(), activeV); return(str); } else { return("Error in Authentication"); } }
//public string RecordInsert(PropSales objProperty, string associateID, object FeatureID) public string RecordInsert(PropSales objProperty, string associateID) { DllSale objDal = new DllSale(); try { return(objDal.InsertSale(objProperty, associateID)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string BlockedRecords(PropSales objProperty, string associateID, int activeV) { DllSale objDal = new DllSale(); try { return(objDal.BlockPostAdvertisements(objProperty, associateID, activeV)); } catch (Exception info) { throw info; } finally { objDal = null; } }
public string UpdatePostAdvertisementsCost(int advtID, float amount) { string str = string.Empty; if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null) { PropSales objProperty = new PropSales(); objProperty.ID = advtID; BllSale objSale = new BllSale(); str = objSale.UpdatePostAdvertisementsCost(Session["associate"].ToString(), advtID, amount); return(str); } else { return("Error in Authentication"); } }
public string DeleteDataFromadvertisement(int advtID) { string str = string.Empty; if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null) { PropSales objProperty = new PropSales(); objProperty.ID = advtID; BllSale objSale = new BllSale(); str = objSale.RecordDelete(objProperty, Session["associate"].ToString()); return(str); } else { return("Error in Authentication"); } }
public string UpdateFeaturedAdv(PropSales objSale, string associateID) { if (associateID != null && associateID != "") { SqlCommand cmd = new SqlCommand("proc_PostAdvertisement", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); //try //{ cmd.Parameters.AddWithValue("@associateID", Convert.ToInt16(associateID)); cmd.Parameters.AddWithValue("@CategoryID", objSale.CategoryID); cmd.Parameters.AddWithValue("@SubCategoryId", objSale.Subcategory); cmd.Parameters.AddWithValue("@title", objSale.Title); cmd.Parameters.AddWithValue("@feature", objSale.Features); cmd.Parameters.AddWithValue("@address", objSale.Address); cmd.Parameters.AddWithValue("@email", objSale.Email); cmd.Parameters.AddWithValue("@contactNo", objSale.ContactNo); cmd.Parameters.AddWithValue("@description", objSale.Description); // cmd.Parameters.AddWithValue("@advMainImage", objSale.adv); cmd.Parameters.AddWithValue("@countryID", objSale.CountryID); cmd.Parameters.AddWithValue("@StateID", objSale.StateID); cmd.Parameters.AddWithValue("@cityID", objSale.CityID); cmd.Parameters.AddWithValue("@zipcode", objSale.Zipcode); cmd.Parameters.AddWithValue("@isFeatured", objSale.IsfeaturedID); cmd.Parameters.AddWithValue("@amount", objSale.Amount); cmd.Parameters.AddWithValue("@advertisementID", objSale.ID); cmd.Parameters.AddWithValue("@Action", "Update"); int a = Convert.ToInt16(cmd.ExecuteNonQuery()); objCon.Con.Close(); if (a > 0) { //DataTable dt = new DataTable(); //dt.Columns.Add("featureID"); //dt.Columns.Add("advertisementID"); //string[] totalEmp = FeatureID.ToString().Split(','); //for (int i = 0; i < totalEmp.Length; i++) //{ // DataRow dr = dt.NewRow(); // dr["featureID"] = totalEmp[i]; // dr["advertisementID"] = a; // dt.Rows.Add(dr); //} //SqlCommand cmdFeature = new SqlCommand("proc_AdvFeature", objCon.Con); //cmdFeature.CommandType = CommandType.StoredProcedure; //objCon.Con.Open(); //cmdFeature.Parameters.AddWithValue("@Details", dt); //int b = cmdFeature.ExecuteNonQuery(); //objCon.Con.Close(); //if (b >= 1) //{ return(a.ToString()); //} //else //{ //return ClsCommon.InactiveValue.ToString(); //} } else { return(ClsCommon.InactiveValue.ToString()); } //} //catch (Exception showError) //{ // throw showError; //} //finally //{ // cmd.Dispose(); // objCon.Con.Close(); // objCon.Con.Dispose(); //} } else { return("Not Valid"); } }