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; }