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