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