/// <summary> /// Function to get particular values from DailySalaryVoucherDetails table based on the parameter /// </summary> /// <param name="dailySalaryVoucherDetailsId"></param> /// <returns></returns> public DailySalaryVoucherDetailsInfo DailySalaryVoucherDetailsView(decimal dailySalaryVoucherDetailsId) { DailySalaryVoucherDetailsInfo dailysalaryvoucherdetailsinfo = new DailySalaryVoucherDetailsInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DailySalaryVoucherDetailsView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@dailySalaryVoucherDetailsId", SqlDbType.Decimal); sprmparam.Value = dailySalaryVoucherDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { dailysalaryvoucherdetailsinfo.DailySalaryVoucherDetailsId = decimal.Parse(sdrreader[0].ToString()); dailysalaryvoucherdetailsinfo.DailySalaryVocherMasterId = decimal.Parse(sdrreader[1].ToString()); dailysalaryvoucherdetailsinfo.EmployeeId = decimal.Parse(sdrreader[2].ToString()); dailysalaryvoucherdetailsinfo.Wage = decimal.Parse(sdrreader[3].ToString()); dailysalaryvoucherdetailsinfo.Status = sdrreader[4].ToString(); dailysalaryvoucherdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString()); dailysalaryvoucherdetailsinfo.Extra1 = sdrreader[6].ToString(); dailysalaryvoucherdetailsinfo.Extra2 = sdrreader[7].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(dailysalaryvoucherdetailsinfo); }
/// <summary> /// Function to Update values in DailySalaryVoucherDetails Table /// </summary> /// <param name="dailysalaryvoucherdetailsinfo"></param> public void DailySalaryVoucherDetailsEdit(DailySalaryVoucherDetailsInfo dailysalaryvoucherdetailsinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DailySalaryVoucherDetailsEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@dailySalaryVoucherDetailsId", SqlDbType.Decimal); sprmparam.Value = dailysalaryvoucherdetailsinfo.DailySalaryVoucherDetailsId; sprmparam = sccmd.Parameters.Add("@dailySalaryVoucherMasterId", SqlDbType.Decimal); sprmparam.Value = dailysalaryvoucherdetailsinfo.DailySalaryVocherMasterId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = dailysalaryvoucherdetailsinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@wage", SqlDbType.Decimal); sprmparam.Value = dailysalaryvoucherdetailsinfo.Wage; sprmparam = sccmd.Parameters.Add("@status", SqlDbType.VarChar); sprmparam.Value = dailysalaryvoucherdetailsinfo.Status; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = dailysalaryvoucherdetailsinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = dailysalaryvoucherdetailsinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = dailysalaryvoucherdetailsinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function for Edit /// </summary> public void EditFunction() { try { DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo(); DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); infoMaster.DailySalaryVoucehrMasterId = decMasterIdforEdit; infoMaster.Date = Convert.ToDateTime(dtpDate.Value.ToString()); infoMaster.LedgerId = Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString()); infoMaster.Narration = txtNarration.Text; infoMaster.TotalAmount = Convert.ToDecimal(lblShowTotelamount.Text.ToString()); if (isAutomatic) { infoMaster.VoucherNo = strVoucherNo; } else { infoMaster.VoucherNo = txtVoucherNo.Text.Trim(); } if (isAutomatic) { infoMaster.InvoiceNo = strInvoiceNo; } else { infoMaster.InvoiceNo = txtVoucherNo.Text.Trim(); } infoMaster.Extra1 = string.Empty; infoMaster.Extra2 = string.Empty; infoMaster.SuffixPrefixId = decDailySuffixPrefixId; infoMaster.VoucherTypeId = decDailyVoucherTypeId; infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoMaster.SalaryDate = Convert.ToDateTime(dtpSalaryDate.Text.ToString()); infoDetails.Extra1 = string.Empty;// Fields not in design// infoDetails.Extra2 = string.Empty;// Fields not in design// spMaster.DailySalaryVoucherMasterEdit(infoMaster); int inRowCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inRowCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty) { infoDetails.EmployeeId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString() != string.Empty) { infoDetails.Wage = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty) { infoDetails.Status = dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() != string.Empty) { decimal DailySalaryVoucherDetailsId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtdailySalaryVoucherDetailsId"].Value.ToString()); spDetails.DailySalaryVoucherDetailsDelete(DailySalaryVoucherDetailsId); LedgerUpdate(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid" && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { infoDetails.DailySalaryVocherMasterId = decMasterIdforEdit; spDetails.DailySalaryVoucherDetailsAdd(infoDetails); //spMaster.DailySalaryVoucherMasterEdit(infoMaster); LedgerUpdate(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == string.Empty && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { spMaster.DailySalaryVoucherMasterEdit(infoMaster); LedgerUpdate(); } } if (spDetails.DailySalaryVoucherDetailsCount(decMasterIdforEdit) == 0) { spMaster.DailySalaryVoucherMasterDelete(decMasterIdforEdit); } Messages.UpdatedMessage(); Clear(); if (frmDailySalaryRegisterobj != null) { this.Close(); } } catch (Exception ex) { MessageBox.Show("DSV12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to Save /// </summary> public void SaveFunction() { try { DailySalaryVoucherMasterInfo infoMaster = new DailySalaryVoucherMasterInfo(); DailySalaryVoucherMasterSP spMaster = new DailySalaryVoucherMasterSP(); DailySalaryVoucherDetailsInfo infoDetails = new DailySalaryVoucherDetailsInfo(); DailySalaryVoucherDetailsSP spDetails = new DailySalaryVoucherDetailsSP(); //-------------In multi user case check whether salary is paying for the same persone--------------// int inCounts = dgvDailySalaryVoucher.RowCount; int incont = 0; decimal decVal = 0; for (int i = 0; i < inCounts; i++) { decVal = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) != "0") { strEployeeNames = strEployeeNames + spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) + ","; foreach (char ch in strEployeeNames) { if (ch == ',') { incont++; } } if (incont == 15) { incont = 0; strEployeeNames = strEployeeNames + Environment.NewLine; } } } if (spDetails.CheckWhetherDailySalaryAlreadyPaid(decVal, dtpSalaryDate.Value) != "0") { Messages.InformationMessage("Salary already paid for - " + " " + strEployeeNames); DailySalaryVoucherDetailsGridfill(isEditmode); } else { if (isAutomatic) { infoMaster.VoucherNo = strVoucherNo; } else { infoMaster.VoucherNo = txtVoucherNo.Text.Trim(); } infoMaster.Date = DateTime.Parse(dtpDate.Text.ToString()); infoMaster.SalaryDate = DateTime.Parse(dtpSalaryDate.Text.ToString()); infoMaster.LedgerId = Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString()); infoMaster.Narration = txtNarration.Text.Trim(); infoMaster.TotalAmount = Convert.ToDecimal(lblShowTotelamount.Text.ToString()); infoMaster.Extra1 = string.Empty; // Fields not in design// infoMaster.Extra2 = string.Empty; // Fields not in design// if (isAutomatic) { infoMaster.InvoiceNo = strInvoiceNo; } else { infoMaster.InvoiceNo = txtVoucherNo.Text.Trim(); } infoMaster.SuffixPrefixId = decDailySuffixPrefixId; infoMaster.VoucherTypeId = decDailyVoucherTypeId; infoMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; int inval = 0; int inCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid") { inval++; } } if (inval >= 0) { //-------------checks Voucher No. repeating in Multi user case----------// DataTable dtbl = new DataTable(); dtbl = spMaster.DailySalaryVoucherMasterAddWithIdentity(infoMaster, isAutomatic); foreach (DataRow dr in dtbl.Rows) { decMasterId = Convert.ToDecimal(dr.ItemArray[0].ToString()); strUpdatedVoucherNo = dr.ItemArray[1].ToString(); strUpdatedInvoiceNo = dr.ItemArray[2].ToString(); } if (!isAutomatic) { strVoucherNo = txtVoucherNo.Text; } if (isAutomatic) { if (Convert.ToDecimal(strUpdatedVoucherNo) != Convert.ToDecimal(strVoucherNo)) { Messages.InformationMessage("Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNo); strVoucherNo = strUpdatedVoucherNo.ToString(); strInvoiceNo = strUpdatedInvoiceNo; } } //-------------------------------------// LedgerPosting(Convert.ToDecimal(cmbCashorBankAccount.SelectedValue.ToString())); infoDetails.DailySalaryVocherMasterId = decMasterId; infoDetails.Extra1 = string.Empty;// Fields not in design// infoDetails.Extra2 = string.Empty;// Fields not in design// int inRowCount = dgvDailySalaryVoucher.RowCount; for (int i = 0; i < inRowCount; i++) { if (dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString() != string.Empty) { infoDetails.EmployeeId = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtEmployeeId"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString() != string.Empty) { infoDetails.Wage = Convert.ToDecimal(dgvDailySalaryVoucher.Rows[i].Cells["txtWage"].Value.ToString()); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value != null && dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() != string.Empty) { infoDetails.Status = dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString(); } if (dgvDailySalaryVoucher.Rows[i].Cells["cmbStatus"].Value.ToString() == "paid" && dgvDailySalaryVoucher.Rows[i].Cells["dgvtxtDailySalaryVocherMasterId"].Value.ToString() == string.Empty) { infoDetails.DailySalaryVocherMasterId = decMasterId; spDetails.DailySalaryVoucherDetailsAdd(infoDetails); } } Messages.SavedMessage(); DailySalaryVoucherDetailsGridfill(isEditmode); Clear(); } else { strVoucherNo = spMaster.DailySalaryVoucherMasterGetMax(decDailyVoucherTypeId); Messages.InformationMessage("Can't save without atleast one employee"); Clear(); } } } catch (Exception ex) { MessageBox.Show("DSV11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from DailySalaryVoucherDetails table based on the parameter /// </summary> /// <param name="dailySalaryVoucherDetailsId"></param> /// <returns></returns> public DailySalaryVoucherDetailsInfo DailySalaryVoucherDetailsView(decimal dailySalaryVoucherDetailsId) { DailySalaryVoucherDetailsInfo dailysalaryvoucherdetailsinfo = new DailySalaryVoucherDetailsInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("DailySalaryVoucherDetailsView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@dailySalaryVoucherDetailsId", SqlDbType.Decimal); sprmparam.Value = dailySalaryVoucherDetailsId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { dailysalaryvoucherdetailsinfo.DailySalaryVoucherDetailsId = decimal.Parse(sdrreader[0].ToString()); dailysalaryvoucherdetailsinfo.DailySalaryVocherMasterId = decimal.Parse(sdrreader[1].ToString()); dailysalaryvoucherdetailsinfo.EmployeeId = decimal.Parse(sdrreader[2].ToString()); dailysalaryvoucherdetailsinfo.Wage = decimal.Parse(sdrreader[3].ToString()); dailysalaryvoucherdetailsinfo.Status = sdrreader[4].ToString(); dailysalaryvoucherdetailsinfo.ExtraDate = DateTime.Parse(sdrreader[5].ToString()); dailysalaryvoucherdetailsinfo.Extra1 = sdrreader[6].ToString(); dailysalaryvoucherdetailsinfo.Extra2 = sdrreader[7].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return dailysalaryvoucherdetailsinfo; }