public DataTable SelectCategoryGroup() { DALComponent dalComponent = new DALComponent(); dalComponent.SqlCommandText = "SelectCategoryGroup"; return(dalComponent.SelectRecord()); }
public DataTable SelectCity() { DALComponent dalCom = new DALComponent(); dalCom.SqlCommandText = "SelectCity"; return(dalCom.SelectRecord()); }
public DataTable SelectChargeDetails() { DALComponent dalComponent = new DALComponent(); dalComponent.SqlCommandText = "[SelectChargeDetails]"; return(dalComponent.SelectRecord()); }
public DataTable SelectUserAds(int userId) { dalComponent = new DALComponent(); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SqlCommandText = "[SelectUserAds]"; return(dalComponent.SelectRecord()); }
public DataTable SelectReportsByCity(string cityname) { dalComponent = new DALComponent(); dalComponent.SetParameters("@cityname", SqlDbType.VarChar, 50, cityname); dalComponent.SqlCommandText = "[SelectReportsByCity]"; return(dalComponent.SelectRecord()); }
public void CreateAdImageDetails(int imageId, int adpostId, string imagePath, string videoLink) { try { dalComponent = new DALComponent(); dalComponent.SetParameters("@imageId", SqlDbType.Int, 4, imageId); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@imagePath", SqlDbType.VarChar, 1000, imagePath); dalComponent.SetParameters("@videoLink", SqlDbType.VarChar, 1000, videoLink); dalComponent.SetParameters("@idvalue", SqlDbType.Int, true); dalComponent.SqlCommandText = "CreateAdImageDetails"; int x = dalComponent.CreateRecord(); object y = dalComponent.GetParameters("@idvalue"); //int adpost_id = Int32.Parse(y.ToString()); //if (imageId != 0) // return imageId; //else // return Int32.Parse(y.ToString()); } catch (Exception ex) { throw; } }
public void CreateBuyDetails(int adpostId, int historyId, int userId, decimal totalprice, int delitype, int cityId, string currentstatus, int viewcount, string chargeName, int chargeType, double chargeAmount) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@historyId", SqlDbType.Int, 4, historyId); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SetParameters("@totalprice", SqlDbType.Decimal, 9, totalprice); dalComponent.SetParameters("@delitype", SqlDbType.Int, 4, delitype); dalComponent.SetParameters("@cityId", SqlDbType.Int, 4, cityId); dalComponent.SetParameters("@currentstatus", SqlDbType.VarChar, 50, currentstatus); dalComponent.SetParameters("@viewcount", SqlDbType.Int, 4, viewcount); dalComponent.SetParameters("@chargeName", SqlDbType.VarChar, 50, chargeName); dalComponent.SetParameters("@chargeType", SqlDbType.Int, 4, chargeType); dalComponent.SetParameters("@chargeAmount", SqlDbType.Float, 9, chargeAmount); dalComponent.SetParameters("@idvalue", SqlDbType.Int, true); dalComponent.SqlCommandText = "[CreateBuyDetails]"; int x = dalComponent.CreateRecord(); object y = dalComponent.GetParameters("@idvalue"); } catch (Exception ex) { throw; } }
public DataTable SelectMaxID() { DALComponent dalComponent = new DALComponent(); dalComponent.SqlCommandText = "SelectMaxID"; return(dalComponent.SelectRecord()); }
public DataTable SelectCityById(int cityid) { DALComponent dalCom = new DALComponent(); dalCom.SetParameters("@cityid", SqlDbType.Int, 4, cityid); dalCom.SqlCommandText = "[SelectCityById]"; return(dalCom.SelectRecord()); }
public DataTable SelectCityByName(string cityname) { DALComponent dalCom = new DALComponent(); dalCom.SetParameters("@cityname", SqlDbType.VarChar, 50, cityname); dalCom.SqlCommandText = "[SelectCityByName]"; return(dalCom.SelectRecord()); }
public DataTable GetAdDetails(int adpostId, int userId) { dalComponent = new DALComponent(); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SqlCommandText = "[GetAdDetails]"; return(dalComponent.SelectRecord()); }
public DataTable SelectReportsByDate(DateTime FromDate, DateTime ToDate) { dalComponent = new DALComponent(); dalComponent.SetParameters("@fromdate", SqlDbType.SmallDateTime, 4, FromDate); dalComponent.SetParameters("@todate", SqlDbType.SmallDateTime, 4, ToDate); dalComponent.SqlCommandText = "[SelectReportsByDate]"; return(dalComponent.SelectRecord()); }
public DataTable SelectChargeDetailsByID(int chargeId) { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@chargeId", SqlDbType.Int, 4, chargeId); dalComponent.SqlCommandText = "[SelectChargeDetailsByID]"; return(dalComponent.SelectRecord()); }
public void AdPostDeleteById(int adpostId) { try { dalComponent = new DALComponent(); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SqlCommandText = "AdPostDeleteById"; int x = dalComponent.DeleteRecord(); } catch (Exception) { throw; } }
public DataTable SearchUsers(string Keyword) { try { dalComponent = new DALComponent(); dalComponent.SetParameters("@Keyword", SqlDbType.VarChar, 200, Keyword); dalComponent.SqlCommandText = "SearchUsers"; return(dalComponent.SelectRecord()); } catch (Exception ex) { throw; } }
public DataTable AvailableCategoryGroup(string groupName) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@groupname", SqlDbType.VarChar, 50, groupName); dalComponent.SqlCommandText = "[AvailableCategoryGroup]"; return(dalComponent.SelectRecord()); } catch (Exception ex) { throw; } }
public void ChargeDetailsDelete(int chargeId) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@chargeId", SqlDbType.Int, 4, chargeId); dalComponent.SqlCommandText = "[ChargeDetailsDelete]"; int x = dalComponent.DeleteRecord(); } catch (Exception) { throw; } }
public void CategoryGroupDelete(int catid) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@categoryGroupId", SqlDbType.Int, 4, catid); dalComponent.SqlCommandText = "CategoryGroupDelete"; int x = dalComponent.DeleteRecord(); } catch (Exception) { throw; } }
public void UpdateCartStatus(int adpostId, int userid) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@adpostid", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@userid", SqlDbType.Int, 4, userid); dalComponent.SqlCommandText = "[UpdateCartStatus]"; int x = dalComponent.CreateRecord(); } catch (Exception ex) { throw; } }
public int CategoryGroupUpdate(int catid, string catname) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@categoryGroupId", SqlDbType.Int, 4, catid); dalComponent.SetParameters("@categoryGroupName", SqlDbType.VarChar, 100, catname); dalComponent.SqlCommandText = "CategoryGroupUpdate"; int x = dalComponent.CreateRecord(); return(x); } catch (Exception) { throw; } return(0); }
public void CreateUserCart(int cartId, int userId, int adpostId) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@cartId", SqlDbType.Int, 4, cartId); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@idvalue", SqlDbType.Int, true); dalComponent.SqlCommandText = "CreateUserCart"; int x = dalComponent.CreateRecord(); object y = dalComponent.GetParameters("@idvalue"); } catch (Exception ex) { throw; } }
public int CreateAdPost(int adpostId, string adpostTitle, string description, string keywords, int userId, int categoryId, decimal price, int stateId, int cityId, int countryId, string zipCode, DateTime adtillDate, string adStatus, int paidStatus) { try { dalComponent = new DALComponent(); dalComponent.SetParameters("@adpostId", SqlDbType.Int, 4, adpostId); dalComponent.SetParameters("@adpostTitle", SqlDbType.VarChar, 500, adpostTitle); dalComponent.SetParameters("@description", SqlDbType.VarChar, 1000, description); dalComponent.SetParameters("@keywords", SqlDbType.VarChar, 1000, keywords); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SetParameters("@categoryId", SqlDbType.Int, 4, categoryId); dalComponent.SetParameters("@price", SqlDbType.Decimal, 9, price); dalComponent.SetParameters("@stateId", SqlDbType.Int, 4, stateId); dalComponent.SetParameters("@cityId", SqlDbType.Int, 4, cityId); dalComponent.SetParameters("@countryId", SqlDbType.Int, 4, countryId); dalComponent.SetParameters("@zipCode", SqlDbType.VarChar, 50, zipCode); dalComponent.SetParameters("@adtillDate", SqlDbType.SmallDateTime, 4, adtillDate); dalComponent.SetParameters("@adStatus", SqlDbType.VarChar, 50, adStatus); dalComponent.SetParameters("@paidStatus", SqlDbType.Int, 4, paidStatus); dalComponent.SetParameters("@idvalue", SqlDbType.Int, true); dalComponent.SqlCommandText = "CreateAdPost"; int x = dalComponent.CreateRecord(); object y = dalComponent.GetParameters("@idvalue"); if (adpostId != 0) { return(adpostId); } else { return(Int32.Parse(y.ToString())); } } catch (Exception ex) { throw; } }
public int CreateChargeDetails(int chargeId, int userId, string chargeName, int chargeType, double amtorpercent) { try { DALComponent dalComponent = new DALComponent(); dalComponent.SetParameters("@userId", SqlDbType.Int, 4, userId); dalComponent.SetParameters("@chargeId", SqlDbType.Int, 4, chargeId); dalComponent.SetParameters("@chargeName", SqlDbType.VarChar, 50, chargeName); dalComponent.SetParameters("@chargeType", SqlDbType.Int, 4, chargeType); dalComponent.SetParameters("@amtorpercent", SqlDbType.Float, 18, amtorpercent); dalComponent.SetParameters("@idvalue", SqlDbType.Int, true); dalComponent.SqlCommandText = "[CreateChargeDetails]"; int x = dalComponent.CreateRecord(); return(x); } catch (Exception) { throw; } return(0); }
public DataTable GetAllAdDetails() { dalComponent = new DALComponent(); dalComponent.SqlCommandText = "[GetAllAdDetails]"; return(dalComponent.SelectRecord()); }
public UserInfoBll() { dalComponent = new DALComponent(); }
public AdDetailsBll() { dalComponent = new DALComponent(); }