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