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