public CpPackageInfo[] GetByFilter(String tvcdb, List <DTO.Criteria> filters, ref string logMsg, int indexPage = 0, int itemPerPage = 0) { CpPackageInfo[] res = _objDAO.GetByFilter(tvcdb, filters, ref logMsg, indexPage, itemPerPage); //get details BUS.CpPackageAllocControl ctr = new CpPackageAllocControl(this); foreach (var i in res) { DTO.CriteriaCollection fs = new CriteriaCollection(); fs.Add("packagecode", i.packagecode); i.allocs = ctr.GetByCPK(tvcdb, i.packagecode, ref logMsg); } return(res); }
public string Update(CpPackageInfo obj) { string sErr = _objDAO.Update(obj); if (obj.allocs != null) { BUS.CpPackageAllocControl ctrA = new CpPackageAllocControl(this); sErr = ctrA.Delete(obj.tvcdb, obj.packagecode); foreach (var d in obj.allocs) { if (!string.IsNullOrEmpty(sErr)) { break; } DTO.CpPackageAllocInfo a = new CpPackageAllocInfo { tvcdb = obj.tvcdb, packagecode = obj.packagecode, block = d.block, createdby = this.USER_ID, updatedby = this.USER_ID }; ctrA.Add(a, ref sErr); } } // add details //BUS.CpWorkItemControl widCtr = new CpWorkItemControl(this); //if (string.IsNullOrEmpty(sErr)) //{ // if (obj.amount != null || !string.IsNullOrEmpty(obj.costcode)) // { // if (string.IsNullOrEmpty(obj.costcode)) // { // var dt = _objDAO.GetCostCode(DB, obj.packagecode, ref sErr); // if (dt.Rows.Count == 1) // { // obj.costcode = dt.Rows[0][0] + ""; // } // } // if (!string.IsNullOrEmpty(obj.costcode)) sErr = widCtr.updateCPK(DB, obj.project, obj.costcode); // } //} return(sErr); }
public DataTable GetByFilterToDataTable(String tvcdb, List <DTO.Criteria> filters, ref string logMsg, int indexPage = 0, int itemPerPage = 0) { DataTable res = _objDAO.GetByFilterToDataTable(tvcdb, filters, ref logMsg, indexPage, itemPerPage); res.Columns.Add("allocString", typeof(String[])); BUS.CpPackageAllocControl ctr = new CpPackageAllocControl(this); foreach (DataRow i in res.Rows) { var allocs = ctr.GetByCPK(tvcdb, i["packagecode"].ToString(), ref logMsg); String[] arr = new string[allocs.Length]; int x = 0; foreach (var a in allocs) { arr[x++] = a.block; } i["allocString"] = arr; } return(res); }
public int Add(CpPackageInfo obj, ref string sErr) { _objDAO.Add(obj, ref sErr); if (string.IsNullOrEmpty(sErr)) { if (obj.allocs != null) { BUS.CpPackageAllocControl ctr = new CpPackageAllocControl(this); foreach (var d in obj.allocs) { if (!string.IsNullOrEmpty(sErr)) { break; } DTO.CpPackageAllocInfo a = new CpPackageAllocInfo { tvcdb = obj.tvcdb, packagecode = obj.packagecode, block = d.block, createdby = this.USER_ID, updatedby = this.USER_ID }; ctr.Add(a, ref sErr); } } } //BUS.CpWorkItemControl widCtr = new CpWorkItemControl(this); //if (string.IsNullOrEmpty(sErr)) //{ // if (obj.amount != null && !string.IsNullOrEmpty(obj.costcode)) // { // sErr = widCtr.updateCPK(DB, obj.project, obj.costcode); // } //} return(1); }