public string SaveObjectUserRoll(ObjectUserRollDataType _SaveData) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Insert Into tblobguserprofile (" + "RollID," + "userID," + "ObgID," + "OView," + "OSave," + "OUpdate," + "Odelete," + "OPrint," + "OPostToApp," + "OPostToAcc)" + " Values (" + "@RollID," + "@userID," + "@ObgID," + "@OView," + "@OSave," + "@OUpdate," + "@Odelete," + "@OPrint," + "@OPostToApp," + "@OPostToAcc)"; try { oSqlCommand.Parameters.AddWithValue("@RollID", _SaveData.RollID); oSqlCommand.Parameters.AddWithValue("@userID", _SaveData.userID); oSqlCommand.Parameters.AddWithValue("@ObgID", _SaveData.ObgID); oSqlCommand.Parameters.AddWithValue("@OView", _SaveData.OView); oSqlCommand.Parameters.AddWithValue("@OSave", _SaveData.OSave); oSqlCommand.Parameters.AddWithValue("@OUpdate", _SaveData.OUpdate); oSqlCommand.Parameters.AddWithValue("@Odelete", _SaveData.Odelete); oSqlCommand.Parameters.AddWithValue("@OPrint", _SaveData.OPrint); oSqlCommand.Parameters.AddWithValue("@OPostToApp", _SaveData.OPostToApp); oSqlCommand.Parameters.AddWithValue("@OPostToAcc", _SaveData.OPostToAcc); string respond = MYCommon.ExicuteAnyCommandAccount(sqlQuery, oSqlCommand, "Save ObjectUserRoll"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string UpdateObjectUserRoll(ObjectUserRollDataType _Update) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Update tblobguserprofile Set " + "SysID=@SysID," + "RollID=@RollID," + "userID=@userID," + "ObgID=@ObgID," + "OView=@OView," + "OSave=@OSave," + "OUpdate=@OUpdate," + "Odelete=@Odelete," + "OPrint=@OPrint," + "OPostToApp=@OPostToApp," + "OPostToAcc=@OPostToAcc" + " Where 1=1 " + " and RollID=@RollID" + " and userID=@userID" + " and ObgID=@ObgID"; try { oSqlCommand.Parameters.AddWithValue("@SysID", _Update.SysID); oSqlCommand.Parameters.AddWithValue("@RollID", _Update.RollID); oSqlCommand.Parameters.AddWithValue("@userID", _Update.userID); oSqlCommand.Parameters.AddWithValue("@ObgID", _Update.ObgID); oSqlCommand.Parameters.AddWithValue("@OView", _Update.OView); oSqlCommand.Parameters.AddWithValue("@OSave", _Update.OSave); oSqlCommand.Parameters.AddWithValue("@OUpdate", _Update.OUpdate); oSqlCommand.Parameters.AddWithValue("@Odelete", _Update.Odelete); oSqlCommand.Parameters.AddWithValue("@OPrint", _Update.OPrint); oSqlCommand.Parameters.AddWithValue("@OPostToApp", _Update.OPostToApp); oSqlCommand.Parameters.AddWithValue("@OPostToAcc", _Update.OPostToAcc); string respond = MYCommon.ExicuteAnyCommandAccount(sqlQuery, oSqlCommand, "Update ObjectUserRoll"); return(respond); } catch (Exception ex) { return(ex.Message); } }
public string GetExistObjectUserRoll(int RollID, int userID, int ObgID, out ObjectUserRollDataType _ExistData) { _ExistData = new ObjectUserRollDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "SysID," + "RollID," + "userID," + "ObgID," + "OView," + "OSave," + "OUpdate," + "Odelete," + "OPrint," + "OPostToApp," + "OPostToAcc" + " from tblobguserprofile" + " Where 1=1 " + " and RollID=@RollID" + " and userID=@userID" + " and ObgID=@ObgID"; oSqlCommand.Parameters.AddWithValue("@RollID", RollID); oSqlCommand.Parameters.AddWithValue("@userID", userID); oSqlCommand.Parameters.AddWithValue("@ObgID", ObgID); DataRow r = MYCommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data ObjectUserRoll"); if (r != null) { try { bool resp = false; int inSysID = 0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; int inRollID = 0; resp = int.TryParse(r["RollID"].ToString(), out inRollID); _ExistData.RollID = inRollID; int inuserID = 0; resp = int.TryParse(r["userID"].ToString(), out inuserID); _ExistData.userID = inuserID; int inObgID = 0; resp = int.TryParse(r["ObgID"].ToString(), out inObgID); _ExistData.ObgID = inObgID; int inOView = 0; resp = int.TryParse(r["OView"].ToString(), out inOView); _ExistData.OView = inOView; int inOSave = 0; resp = int.TryParse(r["OSave"].ToString(), out inOSave); _ExistData.OSave = inOSave; int inOUpdate = 0; resp = int.TryParse(r["OUpdate"].ToString(), out inOUpdate); _ExistData.OUpdate = inOUpdate; int inOdelete = 0; resp = int.TryParse(r["Odelete"].ToString(), out inOdelete); _ExistData.Odelete = inOdelete; int inOPrint = 0; resp = int.TryParse(r["OPrint"].ToString(), out inOPrint); _ExistData.OPrint = inOPrint; int inOPostToApp = 0; resp = int.TryParse(r["OPostToApp"].ToString(), out inOPostToApp); _ExistData.OPostToApp = inOPostToApp; int inOPostToAcc = 0; resp = int.TryParse(r["OPostToAcc"].ToString(), out inOPostToAcc); _ExistData.OPostToAcc = inOPostToAcc; return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }
public string UpdateObjectUserRoll(ObjectUserRollDataType _Update) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Update tblobguserprofile Set " + "SysID=@SysID," + "RollID=@RollID," + "userID=@userID," + "ObgID=@ObgID," + "OView=@OView," + "OSave=@OSave," + "OUpdate=@OUpdate," + "Odelete=@Odelete," + "OPrint=@OPrint," + "OPostToApp=@OPostToApp," + "OPostToAcc=@OPostToAcc" + " Where 1=1 " + " and RollID=@RollID" + " and userID=@userID" + " and ObgID=@ObgID"; try { oSqlCommand.Parameters.AddWithValue("@SysID", _Update.SysID); oSqlCommand.Parameters.AddWithValue("@RollID", _Update.RollID); oSqlCommand.Parameters.AddWithValue("@userID", _Update.userID); oSqlCommand.Parameters.AddWithValue("@ObgID", _Update.ObgID); oSqlCommand.Parameters.AddWithValue("@OView", _Update.OView); oSqlCommand.Parameters.AddWithValue("@OSave", _Update.OSave); oSqlCommand.Parameters.AddWithValue("@OUpdate", _Update.OUpdate); oSqlCommand.Parameters.AddWithValue("@Odelete", _Update.Odelete); oSqlCommand.Parameters.AddWithValue("@OPrint", _Update.OPrint); oSqlCommand.Parameters.AddWithValue("@OPostToApp", _Update.OPostToApp); oSqlCommand.Parameters.AddWithValue("@OPostToAcc", _Update.OPostToAcc); string respond = MYCommon.ExicuteAnyCommandAccount(sqlQuery, oSqlCommand, "Update ObjectUserRoll"); return respond; } catch (Exception ex) { return ex.Message; } }
public string SaveObjectUserRoll(ObjectUserRollDataType _SaveData) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Insert Into tblobguserprofile (" + "RollID," + "userID," + "ObgID," + "OView," + "OSave," + "OUpdate," + "Odelete," + "OPrint," + "OPostToApp," + "OPostToAcc)" + " Values (" + "@RollID," + "@userID," + "@ObgID," + "@OView," + "@OSave," + "@OUpdate," + "@Odelete," + "@OPrint," + "@OPostToApp," + "@OPostToAcc)"; try { oSqlCommand.Parameters.AddWithValue("@RollID", _SaveData.RollID); oSqlCommand.Parameters.AddWithValue("@userID", _SaveData.userID); oSqlCommand.Parameters.AddWithValue("@ObgID", _SaveData.ObgID); oSqlCommand.Parameters.AddWithValue("@OView", _SaveData.OView); oSqlCommand.Parameters.AddWithValue("@OSave", _SaveData.OSave); oSqlCommand.Parameters.AddWithValue("@OUpdate", _SaveData.OUpdate); oSqlCommand.Parameters.AddWithValue("@Odelete", _SaveData.Odelete); oSqlCommand.Parameters.AddWithValue("@OPrint", _SaveData.OPrint); oSqlCommand.Parameters.AddWithValue("@OPostToApp", _SaveData.OPostToApp); oSqlCommand.Parameters.AddWithValue("@OPostToAcc", _SaveData.OPostToAcc); string respond = MYCommon.ExicuteAnyCommandAccount(sqlQuery, oSqlCommand, "Save ObjectUserRoll"); return respond; } catch (Exception ex) { return ex.Message; } }
public string GetExistObjectUserRoll(int RollID, int userID, int ObgID, out ObjectUserRollDataType _ExistData) { _ExistData = new ObjectUserRollDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "SysID," + "RollID," + "userID," + "ObgID," + "OView," + "OSave," + "OUpdate," + "Odelete," + "OPrint," + "OPostToApp," + "OPostToAcc" + " from tblobguserprofile" + " Where 1=1 " + " and RollID=@RollID" + " and userID=@userID" + " and ObgID=@ObgID"; oSqlCommand.Parameters.AddWithValue("@RollID", RollID); oSqlCommand.Parameters.AddWithValue("@userID", userID); oSqlCommand.Parameters.AddWithValue("@ObgID", ObgID); DataRow r = MYCommon.GetDataRowAccount(sqlQuery, oSqlCommand, "Get Exist data ObjectUserRoll"); if (r != null) { try { bool resp = false; int inSysID = 0; resp = int.TryParse(r["SysID"].ToString(), out inSysID); _ExistData.SysID = inSysID; int inRollID = 0; resp = int.TryParse(r["RollID"].ToString(), out inRollID); _ExistData.RollID = inRollID; int inuserID = 0; resp = int.TryParse(r["userID"].ToString(), out inuserID); _ExistData.userID = inuserID; int inObgID = 0; resp = int.TryParse(r["ObgID"].ToString(), out inObgID); _ExistData.ObgID = inObgID; int inOView = 0; resp = int.TryParse(r["OView"].ToString(), out inOView); _ExistData.OView = inOView; int inOSave = 0; resp = int.TryParse(r["OSave"].ToString(), out inOSave); _ExistData.OSave = inOSave; int inOUpdate = 0; resp = int.TryParse(r["OUpdate"].ToString(), out inOUpdate); _ExistData.OUpdate = inOUpdate; int inOdelete = 0; resp = int.TryParse(r["Odelete"].ToString(), out inOdelete); _ExistData.Odelete = inOdelete; int inOPrint = 0; resp = int.TryParse(r["OPrint"].ToString(), out inOPrint); _ExistData.OPrint = inOPrint; int inOPostToApp = 0; resp = int.TryParse(r["OPostToApp"].ToString(), out inOPostToApp); _ExistData.OPostToApp = inOPostToApp; int inOPostToAcc = 0; resp = int.TryParse(r["OPostToAcc"].ToString(), out inOPostToAcc); _ExistData.OPostToAcc = inOPostToAcc; return("True"); } catch (Exception ex) { return(ex.Message); } } else { return("data not found "); } }