public DataSet NewSearchOrders(SearchCriteria SearchFor)
{
// .Modified by Cognizant based on SP changes
// PC Phase II 4/20 - Added logging in below code to find the user ID and search criteria for the insurance reports, Transaction search
Logger.Log(CSAAWeb.Constants.PAY_Search_Orders_SP_START);
DataSet ds = new DataSet();
//CHG0129017 - Removal of Linked server - Start//
try
{
string rep = Config.Setting("ConnectionString.ReadonlyDBInstance");
SqlConnection con = new SqlConnection(rep);
con.Open();
SqlCommand Cmd = new SqlCommand("PAY_Search_Orders", con);
Cmd.CommandType = CommandType.StoredProcedure;
//CHG0129017 - Removal of Linked serve - End//
//SqlCommand Cmd = GetCommand("PAY_Search_Orders");
SearchFor.CopyTo(Cmd);
SqlDataAdapter sqlDa = new SqlDataAdapter(Cmd);
sqlDa.Fill(ds);
con.Close();
//PC Phase II 4/20 - Added logging in below code to find the user ID and search criteria for the insurance reports, Transaction search
Logger.Log(CSAAWeb.Constants.PAY_Search_Orders_SP_END);
}
catch (Exception e)
{
Logger.Log(e);
}
return(ds);
}
public int PayUpdateVoidStatus(SearchCriteria SearchFor)
{
// .Modified by Cognizant based on SP changes
SqlCommand Cmd = GetCommand("PAY_Update_Void_Status");
SearchFor.CopyTo(Cmd);
Cmd.Parameters[0].Direction = ParameterDirection.ReturnValue;
Cmd.ExecuteNonQuery();
return(Convert.ToInt16(Cmd.Parameters[0].Value));
}
public DataSet PayGetVoidReceipt(SearchCriteria SearchFor)
{
// .Modified by Cognizant based on SP changes
SqlCommand Cmd = GetCommand("PAY_Get_Void_Receipt");
SearchFor.CopyTo(Cmd);
SqlDataAdapter sqlDa = new SqlDataAdapter(Cmd);
DataSet ds = new DataSet();
sqlDa.Fill(ds);
return(ds);
}
public DataSet ManualUpdateSearch(SearchCriteria SearchFor)
{
// .Modified by Cognizant based on SP changes
SqlCommand Cmd = GetCommand("PAY_Manual_Update_Search");
SearchFor.CopyTo(Cmd);
SqlDataAdapter sqlDa = new SqlDataAdapter(Cmd);
DataSet ds = new DataSet();
sqlDa.Fill(ds);
return(ds);
}
