// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
/// <summary>
/// UpdateForReport
/// </summary>
/// <param name="projectId">projectId</param>
/// <returns>Total Average Price</returns>
public string UpdateForReport(int projectId, int companyId)
{
double totalAveragePrice = 0;
// For LFS_PROJECT_SERVICE
// ... for Service Name and Total Average Price
foreach (ProjectSynopsisReportTDS.LFS_PROJECT_SERVICERow row in this.Table.Rows)
{
if (row.ProjectID == projectId)
{
try
{
totalAveragePrice = totalAveragePrice + (Convert.ToDouble(row.AveragePrice) * Convert.ToDouble(row.Quantity));
}
catch
{
}
try
{
ServiceGateway serviceGateway = new ServiceGateway();
serviceGateway.LoadByServiceId(Convert.ToInt32(row.ServiceID), companyId);
row.ServiceName = serviceGateway.GetName(Convert.ToInt32(row.ServiceID));
}
catch
{
row.ServiceName = "Other";
}
}
}
return totalAveragePrice.ToString();
}
protected void grdServices_RowDataBound(object sender, GridViewRowEventArgs e)
{
// Edit items
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
// Initialize values
int projectId = Int32.Parse(((Label)e.Row.FindControl("lblProjectId")).Text);
int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefId")).Text);
// For Services
ProjectNavigatorProjectServiceGateway projectNavigatorProjectServiceGateway = new ProjectNavigatorProjectServiceGateway(projectNavigatorTDS);
if (projectNavigatorProjectServiceGateway.GetServiceID(projectId, refId).HasValue)
{
int? serviceId = projectNavigatorProjectServiceGateway.GetServiceID(projectId, refId);
if (serviceId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlServiceEdit")).SelectedValue = ((int)serviceId).ToString();
}
}
else
{
((DropDownList)e.Row.FindControl("ddlServiceEdit")).SelectedValue = "(Other)";
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
// Initialize values
int projectId = Int32.Parse(((Label)e.Row.FindControl("lblProjectId")).Text);
if (projectId >= 0)
{
int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefId")).Text);
// For Services
ProjectNavigatorProjectServiceGateway projectNavigatorProjectServiceGateway = new ProjectNavigatorProjectServiceGateway(projectNavigatorTDS);
int? serviceId = projectNavigatorProjectServiceGateway.GetServiceID(projectId, refId);
string serviceName = "(Other)";
if ((serviceId.HasValue) && ((int)serviceId != -1))
{
// ... Get name
ServiceGateway serviceGateway = new ServiceGateway();
serviceGateway.LoadByServiceId((int)serviceId, Int32.Parse(hdfCompanyId.Value));
serviceName = serviceGateway.GetName((int)serviceId);
}
// ... Set name
((Label)e.Row.FindControl("lblService")).Text = serviceName;
}
}
}