public bool ExistBankCheques(string ChequeNo) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select SysID from tblcheque" + " Where 1=1 " + " and ChequeNo=@ChequeNo"; try { oSqlCommand.Parameters.AddWithValue("@ChequeNo", ChequeNo); bool respond = Mycommon.ExistInTableAccount(sqlQuery, oSqlCommand, "Exist Cheque in table"); return(respond); } catch (Exception ex) { return(false); } }
public bool ExistObjectUserRoll(int RollID, int userID, int ObgID) { MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select SysID from tblobguserprofile" + " Where 1=1 " + " and RollID=@RollID" + " and userID=@userID" + " and ObgID=@ObgID"; try { oSqlCommand.Parameters.AddWithValue("@RollID", RollID); oSqlCommand.Parameters.AddWithValue("@userID", userID); oSqlCommand.Parameters.AddWithValue("@ObgID", ObgID); bool respond = MYCommon.ExistInTableAccount(sqlQuery, oSqlCommand, "Exist User Object"); return(respond); } catch (Exception ex) { return(false); } }