public async Task <Result <CommitmentsSearchReturnEnt> > Search([FromBody] CommitmentsSearchArg arg)
{
Result <CommitmentsSearchReturnEnt> r = null;
await Task.Run(() =>
{
r = ResultRunner <CommitmentsSearchReturnEnt> .Run(delegate() { return(OVPRBus.Search(arg)); });
});
return(r);
}
static void Main(string[] args)
{
OVPR_System.ConnectionString = "Data Source=AMSDBFIX.cam.uchc.edu;Connection Timeout=300;Initial Catalog=OVPRCommitment;User ID=ResearchApp;Password=Aw@rdMgmtApp!";
CommitmentsSearchArg arg = new CommitmentsSearchArg();
arg.pageIndex = 0;
arg.pageSize = 30;
arg.sortBy_Property = "Commitment_PK";
arg.sortBy_IsAsc = true;
var r = OVPR_Lib.Bus.OVPRBus.Search(arg);
}
public static CommitmentsSearchReturnEnt Search(CommitmentsSearchArg arg)
{
var toReturn = new CommitmentsSearchReturnEnt();
var allData = OVPRDat.usp_13_Commitment_GetCommitmentData(arg);
allData = allData.AsQueryable().OrderByFieldName(arg.sortBy_Property, arg.sortBy_IsAsc).ToList();
var startIndex = arg.pageIndex * arg.pageSize;
var length = arg.pageSize;
if ((startIndex + arg.pageSize) > allData.Count)
{
length = allData.Count - startIndex;
}
toReturn.totalRows = allData.Count;
toReturn.totalPages = (int)Math.Ceiling((double)toReturn.totalRows / arg.pageSize);
toReturn.result = allData.GetRange(startIndex, length);
return(toReturn);
}
public static List <CommitmentsSearchResultEnt> usp_13_Commitment_GetCommitmentData(CommitmentsSearchArg arg)
{
string procName = "OVPR.usp_13_Commitment_GetCommitmentData";
var prms = new List <SqlParameter>();
prms.Add(new SqlParameter("@prm_CommitmentID", arg.CommitmentID));
prms.Add(new SqlParameter("@prm_CampusID", arg.CampusID));
prms.Add(new SqlParameter("@prm_CommTypeID", arg.CommTypeID));
prms.Add(new SqlParameter("@prm_CommStatusID", arg.CommStatusID));
prms.Add(new SqlParameter("@prm_PiID", arg.PiID));
prms.Add(new SqlParameter("@prm_SchoolID", arg.SchoolID));
prms.Add(new SqlParameter("@prm_Description", arg.Description));
prms.Add(new SqlParameter("@prm_TotalCommitment", arg.TotalCommitment));
prms.Add(new SqlParameter("@prm_ProjectTitle", arg.ProjectTitle));
prms.Add(new SqlParameter("@prm_TransactionNumber", arg.TransactionNumber));
prms.Add(new SqlParameter("@prm_Comment", arg.Comment));
return(DataAccessHelpers.GetEnts <CommitmentsSearchResultEnt>(procName, prms));
}
