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);
}
public decimal DailyAttendanceAddToMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
decimal incount = 0;
try
{
incount = SpDailyAttendanceMaster.DailyAttendanceAddToMaster(dailyattendancemasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("A8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(incount);
}
/// <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);
}
}