public int DALAdvertiseInsert(AdvertiseBLL ad) { using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"])) { try { SqlParameter[] par = new SqlParameter[10]; par[0] = new SqlParameter("@Name", ad.Name); par[1] = new SqlParameter("@ImageURL", ad.ImageURL); par[2] = new SqlParameter("@ValidFrom", ad.ValidFrom); par[3] = new SqlParameter("@ValidTo", ad.ValidTo); par[4] = new SqlParameter("@Active", ad.Active); par[5] = new SqlParameter("@AgentName", ad.AgentName); par[6] = new SqlParameter("@ModifierName", ad.ModifierName); par[7] = new SqlParameter("@AdvId", ad.AdvId); par[8] = new SqlParameter("Type", ad.Type); par[9] = new SqlParameter("@Status", 100); par[9].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spAdvertiseInsert", par); status = (int)par[9].Value; } catch (Exception ex) { throw ex; } finally { con.Close(); } } return(status); }
public List <AdvertiseBLL> GetAdvertiseInfo(AdvertiseBLL adv) { SqlDataReader dr; List <AdvertiseBLL> advlist = new List <AdvertiseBLL>(); using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { try { SqlParameter[] par = new SqlParameter[2]; par[0] = new SqlParameter("@AdvId", adv.AdvId); par[1] = new SqlParameter("@Status", 1); par[1].Direction = ParameterDirection.Output; dr = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "spSelectAddById", par); while (dr.Read()) { AdvertiseBLL ad = new AdvertiseBLL(); ad.AdvId = Convert.ToString(dr["AdvId"]); ad.Name = Convert.ToString(dr["Name"]); ad.ImageURL = Convert.ToString(dr["ImageURL"]); ad.ValidFrom = Convert.ToDateTime(dr["ValidFrom"]).ToString(); ad.ValidTo = Convert.ToString(dr["ValidTo"]); ad.Active = Convert.ToString(dr["Active"]); ad.maxId = Convert.ToInt32(dr["maxId"].ToString()); advlist.Add(ad); } } catch (SqlException ex) { throw ex; } finally { con.Close(); } } return(advlist); }
//public void getAddById(AdvertiseBLL ad) //{ // this.GetAddById = advDALObj.GetAdvertiseInfo(ad); //} public int BLLAdvertiseUpdate(AdvertiseBLL ad) { status = advDALObj.DALAdvertiseUpdate(ad); return(status); }
public int BLLAdvertiseInsert(AdvertiseBLL ad) { status = advDALObj.DALAdvertiseInsert(ad); return(status); }