//Function to edit
public void EditFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
AttendanceBll BllAttendance = new AttendanceBll();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
AttendanceBll BllAttendanceMaster = new AttendanceBll();
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;
BllAttendanceMaster.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;
BllAttendance.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;
BllAttendance.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();
AttendanceBll BllAttendance = new AttendanceBll();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
AttendanceBll BllAttendanceMaster = new AttendanceBll();
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 = BllAttendanceMaster.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;
BllAttendance.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);
}
}