private void GenerateInc()
{
if (s_mName != "E")
{
if (DEFrom.EditValue == null || DEFrom.EditValue.ToString() == "")
{
return;
}
if (DETo.EditValue == null || DETo.EditValue.ToString() == "")
{
return;
}
}
dt_ExeName = new DataTable();
dt_ExeName = CommFun.FillExec();
DataTable dt_Gen = new DataTable();
dt_Gen.Columns.Add("RowId", typeof(int));
dt_Gen.Columns.Add("ExecutiveId", typeof(int));
dt_Gen.Columns.Add("ExecutiveName", typeof(string));
dt_Gen.Columns.Add("Amount", typeof(decimal)).DefaultValue = 0;
for (int row = 0; row <= dt_ExeName.Rows.Count - 1; row++)
{
DataRow dr = dt_Gen.NewRow();
dr["RowId"] = dt_Gen.Rows.Count + 1;
dr["ExecutiveName"] = dt_ExeName.Rows[row]["ExecName"].ToString();
dr["ExecutiveId"] = Convert.ToInt32(dt_ExeName.Rows[row]["ExecId"]);
dt_Gen.Rows.Add(dr);
}
if (s_mName != "E")
{
string s_Date1 = string.Format("{0:MM/yyyy}", DEFrom.EditValue);
string s_Date2 = string.Format("{0:MM/yyyy}", DETo.EditValue);
string[] s1 = s_Date1.Split('/');
string[] s2 = s_Date2.Split('/');
DataSet ds = new DataSet();
DataTable dtI = new DataTable();
DataTable dtV = new DataTable();
IncBO.FromMonth = Convert.ToInt32(s1[0]);
IncBO.ToMonth = Convert.ToInt32(s2[0]);
IncBO.FromYear = Convert.ToInt32(s1[1]);
IncBO.ToYear = Convert.ToInt32(s2[1]);
ds = IncentiveDL.GetIncentive();
dtI = ds.Tables["Inc"];
dtV = ds.Tables["Value"];
DataView dv; DataRow[] drT;
for (int i = 0; i < dt_Gen.Rows.Count; i++)
{
int iExecId = Convert.ToInt32(dt_Gen.Rows[i]["ExecutiveId"].ToString());
decimal dAmtL = 0; decimal dAmtR = 0;
decimal dNetValue = 0;
dv = new DataView(dtI);
dv.RowFilter = "ExecutiveId = " + iExecId + " And IncentiveType='L'";
if (dv.ToTable().Rows.Count > 0)
{
for (int x = 0; x < dv.ToTable().Rows.Count; x++)
{
dAmtL = dAmtL + Convert.ToDecimal(dv.ToTable().Rows[x]["IncValue"].ToString());
}
}
dv = new DataView(dtI);
dv.RowFilter = "ExecutiveId = " + iExecId + " And IncentiveType='R'";
if (dv.ToTable().Rows.Count > 0)
{
for (int x = 0; x < dv.ToTable().Rows.Count; x++)
{
dAmtR = dAmtR + Convert.ToDecimal(dv.ToTable().Rows[x]["IncValue"].ToString());
}
}
dv = new DataView(dtV);
dv.RowFilter = "ExecutiveId = " + iExecId;
if (dv.ToTable().Rows.Count > 0)
{
dNetValue = Convert.ToDecimal(dv.ToTable().Rows[0]["Amt"].ToString());
}
drT = dt_Gen.Select("ExecutiveId = " + iExecId + " ");
if (drT.Length > 0)
{
drT[0]["Amount"] = (dNetValue * dAmtR / 100) + dAmtL;
}
}
}
grdIG.DataSource = dt_Gen;
grdIGView.PopulateColumns();
grdIGView.Columns["RowId"].Visible = false;
grdIGView.Columns["ExecutiveId"].Visible = false;
grdIGView.Columns["ExecutiveName"].OptionsColumn.AllowEdit = false;
grdIGView.Columns["Amount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdIGView.Columns["Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdIGView.Columns["Amount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdIGView.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdIGView.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
}
