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