/// <summary> /// /// </summary> /// <param name="PassWord"> </param> /// <param name="GUID"> </param> /// <param name="PwdChgDate"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <returns></returns> public static int UpdateUserPw(string PassWord, string GUID, DateTime PwdChgDate, string UpdateUser, DateTime UpdateDate) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@PassWord", DBTypeConverter.ConvertCsTypeToOriginDBType(PassWord.GetType().ToString()), PassWord, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@PwdChgDate", DBTypeConverter.ConvertCsTypeToOriginDBType(PwdChgDate.GetType().ToString()), PwdChgDate, 0), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_UpdatePw", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="MenuName"> </param> /// <param name="MenuUrl"> </param> /// <param name="MenuDescription"> </param> /// <param name="ParentID"> </param> /// <returns></returns> public static int AddMenu(string MenuName, string MenuUrl, string MenuDescription, int ParentID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@MenuName", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuName.GetType().ToString()), MenuName, 50), dbFactory.MakeInParam("@MenuUrl", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuUrl.GetType().ToString()), MenuUrl, 0), dbFactory.MakeInParam("@MenuDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuDescription.GetType().ToString()), MenuDescription, 50), dbFactory.MakeInParam("@ParentID", DBTypeConverter.ConvertCsTypeToOriginDBType(ParentID.GetType().ToString()), ParentID, 32), dbFactory.MakeOutReturnParam() }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Menu_Add", prams); iReturn = int.Parse(prams[4].Value.ToString()); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <param name="RoleName"> </param> /// <param name="RoleDescription"> </param> /// <returns></returns> public static int UpdateRole(int RoleID, string RoleName, string RoleDescription) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32), dbFactory.MakeInParam("@RoleName", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleName.GetType().ToString()), RoleName, 50), dbFactory.MakeInParam("@RoleDescription", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleDescription.GetType().ToString()), RoleDescription, 100) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Role_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
/// <summary> /// /// </summary> /// <param name="UserName"> </param> /// <param name="GUID"> </param> /// <param name="AreaCode"> </param> /// <param name="AreaInCharge"> </param> /// <param name="RealName"> </param> /// <param name="UpdateUser"> </param> /// <param name="UpdateDate"> </param> /// <param name="IsStop"> </param> /// <returns></returns> public static int UpdateUser(string UserName, string GUID, string AreaCode, string AreaInCharge, string RealName, string UpdateUser, DateTime UpdateDate, bool IsStop) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@UserName", DBTypeConverter.ConvertCsTypeToOriginDBType(UserName.GetType().ToString()), UserName, 50), dbFactory.MakeInParam("@GUID", DBTypeConverter.ConvertCsTypeToOriginDBType(GUID.GetType().ToString()), GUID, 100), dbFactory.MakeInParam("@AreaCode", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaCode.GetType().ToString()), AreaCode, 20), dbFactory.MakeInParam("@AreaInCharge", DBTypeConverter.ConvertCsTypeToOriginDBType(AreaInCharge.GetType().ToString()), AreaInCharge, 100), dbFactory.MakeInParam("@RealName", DBTypeConverter.ConvertCsTypeToOriginDBType(RealName.GetType().ToString()), RealName, 20), dbFactory.MakeInParam("@UpdateUser", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateUser.GetType().ToString()), UpdateUser, 50), dbFactory.MakeInParam("@UpdateDate", DBTypeConverter.ConvertCsTypeToOriginDBType(UpdateDate.GetType().ToString()), UpdateDate, 0), dbFactory.MakeInParam("@IsStop", DBTypeConverter.ConvertCsTypeToOriginDBType(IsStop.GetType().ToString()), IsStop, 4) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_User_Update", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public string saveChange() { DataBase db = new DataBase(); string sql = "update CustomersTable set FullName = '" + this.Name + "' , Address = '" + this.Address + "', City = " + this.City + " , id = '" + this.Id + "' , BirthDay = '" + this.BirthDay + "' , LicenseNumber = '" + this.LicenseNumber + "' , LicenseLevel = " + this.LicenseLevel + " , LicenseProductionDate = '" + this.DateOfIssuanceLicense + "' , Phone = '" + this.Phone + "' where CustomId = " + this.UserId; int success = db.ExecuteNonQuery(sql); if (success > 0) { return("success"); } else { return("error"); } }
public person RegUser(string TxtName, string TxtAddress, int TxtCity, string TxtId, string TxtDateOfBirth, string TxtLicenseNumber, int DdlLicensCode, string TxtDateOfIssuanceLicense, string Email, string Password, string Phone, string Temporary) { DataBase db = new DataBase(); person per = new person(); string sql = "insert into CustomersTable (FullName,Address,City,id,BirthDay,LicenseNumber,LicenseLevel,LicenseProductionDate,Email,Password,Phone,ForgetPass) values ('" + TxtName + "','" + TxtAddress + "','" + TxtCity + "','" + TxtId + "','" + TxtDateOfBirth + "','" + TxtLicenseNumber + "','" + DdlLicensCode + "','" + TxtDateOfIssuanceLicense + "','" + Email + "','" + Password + "','" + Phone + "','" + Temporary + "')"; int RecCount = db.ExecuteNonQuery(sql); if (RecCount != 0) { sql = "select CustomId,FullName,Email from CustomersTable where Email = '" + Email + "'"; DataTable dt = db.ExecuteReader(sql); per.CustomId = (int)dt.Rows[0]["CustomId"]; per.FullName = dt.Rows[0]["FullName"].ToString(); per.Email = dt.Rows[0]["Email"].ToString(); per.IdNumber = TxtId; per.LiccensNumber = TxtLicenseNumber; per.TelNumber = Phone; per.PhoneNumber = Phone; } return(per); }
/// <summary> /// /// </summary> /// <param name="MenuID"> </param> /// <returns></returns> public static int DeleteMenu(int MenuID) { int iReturn = 0; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@MenuID", DBTypeConverter.ConvertCsTypeToOriginDBType(MenuID.GetType().ToString()), MenuID, 32) }; iReturn = db.ExecuteNonQuery(dbFactory.GetConnection(Config.con), true, CommandType.StoredProcedure, "proc_Menu_Delete", prams); } catch (Exception ex) { } finally { db.Conn.Close(); } return(iReturn); }
public person Login() { string sql = "select * from CustomersTable where Email = '" + this.Email + "' and Password = '******'"; DataBase db = new DataBase(); DataTable dt = db.ExecuteReader(sql); person per = null; if (dt.Rows.Count > 0) { sql = "select numberIncorrects from CustomersTable where Email = '" + this.Email + "'"; string ret = db.ExecuteScalar(sql); if (int.Parse(ret) > 3) { per = new person() { CustomId = -4 }; return(per); } per = new person((int)dt.Rows[0]["CustomId"], dt.Rows[0]["FullName"].ToString(), dt.Rows[0]["Email"].ToString()); per.CustomId = (int)dt.Rows[0]["CustomId"]; per.IdNumber = dt.Rows[0]["id"].ToString(); per.FullName = dt.Rows[0]["FullName"].ToString(); per.LiccensNumber = dt.Rows[0]["LicenseNumber"].ToString(); per.TelNumber = dt.Rows[0]["Phone"].ToString(); per.PhoneNumber = dt.Rows[0]["Phone"].ToString(); per.role = int.Parse(dt.Rows[0]["role"].ToString()); } else { sql = "select Email from CustomersTable where Email = '" + this.Email + "'"; string ret = db.ExecuteScalar(sql); if (ret != null && ret != "a") { sql = "select numberIncorrects from CustomersTable where Email = '" + this.Email + "'"; ret = db.ExecuteScalar(sql); if (int.Parse(ret) < 4) { sql = "update CustomersTable set numberIncorrects = numberIncorrects + 1 where Email = '" + this.Email + "'"; db.ExecuteNonQuery(sql); per = new person() { CustomId = -2 }; } else { per = new person() { CustomId = -4 }; } } else { per = new person() { CustomId = -3 }; } } return(per); }
public void releaseUser(int id) { DataBase db = new DataBase(); string sql = "update CustomersTable set numberIncorrects = 0 where CustomId = " + id; int success = db.ExecuteNonQuery(sql); }