Beispiel #1
0
 /// <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);
     }
 }
Beispiel #2
0
 /// <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);
     }
 }
Beispiel #3
0
        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);
        }
Beispiel #4
0
 /// <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);
     }
 }
Beispiel #5
0
 /// <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);
     }
 }
Beispiel #6
0
 /// <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);
     }
 }
Beispiel #7
0
        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());
        }
Beispiel #8
0
        //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);
            }
        }
Beispiel #9
0
        /// <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);
            }
        }
Beispiel #10
0
        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);
        }