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