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