private void BindGrid()
{
PmsProjectCommitmentHitRateBiz pmsProjectCommitmentHitRateBiz = new PmsProjectCommitmentHitRateBiz();
PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = new PmsProjectCommitmentHitRate();
pmsProjectCommitmentHitRate.Month = Month;
pmsProjectCommitmentHitRate.Week = Week;
pmsProjectCommitmentHitRate.UserDept = UserDept;
pmsProjectCommitmentHitRate.Status = Status;
GridViewRequirement.EmptyDataText = "No Data.";
IList <PmsProjectCommitmentHitRate> pmsProjectCommitmentHitRateList = pmsProjectCommitmentHitRateBiz.GetPmsProjectCommitmentHitRateList(pmsProjectCommitmentHitRate);
if (pmsProjectCommitmentHitRateList != null)
{
foreach (var projectCommitmentHitRate in pmsProjectCommitmentHitRateList)
{
if (projectCommitmentHitRate.Status == "OnSchedule")
{
projectCommitmentHitRate.Status = "On-Schedule";
}
}
}
GridViewRequirement.DataSource = pmsProjectCommitmentHitRateList;
GridViewRequirement.DataBind();
}
public bool InsertPmsProjectCommitmentHitRate(IList <PmsProjectCommitmentHitRate> listPmsProjectCommitmentHitRate)
{
try
{
m_PMSSqlConnection.BeginTransaction();
if (listPmsProjectCommitmentHitRate.Count > 0)
{
PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = listPmsProjectCommitmentHitRate.FirstOrDefault();
m_PMSSqlConnection.Delete("DeletePmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate);
}
foreach (var pmsProjectCommitmentHitRate in listPmsProjectCommitmentHitRate)
{
if (pmsProjectCommitmentHitRate.UserDept == null)
{
pmsProjectCommitmentHitRate.UserDept = "";
}
m_PMSSqlConnection.Insert("InsertPmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate);
}
m_PMSSqlConnection.CommitTransaction();
return(true);
}
catch (Exception ex)
{
m_PMSSqlConnection.RollBackTransaction();
m_Logger.Error("PmsRequirementBiz/InsertPmsRequirement:" + ex.ToString());
return(false);
}
}
private void InsertProjectCommitmentHitRate()
{
IList <string> weeks = new List <string>();
IList <string> months = GetMonths();
foreach (string month in months)
{
PmsProjectCommitmentHitRateBiz pmsProjectCommitmentHitRateBiz = new PmsProjectCommitmentHitRateBiz();
PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate = new PmsProjectCommitmentHitRate();
IList <PmsProjectCommitmentHitRate> listPmsProjectCommitmentHitRate;
if (DropDownListStatisticsInterval.SelectedValue.Trim() == "Bi-weekly")
{
weeks = GetWeeks(month);
foreach (string week in weeks)
{
pmsProjectCommitmentHitRate.Week = week;
pmsProjectCommitmentHitRate.UserDept = DropDownListUserDept.SelectedValue.Trim();
listPmsProjectCommitmentHitRate =
pmsProjectCommitmentHitRateBiz.GetProjectCommitmentHitRatePmsHead(pmsProjectCommitmentHitRate);
if (listPmsProjectCommitmentHitRate == null || listPmsProjectCommitmentHitRate.Count == 0)
{
return;
}
listPmsProjectCommitmentHitRate = SetListPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate, month, week);
pmsProjectCommitmentHitRateBiz.InsertPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate);
}
}
else
{
pmsProjectCommitmentHitRate.Month = month;
pmsProjectCommitmentHitRate.UserDept = DropDownListUserDept.SelectedValue.Trim();
listPmsProjectCommitmentHitRate =
pmsProjectCommitmentHitRateBiz.GetProjectCommitmentHitRatePmsHead(pmsProjectCommitmentHitRate);
if (listPmsProjectCommitmentHitRate == null || listPmsProjectCommitmentHitRate.Count == 0)
{
return;
}
listPmsProjectCommitmentHitRate = SetListPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate, month, pmsProjectCommitmentHitRate.Week);
pmsProjectCommitmentHitRateBiz.InsertPmsProjectCommitmentHitRate(listPmsProjectCommitmentHitRate);
}
}
}
public IList <PmsProjectCommitmentHitRate> GetPmsProjectCommitmentHitRateList(PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate)
{
try
{
return(m_PMSSqlConnection.QueryForList <PmsProjectCommitmentHitRate>("SelectPmsProjectCommitmentHitRate", pmsProjectCommitmentHitRate));
}
catch (Exception ex)
{
m_Logger.Error("PmsRequirementBiz/SelectPmsRequirement:" + ex.ToString());
return(null);
}
}
public IList <PmsProjectCommitmentHitRate> GetProjectCommitmentHitRatePmsHead(PmsProjectCommitmentHitRate pmsProjectCommitmentHitRate)
{
try
{
if (pmsProjectCommitmentHitRate.UserDept.Contains("AIC"))
{
pmsProjectCommitmentHitRate.UserDept = "AIC%";
}
return(m_PMSSqlConnection.QueryForList <PmsProjectCommitmentHitRate>("SelecProjectCommitmentHitRatePmsHead", pmsProjectCommitmentHitRate));
}
catch (Exception ex)
{
m_Logger.Error("PmsRequirementBiz/SelectPmsRequirement:" + ex.ToString());
return(null);
}
}
