private void ELogConfigurationForm_AfterSave()
{
SqlCommand Command = new SqlCommand();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "uspCreateTrigger";
Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value);
VTransactionHandler.ExecuteStoredProc(Command);
}
private bool HasCheck()
{
bool result = true;
SqlCommand Command = new SqlCommand();
SqlParameter Result = new SqlParameter();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "uspGetCheckDetails";
Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value);
Result.ParameterName = "@HasCheck";
Result.Direction = ParameterDirection.Output;
Result.SqlDbType = SqlDbType.Bit;
Command.Parameters.Add(Result);
VTransactionHandler.ExecuteStoredProc(Command);
result = bool.Parse(Command.Parameters["@HasCheck"].Value.ToString());
return(result);
}
private bool Print2307()
{
bool result = false;
SqlCommand Command = new SqlCommand();
SqlParameter Result = new SqlParameter();
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = "uspPrintBIRForm2307";
Command.Parameters.AddWithValue("@Id", Parameters.Find(p => p.Name == "Id").Value);
Result.ParameterName = "@Result";
Result.Direction = ParameterDirection.Output;
Result.SqlDbType = SqlDbType.Bit;
Command.Parameters.Add(Result);
VTransactionHandler.ExecuteStoredProc(Command);
result = bool.Parse(Command.Parameters["@Result"].Value.ToString());
return(result);
}