private void ChoiceSelect_CheckedChanged(object sender, EventArgs e)
{
if (ChoiceSelect.Checked)
{
for (var i = 0; i < SalaryGridView.RowCount; i++)
{
var rowHandle = SalaryGridView.GetVisibleRowHandle(i);
if (SalaryGridView.IsDataRow(rowHandle))
{
SalaryGridView.SetRowCellValue(rowHandle, SalaryGridView.Columns["Sel"], true);
}
}
}
else
{
for (var i = 0; i < SalaryGridView.RowCount; i++)
{
var rowHandle = SalaryGridView.GetVisibleRowHandle(i);
if (SalaryGridView.IsDataRow(rowHandle))
{
SalaryGridView.SetRowCellValue(rowHandle, SalaryGridView.Columns["Sel"], false);
}
}
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(this, typeof(WaitForm1), true, true, false);
SplashScreenManager.Default.SetWaitFormDescription("Processing Salary");
var tt = new DateTime(Convert.ToInt32(DtStartDate.Text.Substring(DtStartDate.Text.Length - 4, 4)), Convert.ToInt32(DtStartDate.Text.Substring(0, 2)), 20);
var Dt = new DateTime((tt.Month + 1) > 12 ? tt.Year + 1 : tt.Year, (tt.Month + 1) > 12 ? 1 : tt.Month + 1, 20);
if (DateTime.Now.Date > Dt.Date)
{
flagExceed = true;
}
SalaryGridView.CloseEditor();
SalaryGridView.UpdateCurrentRow();
try
{
if (btnAdd.Enabled)
{
if (SalaryGrid.DataSource != null)
{
if (SalaryGridView.RowCount > 0)
{
if (!flagExceed)
{
Cursor saveCursor = Cursor.Current;
try
{
int i = 0;
Cursor.Current = Cursors.WaitCursor;
DataRow[] Rows = (SalaryGrid.DataSource as DataTable).Select("Sel <> False");
foreach (DataRow Dr in Rows)
{
i++;
SplashScreenManager.Default.SetWaitFormDescription("Processing Salary " + i.ToString() + "/" + Rows.Count().ToString());
if (Dr["Locked"].ToString().Trim() == "Y")
{
}
else
{
DataSet dsCheckdays = ProjectFunctions.GetDataSet("Select EmpDW from atnData Where EmpCode='" + Dr["EmpCode"] + "' And MonthYear='" + _Mnthyr + "'");
if (Convert.ToDecimal(dsCheckdays.Tables[0].Rows[0]["EmpDW"]) > 0)
{
int Year = Convert.ToInt32(Convert.ToDateTime(DtStartDate.Text).ToString("yyyy"));
int Month = Convert.ToInt32(Convert.ToDateTime(DtStartDate.Text).ToString("MM"));
int numberOfSundays = NumberOfParticularDaysInMonth(Year, Month, DayOfWeek.Sunday);
//ProjectFunctions.GetDataSet(String.Format("Sp_PayCalc '{0}','{1}','{2}'", Dr["EmpCode"], _Mnthyr, numberOfSundays));
}
}
}
SplashScreenManager.CloseForm();
}
finally
{
Cursor.Current = saveCursor;
}
}
}
else
{
XtraMessageBox.Show("No Records to Process", "!Error");
}
}
else
{
XtraMessageBox.Show("No Datasource, Or Unable to fetch Data.", "!Error");
}
}
else
{
XtraMessageBox.Show("You have No permission .", "!Error");
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Unable to Process Data.\n" + ex.Message, "!Error");
}
FillGrid();
}
