/// <summary> /// Getting instrument detail and load to grid /// </summary> /// <param name="SlipNo"></param> /// <returns></returns> public ActionResult CMS180_InstrumentDetailGrid(string SlipNo) { ObjectResultData res = new ObjectResultData(); List <dtInstallationSlipDetailsForView> lst = new List <dtInstallationSlipDetailsForView>(); try { IInstallationHandler hand = ServiceContainer.GetService <IInstallationHandler>() as IInstallationHandler; //lst = hand.GetTbt_InstallationSlipDetailsForView(SlipNo, null); lst = hand.GetTbt_InstallationSlipDetailsForView(SlipNo, null); //Add by Jutarat A. on 31012013 foreach (dtInstallationSlipDetailsForView data in lst) { data.AddInstalledQty = (data.TotalStockOutQty ?? 0) + (data.AddInstalledQty ?? 0); data.ReturnQty = (data.ReturnQty ?? 0) + (data.NotInstalledQty ?? 0); } //End Add var sortedList = from p in lst orderby p.InstrumentCode select p; lst = sortedList.ToList <dtInstallationSlipDetailsForView>(); res.ResultData = CommonUtil.ConvertToXml <dtInstallationSlipDetailsForView>(lst, "Common\\CMS180_InstrumentDetail", CommonUtil.GRID_EMPTY_TYPE.SEARCH); } catch (Exception ex) { res.AddErrorMessage(ex); } return(Json(res)); }