public List <ProductHosting> getCPHostingPriceList(int cPId, string categeory) { SqlCommand dinsert = new SqlCommand("usp_GetCPCHostingPriceList"); dinsert.Parameters.AddWithValue("@CustId", SqlDbType.Int).Value = cPId; dinsert.Parameters.AddWithValue("@Cat", SqlDbType.VarChar).Value = categeory; DataSet dtList = objcon.GetDsByCommand(dinsert); List <ProductHosting> list1 = new List <ProductHosting>(); foreach (DataRow dr in dtList.Tables[0].Rows) { ProductHosting pd = new ProductHosting(); // BankDetails list1 = new BankDetails(); pd.HostintProductId = Convert.ToInt32(dr["HostintProductId"].ToString()); //pd.ProductCatId = Convert.ToInt32(dr["ProductCatId"].ToString()); //pd.HostingCatId = Convert.ToInt32(dr["HostingCatId"].ToString()); //pd.HostingSubCatId = Convert.ToInt32(dr["HostingSubCatId"].ToString()); pd.ProductName = dr["ProductName"].ToString(); pd.Price = dr["Price"].ToString(); // pd.ProductCatId = Convert.ToInt32(dr["ProductCatId"].ToString()); pd.DomainSize = dr["DomainSize"].ToString(); pd.SSDDiskSapce = dr["SSDDiskSapce"].ToString(); pd.TransferSize = dr["TransferSize"].ToString(); pd.EmailAccount = (dr["EmailAccount"].ToString()); pd.DatabaseSize = (dr["DatabaseSize"].ToString()); pd.SSL = (dr["SSL"].ToString()); //pd.HostingCat = (dr["HostingCat"].ToString()); //pd.HostingSubCat = (dr["HostingSubCat"].ToString()); pd.CostPrice = (dr["CostPrise"].ToString()); pd.SellingPrice = (dr["SellingPrise"].ToString()); pd.ProductImage = (dr["ProductImage"].ToString()); list1.Add(pd); } return(list1); }
public List <ProductHosting> getDedicatedHostingHomepageSlider(int cPId) { SqlCommand dinsert = new SqlCommand("usp_GetDedicateHostingForHomePage"); dinsert.Parameters.AddWithValue("@CustId", SqlDbType.Int).Value = cPId; DataSet dtList = objcon.GetDsByCommand(dinsert); List <ProductHosting> list1 = new List <ProductHosting>(); foreach (DataRow dr in dtList.Tables[0].Rows) { ProductHosting pd = new ProductHosting(); pd.ProductName = dr["ProductName"].ToString(); pd.Price = dr["Price"].ToString(); pd.DomainSize = dr["DomainSize"].ToString(); pd.TransferSize = dr["TransferSize"].ToString(); pd.EmailAccount = dr["EmailAccount"].ToString(); pd.DatabaseSize = dr["DatabaseSize"].ToString(); //pd.RegistrartionPrice = dr["RegistrartionPrice"].ToString(); list1.Add(pd); } return(list1); }
public List <ProductHosting> getResellarLinuxHosting(int cPId) { SqlCommand dinsert = new SqlCommand("usp_ResellarLinuxHosting"); dinsert.Parameters.AddWithValue("@CustId", SqlDbType.Int).Value = cPId; DataSet dtList = objcon.GetDsByCommand(dinsert); List <ProductHosting> list1 = new List <ProductHosting>(); foreach (DataRow dr in dtList.Tables[0].Rows) { ProductHosting pd = new ProductHosting(); pd.HostintProductId = Convert.ToInt32(dr["HostintProductId"].ToString()); pd.ProductName = dr["ProductName"].ToString(); pd.Price = dr["Price"].ToString(); pd.DomainSize = dr["DomainSize"].ToString(); pd.TransferSize = dr["TransferSize"].ToString(); pd.EmailAccount = dr["EmailAccount"].ToString(); pd.DatabaseSize = dr["DatabaseSize"].ToString(); //pd.RegistrartionPrice = dr["RegistrartionPrice"].ToString(); list1.Add(pd); } return(list1); }