/// <summary>
/// On 'Print' button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvDailyAttendanceReport.RowCount > 0)
{
DataSet ds = new DataSet();
CompanySP spCompany = new CompanySP();
DataTable dtblCompany = spCompany.CompanyViewDataTable(1);
ds.Tables.Add(dtblCompany);
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
DataTable dtblAttendance = spDailyAttendanceMaster.DailyAttendanceViewForDailyAttendanceReport(dtpDate.Text.Trim(), cmbStatus.Text.Trim(), cmbEmployee.Text.Trim(), cmbDesignation.Text.Trim());
ds.Tables.Add(dtblAttendance);
frmReport frmReportObj = new frmReport();
frmReportObj.MdiParent = formMDI.MDIObj;
frmReportObj.DailyAttendanceReportPrinting(ds);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("DAR:8" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to add columns to Datagridview dynamically
/// </summary>
public void CreateGrid()
{
try
{
dgvMonthlyAttendance.Rows.Clear();
dgvMonthlyAttendance.Columns.Clear();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
int inDays = DateTime.DaysInMonth(dtpMonth.Value.Year, dtpMonth.Value.Month);
dgvMonthlyAttendance.Columns.Add("employeeId", "Employee Id");
dgvMonthlyAttendance.Columns.Add("SlNo", "SlNO");
dgvMonthlyAttendance.Columns.Add("employeeCode", "Employee Code");
dgvMonthlyAttendance.Columns.Add("employeeName", "Employee Name");
for (int i = 1; i <= inDays; ++i)
{
dgvMonthlyAttendance.Columns.Add(i.ToString(), i.ToString());
DateTime dt = new DateTime(dtpMonth.Value.Year, dtpMonth.Value.Month, i);
}
dgvMonthlyAttendance.Columns.Add("Present", "Present");
dgvMonthlyAttendance.Columns.Add("Absent", "Absent");
dgvMonthlyAttendance.Columns["employeeId"].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("MAR3 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool SaveFunction(string date, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(date);
infoDailyAttendanceMaster.Narration = string.Empty;
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = items.Count;
var decMasterIdForEdit = spDailyAttendanceMaster.DailyAttendanceAddToMaster(infoDailyAttendanceMaster); // calling @@identity
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i < inrowcount; i++)
{
string employeeId = items[i]["employeeId"].ToString() ?? string.Empty;
string status = items[i]["status"].ToString() ?? string.Empty;
string narration = items[i]["narration"].ToString() ?? string.Empty;
narration = narration.Replace("\n", "\\n");
if (employeeId != null && employeeId != string.Empty)
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (status != null && status != string.Empty)
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
string strDate = txtCompanyCurrentdate.Text;
if (spDailyAttendanceMaster.DailyAttendanceMasterMasterIdSearch(strDate))
{
DataTable dtblAttendance = new DataTable();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = dtblAttendance;
btnDelete.Enabled = true;
btnSave.Text = "Update";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != "")
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
else
{
DataTable dtblAttendance = new DataTable();
dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = dtblAttendance;
btnDelete.Enabled = false;
btnSave.Text = "Save";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != null)
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
}
catch (Exception ex)
{
MessageBox.Show("A1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
string strEmployeeStatus = string.Empty;
if (rbtnAll.Checked)
{
strEmployeeStatus = "All";
}
else if (rbtnActive.Checked)
{
strEmployeeStatus = "Active";
}
else if (rbtnInActive.Checked)
{
strEmployeeStatus = "InActive";
}
if (strEmployeeStatus != string.Empty && cmbDesigantion.SelectedIndex > -1)
{
CreateGrid();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
EmployeeSP spEmployee = new EmployeeSP();
DataTable dtblEmployee = new DataTable();
dtblEmployee = spEmployee.EmployeeViewByDesignationAndStatus(cmbDesigantion.Text, strEmployeeStatus);
if (dtblEmployee.Rows.Count > 0)
{
for (int i = 0; i < dtblEmployee.Rows.Count; i++)
{
dgvMonthlyAttendance.Rows.Add();
dgvMonthlyAttendance.Rows[i].Cells["employeeId"].Value = dtblEmployee.Rows[i]["employeeId"].ToString();
dgvMonthlyAttendance.Rows[i].Cells["SlNo"].Value = i + 1;
dgvMonthlyAttendance.Rows[i].Cells["employeeName"].Value = dtblEmployee.Rows[i]["employeeName"].ToString();
dgvMonthlyAttendance.Rows[i].Cells["employeeCode"].Value = dtblEmployee.Rows[i]["employeeCode"].ToString();
DataTable dtblStatus = spDailyAttendanceMaster.MonthlyAttendanceReportFill(dtpMonth.Value, Convert.ToDecimal(dtblEmployee.Rows[i]["employeeId"].ToString()));
if (dtblStatus.Rows.Count > 0)
{
for (int j = 0; j < dtblStatus.Rows.Count; j++)
{
dgvMonthlyAttendance.Rows[i].Cells[DateTime.Parse(dtblStatus.Rows[j]["date"].ToString()).Day.ToString()].Value = dtblStatus.Rows[j]["status"].ToString();
}
}
FindTotal(i);
}
}
CheckedChange();
}
}
catch (Exception ex)
{
MessageBox.Show("MAR2 " + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
dgvDailyAttendanceReport.DataSource = spDailyAttendanceMaster.DailyAttendanceViewForDailyAttendanceReport(dtpDate.Text.Trim(), cmbStatus.Text.Trim(), cmbEmployee.Text.Trim(), cmbDesignation.Text.Trim());
dgvDailyAttendanceReport.Columns["employeeId"].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show("DAR:4" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult Attendance()
{
ViewData["date"] = DateTime.UtcNow.ToString("yyyy-MM-dd");
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
if (spDailyAttendanceMaster.DailyAttendanceMasterMasterIdSearch(DateTime.Now.ToShortDateString().ToString()))
{
ViewData["btnText"] = "Update";
}
else
{
ViewData["btnText"] = "Save";
ViewData["btnDel"] = "disabled";
}
return(View());
}
//Function to edit
public void EditFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = DateTime.Parse(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
decMasterIdForEdit = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString()); //storing Dailymasterid
}
}
infoDailyAttendanceMaster.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceMaster.DailyAttendanceEditMaster(infoDailyAttendanceMaster);
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
// for updation of saved employees
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceDetailsId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceMasterId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
spDailyAttendanceDetails.DailyAttendanceDetailsEditUsingMasterId(infoDailyAttendanceDetails);
}
else
{
// for new employees to add
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
} // updation of old employees & addition of new employees closes here
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
decMasterIdForEdit = spDailyAttendanceMaster.DailyAttendanceAddToMaster(infoDailyAttendanceMaster); // calling @@identity
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
Messages.SavedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool EditFunction(string date, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(date);
infoDailyAttendanceMaster.Narration = string.Empty;
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
decimal decMasterIdForEdit = 0;
int inrowcount = items.Count;
for (int i = 0; i < inrowcount; i++)
{
string masterId = items[i]["masterId"].ToString() ?? string.Empty;
if (masterId != "")
{
decMasterIdForEdit = Convert.ToDecimal(masterId); //storing Dailymasterid
}
}
infoDailyAttendanceMaster.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceMaster.DailyAttendanceEditMaster(infoDailyAttendanceMaster);
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i < inrowcount; i++)
{
string detailsId = items[i]["detailsId"].ToString() ?? string.Empty;
string masterId = items[i]["masterId"].ToString() ?? string.Empty;
string employeeId = items[i]["employeeId"].ToString() ?? string.Empty;
string status = items[i]["status"].ToString() ?? string.Empty;
string narration = items[i]["narration"].ToString() ?? string.Empty;
narration = narration.Replace("\n", "\\n");
if (detailsId != "")
{
// for updation of saved employees
if (employeeId != null && employeeId != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (detailsId != null && detailsId != "")
{
infoDailyAttendanceDetails.DailyAttendanceDetailsId = Convert.ToDecimal(detailsId);
}
if (masterId != null && masterId != "")
{
infoDailyAttendanceDetails.DailyAttendanceMasterId = Convert.ToDecimal(masterId);
}
if (status != null && status != "")
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
spDailyAttendanceDetails.DailyAttendanceDetailsEditUsingMasterId(infoDailyAttendanceDetails);
}
else
{
// for new employees to add
if (employeeId != null && employeeId != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (status != null && status != "")
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
} // updation of old employees & addition of new employees closes here
}
catch (Exception ex)
{
return(false);
}
return(true);
}