protected void LoadProject()
{
int totalRowsCount = 0;
AspNetPager1.PageSize = 10;
StringBuilder sbWhere = new StringBuilder();
string anyCondition = txtAnyCondition.Text.Trim();
if (!string.IsNullOrEmpty(anyCondition))
{
sbWhere.Append(anyCondition);
}
DataTable dtProject = prjDal.GetProjectForEmployeeHome(Convert.ToString(EmployeeID ?? string.Empty), sbWhere.ToString(), AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out totalRowsCount);
if (dtProject != null && dtProject.Rows.Count > 0)
{
StringBuilder sbPrjId = new StringBuilder();
dtProject.AsEnumerable().Select(item => (string)item["prjID"]).ToList().ForEach(item => sbPrjId.AppendFormat("'{0}',", item));
projectIdNeed = sbPrjId.ToString().TrimEnd(',');
lstTcje = new TransactionDetailsBLL().GetModelList(" AND employeeId = '" + Convert.ToString(EmployeeID ?? string.Empty) + "' AND TRANSACTIONTYPE = 7 AND PROJECTID IN (" + projectIdNeed + ") ");
lstPrjProportion = new ProjectProportionBLL().GetModelList(" projectId IN (" + projectIdNeed + ")");
}
empProportion = epBll.GetModelList(" AND EMPLOYEEID = '" + Convert.ToString(EmployeeID ?? string.Empty) + "'").FirstOrDefault();
if (string.IsNullOrEmpty(sbWhere.ToString()))
{
lblFinishedTaskCount.Text = string.Format("{0}", totalRowsCount);
}
AspNetPager1.RecordCount = totalRowsCount;
gvProject.DataSource = dtProject;
gvProject.DataBind();
gvProject.Columns[1].Visible = IsExternal;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string prjID = Request.QueryString["prjID"].ToString();
decimal amount = Convert.ToDecimal(Request.QueryString["amount"]);
string parentEmployeeID = Convert.ToString(Request.QueryString["parentEmployeeID"]);
string where = " AND employeeId = '" + parentEmployeeID + "'";
decimal proportion = 0m;
ProjectProportion projectProportion = new ProjectProportionBLL().GetModelList(" projectId = '" + prjID + "'").FirstOrDefault();
if (projectProportion != null)
{
proportion = projectProportion.PROPORTION ?? 0m;
}
else
{
EmployeeProportion empPro = epBll.GetModelList(where).FirstOrDefault();
proportion = empPro?.PROPORTION ?? 0m;
}
hidAmount.Value = lblAmount.Text = (amount * proportion).ToString();
LoadCanTransferEmp();
}
}
