public DataTable Check_Login(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[2];
prms[0] = new SqlParameter("@email", dm.Email);
prms[1] = new SqlParameter("@pass", dm.Pass);
return(sh.ExecuteDataSet("shop_user_check_login", prms));
}
public DataTable GetUserPass(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@email", dm.Email);
return(sh.ExecuteDataSet("shop_user_check", prms));
}
public DataTable Check_Pass_User(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[2];
prms[0] = new SqlParameter("@id", dm.Id);
prms[1] = new SqlParameter("@pass", dm.Pass);
return(sh.ExecuteDataSet("shop_user_pass_check", prms));
}
public void Update_User_Pass(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[2];
prms[0] = new SqlParameter("@id", dm.Id);
prms[1] = new SqlParameter("@pass", dm.Pass);
sh.ExecuteNonQuery("shop_user_pass_update", prms);
}
public bool CheckUserExist(Common.userDatum dm)
{
if (dl.CheckUserExist(dm).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void Update_User(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[15];
prms[0] = new SqlParameter("@name", dm.Name);
prms[1] = new SqlParameter("@family", dm.Family);
prms[2] = new SqlParameter("@how_find", dm.How_Find);
prms[3] = new SqlParameter("@id", dm.Id);
prms[4] = new SqlParameter("@mobile", dm.Mobile);
prms[5] = new SqlParameter("@tell", dm.Tell);
prms[6] = new SqlParameter("@company", dm.Company);
prms[7] = new SqlParameter("@address", dm.Address);
prms[8] = new SqlParameter("@country", dm.Country);
prms[9] = new SqlParameter("@province", dm.Province);
prms[10] = new SqlParameter("@city", dm.City);
prms[11] = new SqlParameter("@post_code", dm.Post_Code);
prms[12] = new SqlParameter("@recive_news", dm.Recive_News);
prms[13] = new SqlParameter("@recive_news", dm.Email);
prms[13] = new SqlParameter("@Email", dm.Email);
prms[14] = new SqlParameter("@Pass", dm.Pass);
sh.ExecuteNonQuery("shop_user_update", prms);
}
public decimal Insert(Common.userDatum dm, string RegDate)
{
var prms = new SqlParameter[]
{
new SqlParameter("@name", dm.Name),
new SqlParameter("@family", dm.Family),
new SqlParameter("@email", dm.Email),
new SqlParameter("@pass", dm.Pass),
new SqlParameter("@mobile", dm.Mobile),
new SqlParameter("@tell", dm.Tell),
new SqlParameter("@company", dm.Company),
new SqlParameter("@address", dm.Address),
new SqlParameter("@country", dm.Country),
new SqlParameter("@province", dm.Province),
new SqlParameter("@city", dm.City),
new SqlParameter("@post_code", dm.Post_Code),
new SqlParameter("@recive_news", dm.Recive_News),
new SqlParameter("@how_find", dm.How_Find),
// new SqlParameter("@date_register", RegDate)
};
return(sh.ExecuteNonQueryIdentity("shop_user_insert", prms, "id_user"));
}
public void Delete(Common.userDatum dm)
{
dl.Delete(dm);
}
public DataTable Check_Pass_User(Common.userDatum dm)
{
return(dl.Check_Pass_User(dm));
}
public DataTable GetUserPass(Common.userDatum dm)
{
return(dl.GetUserPass(dm));
}
public void Update_User_Pass(Common.userDatum dm)
{
dl.Update_User_Pass(dm);
}
public void Delete(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id", dm.Id);
sh.ExecuteNonQuery("shop_user_Delete", prms);
}
public DataTable Select_All(Common.userDatum dm)
{
return(dl.Select_All(dm));
}
public DataTable select_one_user(Common.userDatum dm)
{
return(dl.select_one_user(dm));
}
public DataTable Select_All(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[0];
return(sh.ExecuteDataSet("shop_user_Select_All", prms));
}
/// <summary>
/// Filter User
/// </summary>
/// <param name="dm">Send Parameters</param>
public DataTable Find_All(Common.userDatum dm)
{
DataTable tb;
DataTable res = new DataTable();
tb = dl.Select_All(new Common.userDatum());
foreach (DataColumn dc in tb.Columns)
{
res.Columns.Add(dc.ColumnName, dc.DataType);
}
foreach (DataRow dr in tb.Rows)
{
if (dm.City != "")
{
if (!dr["city"].ToString().Contains(dm.City))
{
continue;
}
}
if (dm.Country != "")
{
if (!dr["country"].ToString().Contains(dm.Country))
{
continue;
}
}
if (dm.Email != "")
{
if (!dr["email"].ToString().Contains(dm.Email))
{
continue;
}
}
if (dm.Family != "")
{
if (!dr["family"].ToString().Contains(dm.Family))
{
continue;
}
}
if (dm.How_Find != "гДйнгх ≤ДМо...")
{
if (dr["how_find"].ToString() != dm.How_Find)
{
continue;
}
}
if (dm.Mobile != "")
{
if (!dr["mobile"].ToString().StartsWith(dm.Mobile))
{
continue;
}
}
if (dm.Tell != "")
{
if (!dr["tell"].ToString().StartsWith(dm.Tell))
{
continue;
}
}
if (dm.Post_Code != "")
{
if (!dr["post_code"].ToString().StartsWith(dm.Post_Code))
{
continue;
}
}
if (dm.Name != "")
{
if (!dr["name"].ToString().Contains(dm.Name))
{
continue;
}
}
if (dm.Province != "гДйнгх ≤ДМо...")
{
if (dr["province"].ToString() != dm.Province)
{
continue;
}
}
res.Rows.Add(dr.ItemArray);
}
return(res);
}
public DataTable select_one_user(Common.userDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id", dm.Id);
return(sh.ExecuteDataSet("shop_user_select_one", prms));
}
public decimal Insert(Common.userDatum dm)
{
return(dl.Insert(dm, new PublicClass().GetDate()));
}
public DataTable Check_Login(Common.userDatum dm)
{
return(dl.Check_Login(dm));
}
