//public string SaveUserHandling(UserHandlingType _SaveData)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// int SysID = MYCommon.GetSysID("tblusernamepassword", null);
// string sqlQuery = "Insert Into tblusernamepassword ("
// + "SysID,"
// + "UserName,"
// + "UPassword,"
// + "GroupID,"
// + "CurrentStatus,"
// + "CreateDate,"
// + "DepID,"
// + "Status)"
// + " Values ("
// + "@SysID,"
// + "@UserName,"
// + "@UPassword,"
// + "@GroupID,"
// + "@CurrentStatus,"
// + "CurDate(),"
// + "@DepID,"
// + "@Status)";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@SysID", SysID);
// oSqlCommand.Parameters.AddWithValue("@UserName", _SaveData.UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", _SaveData.UPassword);
// oSqlCommand.Parameters.AddWithValue("@GroupID", _SaveData.GroupID);
// oSqlCommand.Parameters.AddWithValue("@CurrentStatus", _SaveData.CurrentStatus);
// oSqlCommand.Parameters.AddWithValue("@DepID", _SaveData.DepID);
// oSqlCommand.Parameters.AddWithValue("@Status", _SaveData.Status);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Save UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public string UpdateUserHandling(UserHandlingType _Update)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Update tblusernamepassword Set "
// + "SysID=@SysID,"
// + "UserName=@UserName,"
// + "UPassword=@UPassword,"
// + "GroupID=@GroupID,"
// + "CurrentStatus=@CurrentStatus,"
// + "CreateDate=CurDate(),"
// + "DepID=@DepID,"
// + "Status=@Status"
// + "Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@SysID", _Update.SysID);
// oSqlCommand.Parameters.AddWithValue("@UserName", _Update.UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", _Update.UPassword);
// oSqlCommand.Parameters.AddWithValue("@GroupID", _Update.GroupID);
// oSqlCommand.Parameters.AddWithValue("@CurrentStatus", _Update.CurrentStatus);
// oSqlCommand.Parameters.AddWithValue("@DepID", _Update.DepID);
// oSqlCommand.Parameters.AddWithValue("@Status", _Update.Status);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Update on web UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public string DeleteUserHandling(string UserName, string UPassword)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Delete from tblusernamepassword"
// + " Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Delete UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public bool ExistUserHandling(string UserName, string UPassword)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Select SysID from tblusernamepassword"
// + " Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
// bool respond = MYCommon.ExistIntableOnWeb(sqlQuery, oSqlCommand);
// return respond;
// }
// catch (Exception ex)
// {
// return false;
// }
//}
public string GetExistUserHandling(string UserName, string UPassword, out UserHandlingType _ExistData)
{
_ExistData = new UserHandlingType();
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Select "
+ "SysID,"
+ "UserName,"
+ "UPassword,"
+ "GroupID,"
+ "CurrentStatus,"
+ "CreateDate,"
+ "DepID,"
+ "Status"
+ " from tblusernamepassword"
+ " Where 1=1 "
+ " and UserName=@UserName"
+ " and UPassword=@UPassword";
oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
DataRow r = MYCommon.GetDataRow(sqlQuery, oSqlCommand, null, "Update User ");
if (r != null)
{
try
{
bool resp = false;
int inSysID = 0;
resp = int.TryParse(r["SysID"].ToString(), out inSysID);
_ExistData.SysID = inSysID;
_ExistData.UserName = r["UserName"].ToString();
_ExistData.UPassword = r["UPassword"].ToString();
int inGroupID = 0;
resp = int.TryParse(r["GroupID"].ToString(), out inGroupID);
_ExistData.GroupID = inGroupID;
_ExistData.CurrentStatus = r["CurrentStatus"].ToString();
DateTime dtCreateDate = new DateTime(1900, 1, 1);
resp = DateTime.TryParse(r["CreateDate"].ToString(), out dtCreateDate);
_ExistData.CreateDate = dtCreateDate;
_ExistData.DepID = r["DepID"].ToString();
int inStatus = 0;
resp = int.TryParse(r["Status"].ToString(), out inStatus);
_ExistData.Status = inStatus;
return("True");
}
catch (Exception ex)
{
return(ex.Message);
}
}
else
{
return("data not found ");
}
}
//public string SaveUserHandling(UserHandlingType _SaveData)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// int SysID = MYCommon.GetSysID("tblusernamepassword", null);
// string sqlQuery = "Insert Into tblusernamepassword ("
// + "SysID,"
// + "UserName,"
// + "UPassword,"
// + "GroupID,"
// + "CurrentStatus,"
// + "CreateDate,"
// + "DepID,"
// + "Status)"
// + " Values ("
// + "@SysID,"
// + "@UserName,"
// + "@UPassword,"
// + "@GroupID,"
// + "@CurrentStatus,"
// + "CurDate(),"
// + "@DepID,"
// + "@Status)";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@SysID", SysID);
// oSqlCommand.Parameters.AddWithValue("@UserName", _SaveData.UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", _SaveData.UPassword);
// oSqlCommand.Parameters.AddWithValue("@GroupID", _SaveData.GroupID);
// oSqlCommand.Parameters.AddWithValue("@CurrentStatus", _SaveData.CurrentStatus);
// oSqlCommand.Parameters.AddWithValue("@DepID", _SaveData.DepID);
// oSqlCommand.Parameters.AddWithValue("@Status", _SaveData.Status);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Save UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public string UpdateUserHandling(UserHandlingType _Update)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Update tblusernamepassword Set "
// + "SysID=@SysID,"
// + "UserName=@UserName,"
// + "UPassword=@UPassword,"
// + "GroupID=@GroupID,"
// + "CurrentStatus=@CurrentStatus,"
// + "CreateDate=CurDate(),"
// + "DepID=@DepID,"
// + "Status=@Status"
// + "Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@SysID", _Update.SysID);
// oSqlCommand.Parameters.AddWithValue("@UserName", _Update.UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", _Update.UPassword);
// oSqlCommand.Parameters.AddWithValue("@GroupID", _Update.GroupID);
// oSqlCommand.Parameters.AddWithValue("@CurrentStatus", _Update.CurrentStatus);
// oSqlCommand.Parameters.AddWithValue("@DepID", _Update.DepID);
// oSqlCommand.Parameters.AddWithValue("@Status", _Update.Status);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Update on web UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public string DeleteUserHandling(string UserName, string UPassword)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Delete from tblusernamepassword"
// + " Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
// string respond = MYCommon.ExicuteAnyCommandOnWeb(sqlQuery, oSqlCommand, "Delete UserName");
// return respond;
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
//public bool ExistUserHandling(string UserName, string UPassword)
//{
// MySqlCommand oSqlCommand = new MySqlCommand();
// string sqlQuery = "Select SysID from tblusernamepassword"
// + " Where 1=1 "
// + " and UserName=@UserName"
// + " and UPassword=@UPassword";
// try
// {
// oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
// oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
// bool respond = MYCommon.ExistIntableOnWeb(sqlQuery, oSqlCommand);
// return respond;
// }
// catch (Exception ex)
// {
// return false;
// }
//}
public string GetExistUserHandling(string UserName, string UPassword, out UserHandlingType _ExistData)
{
_ExistData = new UserHandlingType();
MySqlCommand oSqlCommand = new MySqlCommand();
string sqlQuery = "Select "
+ "SysID,"
+ "UserName,"
+ "UPassword,"
+ "GroupID,"
+ "CurrentStatus,"
+ "CreateDate,"
+ "DepID,"
+ "Status"
+ " from tblusernamepassword"
+ " Where 1=1 "
+ " and UserName=@UserName"
+ " and UPassword=@UPassword";
oSqlCommand.Parameters.AddWithValue("@UserName", UserName);
oSqlCommand.Parameters.AddWithValue("@UPassword", UPassword);
DataRow r = MYCommon.GetDataRow(sqlQuery, oSqlCommand, null, "Update User ");
if (r != null)
{
try
{
bool resp = false;
int inSysID = 0;
resp = int.TryParse(r["SysID"].ToString(), out inSysID);
_ExistData.SysID = inSysID;
_ExistData.UserName = r["UserName"].ToString();
_ExistData.UPassword = r["UPassword"].ToString();
int inGroupID = 0;
resp = int.TryParse(r["GroupID"].ToString(), out inGroupID);
_ExistData.GroupID = inGroupID;
_ExistData.CurrentStatus = r["CurrentStatus"].ToString();
DateTime dtCreateDate = new DateTime(1900, 1, 1);
resp = DateTime.TryParse(r["CreateDate"].ToString(), out dtCreateDate);
_ExistData.CreateDate = dtCreateDate;
_ExistData.DepID = r["DepID"].ToString();
int inStatus = 0;
resp = int.TryParse(r["Status"].ToString(), out inStatus);
_ExistData.Status = inStatus;
return "True";
}
catch (Exception ex)
{
return ex.Message;
}
}
else
return "data not found ";
}
