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