private void btnSelectALL_CheckedChanged(object sender, EventArgs e)
{
try
{
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((DocumentMGRGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
if (btnSelectALL.Checked == true)
{
for (var i = 0; i < MaxRow; i++)
{
DocMGRGrid.SetRowCellValue(i, "Select", "True");
}
}
if (btnSelectALL.Checked == false)
{
for (var i = 0; i < MaxRow; i++)
{
DocMGRGrid.SetRowCellValue(i, "Select", "False");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void fillGrid()
{
try
{
//DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
//SplashScreenManager.Default.SetWaitFormDescription("Fetching Data");
var strsql = String.Format("sp_EmpSalMst '{0}{1}'", DtStartDate.Text.Substring(0, 2), DtStartDate.Text.Substring(DtStartDate.Text.Length - 2, 2));
using (var ds = ProjectFunctions.GetDataSet(strsql))
{
ds.Tables[0].Columns.Add("Select", typeof(bool));
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["Select"] = false;
}
DocumentMGRGrid.DataSource = ds.Tables[0];
DocMGRGrid.BestFitColumns();
}
//SplashScreenManager.CloseForm();
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
var Dr = DocMGRGrid.GetFocusedDataRow();
EmpCode = Dr["EmpCode"].ToString();
EmpMonth = Dr["MonthYear"].ToString();
if (btnEdit.Enabled)
{
if (DocMGRGrid.DataSource != null)
{
if (DocMGRGrid.RowCount > 0)
{
DataSet ds = ProjectFunctions.GetDataSet("Select * from PayFinal Where MonthYear='" + EmpMonth + "' And EmpCode='" + EmpCode + "'");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["EmpSalLocTag"].ToString().Trim() == "Y")
{
XtraMessageBox.Show("Salary Has Been Locked");
}
else
{
using (var FMRU = new frm_EmpSalAddUpdate()
{
IsUpdate = true, MMDocNo = EmpCode, MMDocNo1 = EmpMonth
})
{
var P = ProjectFunctions.GetPositionInForm(this);
FMRU.Location = new Point(P.X + (ClientSize.Width / 2 - FMRU.Size.Width / 2), P.Y + (ClientSize.Height / 2 - FMRU.Size.Height / 2));
FMRU.ShowDialog();
}
}
}
else
{
using (var FMRU = new frm_EmpSalAddUpdate()
{
IsUpdate = true, MMDocNo = EmpCode, MMDocNo1 = EmpMonth
})
{
var P = ProjectFunctions.GetPositionInForm(this);
FMRU.Location = new Point(P.X + (ClientSize.Width / 2 - FMRU.Size.Width / 2), P.Y + (ClientSize.Height / 2 - FMRU.Size.Height / 2));
FMRU.ShowDialog();
}
}
}
else
{
XtraMessageBox.Show("No Records to Edit", "!Error");
}
}
else
{
XtraMessageBox.Show("No Datasource, Or Unable to fetch Data.", "!Error");
}
}
else
{
XtraMessageBox.Show("You have No permission.", "!Error");
}
fillGrid();
}
private void btnLoadAdvance_Click(object sender, EventArgs e)
{
DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
SplashScreenManager.Default.SetWaitFormDescription("Processing Salary");
#pragma warning disable CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
var MaxRow = ((DocumentMGRGrid.KeyboardFocusView as GridView).RowCount);
#pragma warning restore CS0618 // 'GridControl.KeyboardFocusView' is obsolete: 'Use the FocusedView property instead.'
for (int i = 0; i < MaxRow; i++)
{
var currentrow = DocMGRGrid.GetDataRow(i);
if (currentrow["Select"].ToString().ToUpper() == "TRUE")
{
SplashScreenManager.Default.SetWaitFormDescription("Loading Loan/Advances " + i.ToString());
Decimal LoanAmt = 0;
EmpCode = currentrow["EmpCode"].ToString();
EmpMonth = currentrow["MonthYear"].ToString();
string str = "sp_LoadLoanBal '" + EmpCode + "'";
DateTime TempDate = Convert.ToDateTime("20" + EmpMonth.ToString().Substring(2, 2) + "-" + EmpMonth.ToString().Substring(0, 2) + "-" + DateTime.DaysInMonth(Convert.ToInt32("20" + EmpMonth.ToString().Substring(2, 2)), Convert.ToInt32(EmpMonth.ToString().Substring(0, 2))) + string.Empty);
DataSet ds = ProjectFunctions.GetDataSet(str);
if (ds.Tables[0].Rows.Count > 0)
{
if (Convert.ToDecimal(ds.Tables[0].Rows[0]["LoanBal"]) >= Convert.ToDecimal(ds.Tables[0].Rows[0]["LoanInstlmnt"]))
{
LoanAmt = Convert.ToDecimal(ds.Tables[0].Rows[0]["LoanInstlmnt"]);
}
else
{
LoanAmt = Convert.ToDecimal(ds.Tables[0].Rows[0]["LoanBal"]);
}
if (LoanAmt < 0)
{
LoanAmt = 0;
}
}
else
{
LoanAmt = 0;
}
Decimal Advance = 0;
DateTime TempAdvanveDate = Convert.ToDateTime("20" + EmpMonth.ToString().Substring(2, 2) + "-" + EmpMonth.ToString().Substring(0, 2) + "-01");
DataSet dsAdvance = ProjectFunctions.GetDataSet("select ISNULL(sum(ExAmt),0) as Advance from ExMst where ExEmpCode='" + EmpCode + "' And DATEPART(MM,ExMst.ExDatePost)='" + TempAdvanveDate.Date.ToString("MM") + "' And DATEPART(yyyy,ExMst.ExDatePost)='" + TempAdvanveDate.Date.ToString("yyyy") + "'");
if (dsAdvance.Tables.Count > 0)
{
if (dsAdvance.Tables[0].Rows.Count > 0)
{
Advance = Advance + Convert.ToDecimal(dsAdvance.Tables[0].Rows[0][0]);
}
else
{
Advance = 0;
}
}
DataSet dsCheckAgain = ProjectFunctions.GetDataSet("Select * from PayFinal Where MonthYear='" + EmpMonth + "' And EmpCode='" + EmpCode + "'");
if (dsCheckAgain.Tables[0].Rows.Count > 0)
{
if (dsCheckAgain.Tables[0].Rows[0]["EmpSalLocTag"].ToString().Trim() == "Y")
{
}
else
{
DataSet dsUpdate = ProjectFunctions.GetDataSet("update AtnData set EmpAdvAmt='" + Advance + "',EmpLoanAmt='" + LoanAmt + "' Where EmpCode='" + EmpCode + "' And MonthYear='" + EmpMonth + "'");
}
}
else
{
DataSet dsUpdate = ProjectFunctions.GetDataSet("update AtnData set EmpAdvAmt='" + Advance + "',EmpLoanAmt='" + LoanAmt + "' Where EmpCode='" + EmpCode + "' And MonthYear='" + EmpMonth + "'");
}
}
}
fillGrid();
SplashScreenManager.CloseForm();
}