/// <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); } }
private DataTable GetAttendenceFromDB(string strDate) { DataTable dtblAttendance = new DataTable(); try { DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo(); DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP(); DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo(); infoDailyAttendanceMaster.Date = Convert.ToDateTime(strDate); dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(strDate); for (int i = 0; i < dtblAttendance.Rows.Count; i++) { string status = dtblAttendance.Rows[i]["status"].ToString(); if (status == string.Empty) { dtblAttendance.Rows[i]["status"] = "Present"; } } } catch (Exception ex) { //MessageBox.Show("A1" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(dtblAttendance); }
public List <DataTable> DailyAttendanceDetailsSearchGridFill(string strDate) { List <DataTable> listObj = new List <DataTable>(); try { listObj = SpDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(strDate); } catch (Exception ex) { MessageBox.Show("A1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(listObj); }