//sudha created on 19/12
public DataSet GetAllUsers()
{
CmdCAP = new SqlCommand();
DsCAP = CommonDbFunctions.FillDataSet("spGetAllUsersList", CmdCAP);
return(DsCAP);
}
/*public DataSet Login(User user)
* {
* SqlDataAdapter da;
* DataSet ds = new DataSet();
*
* SqlCommand sqlcommand = new SqlCommand();
*
* SqlParameter[] param = new SqlParameter[2];
* param[0] = new SqlParameter("@Email", user.Email);
* param[1] = new SqlParameter("@Password", user.Password);
*
* sqlcommand = new SqlCommand("spCheckUserLoginDetails", OpenConnection())
* {
* CommandType = CommandType.StoredProcedure
* };
* sqlcommand.Parameters.AddRange(param);
*
* try
* {
* da = new SqlDataAdapter(sqlcommand);
* da.Fill(ds);
*
* }
* catch (SqlException ex)
* {
* //handel sql excepetions
* Console.WriteLine(ex.Message + " in UserDb StoreUser()");
* }
* catch (Exception ex)
* {
* //handel exceptions
* Console.WriteLine(ex.Message + " in UserDb StoreUser()");
* }
* finally
* {
* CloseConnection();
* }
* return ds;
* }*/
public DataSet Login(User user)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Email) ? SqlString.Null : user.Email));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Password", SqlDbType.VarChar, 100, string.IsNullOrEmpty(user.Password) ? SqlString.Null : user.Password));
DsCAP = CommonDbFunctions.FillDataSet("spCheckUserLoginDetails", CmdCAP);
return(DsCAP);
}
public DataSet GeyAllProducts_Category_SubcategoryList()
{
CmdCAP = new SqlCommand();
DsCAP = CommonDbFunctions.FillDataSet("spGeyAllProducts_Category_SubcategoryList", CmdCAP);
return(DsCAP);
}
public DataSet GetListItems(int id)
{
CmdCAP = new SqlCommand();
//@prod_subcat_id
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("GetKurtasData", CmdCAP);
return(DsCAP);
}
public DataSet GetItemsBySearchnames(string searchname)
{
CmdCAP = new SqlCommand();
//@prod_subcat_id
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@name", SqlDbType.VarChar, 100, searchname));
DsCAP = CommonDbFunctions.FillDataSet("GetItemsBasedsearch", CmdCAP);
return(DsCAP);
}
public DataSet GeyAllOrdersDetails()
{
CmdCAP = new SqlCommand();
DsCAP = CommonDbFunctions.FillDataSet("spGeyAllOrderDetails", CmdCAP);
return(DsCAP);
}
public List <User> getvendoritemdetials(int vid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid));
DsCAP = CommonDbFunctions.FillDataSet("sp_vendoritemdetials", CmdCAP);
return(CommonDbFunctions.ConvertDStolist(DsCAP));
}
public DataSet GetItemDetails(int id)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@itm_id", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("GetItemDetails", CmdCAP);
return(DsCAP);
}
public List <Vitem> getvendorwiseitems(int vid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@vid", SqlDbType.Int, 100, vid));
DsCAP = CommonDbFunctions.FillDataSet("sp_vendortotitems", CmdCAP);
return(CommonDbFunctions.convertitemstolist(DsCAP));
}
/*------------------------------------whish list------------------------------------------------------*/
public DataSet GetDataFromWhishList(int uid)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, uid));
DsCAP = CommonDbFunctions.FillDataSet("GetWhishListData", CmdCAP);
return(DsCAP);
}
/*------------------------------------bag------------------------------------------------------*/
public DataSet GetUserBagDetailsById(int id)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("GetUserBagDetials", CmdCAP);
return(DsCAP);
}
//sudha created on 02/01
public DataSet GetAllVendorsByActiveStatus(int IsActive)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@IsActive", SqlDbType.Int, 0, IsActive));
DsCAP = CommonDbFunctions.FillDataSet("spGetAllVendorsByActiveStatus", CmdCAP);
return(DsCAP);
}
public List <AddressModel> GetUserAddressDataById(int id)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("GetAddressDetails", CmdCAP);
return(CommonDbFunctions.ConvertAddressDStoBO(DsCAP));
}
public User GetUserDataById(int id)
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@UID", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("spGetAllUserDetailsByID", CmdCAP);
return(CommonDbFunctions.ConvertDStoBO(DsCAP));
}
public DataSet GetAllProdcutswithCatg()
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
DsCAP = CommonDbFunctions.FillDataSet("GetAllProductsDataWithCategory", CmdCAP);
return(DsCAP);
}
public DataSet GetAllBrandsData()
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
DsCAP = CommonDbFunctions.FillDataSet("GetAllBrandsData", CmdCAP);
return(DsCAP);
}
/*===============================================================products===================================================================================*/
public DataSet GetAllProdcutswithsubCatg(int id)
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@pid", SqlDbType.Int, 100, id));
DsCAP = CommonDbFunctions.FillDataSet("GetAllSubCatgProductDetails", CmdCAP);
return(DsCAP);
}
public DataSet GetBrandsDataById(string name)
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Bname", SqlDbType.VarChar, 150, name));
DsCAP = CommonDbFunctions.FillDataSet("GetProductsDataByBrands", CmdCAP);
return(DsCAP);
}
/*==================================================Filters=================================================================*/
public DataSet GetItemsByFilters(FiltersModel item)
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Bname", SqlDbType.VarChar, 150, item.bname));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@minprice", SqlDbType.Int, 150, item.minprice));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@maxprice", SqlDbType.Int, 150, item.maxprice));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@type", SqlDbType.Int, 150, item.type));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 150, item.prod_subcat_id));
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@name", SqlDbType.VarChar, 150, item.name));
DsCAP = CommonDbFunctions.FillDataSet("FilterItems", CmdCAP);
return(DsCAP);
}
public string DeleteProductByAdmin(int PID)
{
try
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PID", SqlDbType.Int, 0, PID));
DsCAP = CommonDbFunctions.FillDataSet("spDeleteProductByAdmin", CmdCAP);
ErrorMessage = "";
}
catch (Exception ex)
{
ErrorMessage = ex.Message;
Console.WriteLine(ex.Message);
}
return(ErrorMessage);
}
public string DeleteSubCategoryByAdmin(int prod_subcat_id)
{
try
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@prod_subcat_id", SqlDbType.Int, 0, prod_subcat_id));
DsCAP = CommonDbFunctions.FillDataSet("spDeleteSubCategoryByAdmin", CmdCAP);
ErrorMessage = "";
}
catch (Exception ex)
{
ErrorMessage = ex.Message;
Console.WriteLine(ex.Message);
}
return(ErrorMessage);
}
public string ChangeProductStatusByAdmin(string strPIDS)
{
try
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PID", SqlDbType.VarChar, 100, string.IsNullOrEmpty(strPIDS) ? SqlString.Null : strPIDS));
DsCAP = CommonDbFunctions.FillDataSet("spChangeProductStatusByAdmin", CmdCAP);
ErrorMessage = "";
}
catch (Exception ex)
{
ErrorMessage = ex.Message;
Console.WriteLine(ex.Message);
}
return(ErrorMessage);
}
//sudha created on 28/12
public bool CheckEmail(string strEmail)
{
Boolean res = false;
try
{
CmdCAP = new SqlCommand();
AddParameter("@Email", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strEmail) ? SqlString.Null : strEmail);
DsCAP = CommonDbFunctions.FillDataSet("spCheckEmail", CmdCAP);
if (DsCAP.Tables[0].Rows.Count > 0)
{
res = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(res);
}
public int CheckMailForExistVendor(string strEmail)
{
int vid = 0;
try
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@Email", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strEmail) ? SqlString.Null : strEmail));
DsCAP = CommonDbFunctions.FillDataSet("spCheckEmail", CmdCAP);
if (DsCAP.Tables[0].Rows.Count >= 0)
{
vid = Convert.ToInt32(DsCAP.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(vid);
}
public int CheckProductNameIsExist(string strPName)
{
int pid = 0;
try
{
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@PName", SqlDbType.VarChar, 50, string.IsNullOrEmpty(strPName) ? SqlString.Null : strPName));
DsCAP = CommonDbFunctions.FillDataSet("spCheckPName", CmdCAP);
if (DsCAP.Tables[0].Rows.Count >= 0)
{
pid = Convert.ToInt32(DsCAP.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(pid);
}
public DataSet GetOrdersData(int uid)
{
// string itm_ids = "";
CmdCAP = new SqlCommand();
CmdCAP.Parameters.Add(CommonDbFunctions.AddParameter("@uid", SqlDbType.Int, 100, uid));
DsCAP = CommonDbFunctions.FillDataSet("GetOrdersdatabyuid", CmdCAP);
//if(DsCAP.Tables[0].Rows.Count>0)
//{
// foreach(DataRow row in DsCAP.Tables[0].Rows)
// {
// itm_ids = row["itm_id"].ToString();
// aid =Convert.ToInt32(row["Address"].ToString());
// }
//}
return(DsCAP);
}
public DataSet GetListItemsDataByPassing_Ids(List <int> list)
{
CmdCAP = new SqlCommand();
string str = db.Sconnection();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("n", typeof(Int32)));
foreach (int num in list)
{
dt.Rows.Add(num);
}
//using (SqlConnection con = new SqlConnection(str))
//{
// SqlCommand sqlcom = new SqlCommand("GetItemsByPassing_IDS", con);
// sqlcom.CommandType = CommandType.StoredProcedure;
// sqlcom.Parameters.AddWithValue("@@proids", dt);
// con.Open();
// DsCAP = CommonDbFunctions.FillDataSet("GetItemsByPassing_IDS", CmdCAP);
// return DsCAP;
//}
CmdCAP.Parameters.AddWithValue("@proids", dt);
DsCAP = CommonDbFunctions.FillDataSet("GetItemsByPassing_IDS", CmdCAP);
return(DsCAP);
}
