/// <summary>
/// To copy the task lines from project template Standard Task lines tab
/// </summary>
/// <param name="Task_ID">ID of tasks</param>
/// <param name="C_ProjectTask_ID">Project task ID</param>
/// <returns>No of lines created</returns>
public int CopyMTaskLines(int Task_ID, int C_ProjectTask_ID)
{
MProjectLine taskline = null;
ValueNamePair pp = null;
int tasklinecount = 0;
StringBuilder msg = new StringBuilder();
String sql = "SELECT M_Product_ID, Description, StandardQty, SeqNo FROM C_TaskLine WHERE IsActive='Y' AND C_Task_ID =" + Task_ID + " ORDER BY SeqNo";
try
{
DataSet ds = DataBase.DB.ExecuteDataset(sql, null, Get_TrxName());
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
taskline = new MProjectLine(GetCtx(), 0, Get_TrxName());
taskline.SetC_ProjectTask_ID(C_ProjectTask_ID);
taskline.SetDescription(Util.GetValueOfString(ds.Tables[0].Rows[i]["Description"]));
taskline.SetM_Product_ID(Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_Product_ID"]));
taskline.SetPlannedQty(Util.GetValueOfDecimal(ds.Tables[0].Rows[i]["StandardQty"]));
taskline.Set_ValueNoCheck("TaskLineNo", Util.GetValueOfInt(ds.Tables[0].Rows[i]["SeqNo"]));
if (taskline.Save())
{
tasklinecount++;
}
else
{
pp = VLogger.RetrieveError();
if (pp != null)
{
msg.Append(pp.GetName());
//if GetName is Empty then it will check GetValue
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg("", pp.GetValue()));
}
}
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_TaskLineNotSaved"));
}
else
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_TaskLineNotSaved") + "," + msg.ToString());
}
}
}
}
}
catch (Exception ex)
{
log.Log(Level.SEVERE, sql, ex);
}
//
return(tasklinecount);
}
/// <summary>
/// To copy the task lines from project template Standard Task lines tab
/// </summary>
/// <param name="Task_ID">ID of tasks</param>
/// <param name="C_ProjectTask_ID">Project task ID</param>
/// <returns>No of lines created</returns>
public int CopyMTaskLinesFromProjectTask(MProjectTask fromTask, MProjectTask toTask, int To_Project_ID)
{
ValueNamePair pp = null;
int tasklinecount = 0;
StringBuilder msg = new StringBuilder();
try
{
MProjectLine[] fromLines = null;
List <MProjectLine> list = new List <MProjectLine>();
DataSet projDs = DB.ExecuteDataset(" SELECT C_ProjectLine_ID FROM C_ProjectLine WHERE " +
" C_ProjectPhase_ID =" + fromTask.GetC_ProjectPhase_ID() + " AND C_ProjectTask_ID =" + fromTask.GetC_ProjectTask_ID() +
" AND IsActive='Y' ORDER BY Line ");
if (projDs != null && projDs.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < projDs.Tables[0].Rows.Count; k++)
{
list.Add(new MProjectLine(GetCtx(), Util.GetValueOfInt(projDs.Tables[0].Rows[k]["C_ProjectLine_ID"]), Get_TrxName()));
}
fromLines = new MProjectLine[list.Count];
fromLines = list.ToArray();
}
if (fromLines != null && fromLines.Length > 0)
{
for (int j = 0; j < fromLines.Length; j++)
{
MProjectLine line = new MProjectLine(GetCtx(), 0, Get_TrxName());
PO.CopyValues(fromLines[j], line, GetAD_Client_ID(), GetAD_Org_ID());
line.SetC_Project_ID(To_Project_ID);
line.SetC_ProjectTask_ID(toTask.GetC_ProjectTask_ID());
line.SetC_ProjectPhase_ID(toTask.GetC_ProjectPhase_ID());
line.SetInvoicedAmt(Env.ZERO);
line.SetInvoicedQty(Env.ZERO);
line.SetC_OrderPO_ID(0);
line.SetC_Order_ID(0);
line.SetProcessed(false);
if (line.Save())
{
tasklinecount++;
}
else
{
pp = VLogger.RetrieveError();
if (pp != null)
{
msg.Append(pp.GetName());
//if GetName is Empty then it will check GetValue
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg("", pp.GetValue()));
}
}
if (string.IsNullOrEmpty(msg.ToString()))
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_LineNotSaved"));
}
else
{
msg.Append(Msg.GetMsg(GetCtx(), "VIS_LineNotSaved") + "," + msg.ToString());
}
}
}
}
}
catch (Exception ex)
{
log.Log(Level.SEVERE, "", ex);
}
//
return(tasklinecount);
}
