/// <summary> /// Function to get values for Service VoucherTypeId By ServiceMasterId And VocherNo /// </summary> /// <param name="decServiceMasterId"></param> /// <param name="decVoucherNo"></param> /// <returns></returns> public ServiceMasterInfo GetServiceVoucherTypeIdByServiceMasterIdAndVocherNo(decimal decServiceMasterId, decimal decVoucherNo) { ServiceMasterInfo servicemasterinfo = new ServiceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("GetServiceVoucherTypeIdByServiceMasterIdAndVocherNo", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = decServiceMasterId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.Decimal); sprmparam.Value = decVoucherNo; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { servicemasterinfo.VoucherTypeId = decimal.Parse(sdrreader["voucherTypeId"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(servicemasterinfo); }
/// <summary> /// Function to Update values in ServiceMaster Table /// </summary> /// <param name="servicemasterinfo"></param> public void ServiceMasterEdit(ServiceMasterInfo servicemasterinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ServiceMasterEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ServiceMasterId; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = servicemasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.TotalAmount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@creditPeriod", SqlDbType.Int); sprmparam.Value = servicemasterinfo.CreditPeriod; sprmparam = sccmd.Parameters.Add("@serviceAccount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ServiceAccount; sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ExchangeRateId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@customer", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Customer; sprmparam = sccmd.Parameters.Add("@discount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.Discount; sprmparam = sccmd.Parameters.Add("@grandTotal", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.GrandTotal; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = servicemasterinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to get particular values from ServiceMaster Table based on the parameter /// </summary> /// <param name="serviceMasterId"></param> /// <returns></returns> public ServiceMasterInfo ServiceMasterView(decimal serviceMasterId) { ServiceMasterInfo servicemasterinfo = new ServiceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ServiceMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = serviceMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { servicemasterinfo.ServiceMasterId = decimal.Parse(sdrreader["serviceMasterId"].ToString()); servicemasterinfo.VoucherNo = sdrreader["voucherNo"].ToString(); servicemasterinfo.InvoiceNo = sdrreader["invoiceNo"].ToString(); servicemasterinfo.SuffixPrefixId = decimal.Parse(sdrreader["suffixPrefixId"].ToString()); servicemasterinfo.Date = DateTime.Parse(sdrreader["date"].ToString()); servicemasterinfo.LedgerId = decimal.Parse(sdrreader["ledgerId"].ToString()); servicemasterinfo.TotalAmount = decimal.Parse(sdrreader["totalAmount"].ToString()); servicemasterinfo.Narration = sdrreader["narration"].ToString(); servicemasterinfo.UserId = decimal.Parse(sdrreader["userId"].ToString()); servicemasterinfo.CreditPeriod = int.Parse(sdrreader["creditPeriod"].ToString()); servicemasterinfo.ServiceAccount = decimal.Parse(sdrreader["serviceAccount"].ToString()); servicemasterinfo.ExchangeRateId = decimal.Parse(sdrreader["exchangeRateId"].ToString()); servicemasterinfo.EmployeeId = Convert.ToDecimal(sdrreader["employeeId"].ToString()); servicemasterinfo.Customer = sdrreader["customer"].ToString(); servicemasterinfo.Discount = decimal.Parse(sdrreader["discount"].ToString()); servicemasterinfo.GrandTotal = decimal.Parse(sdrreader["grandTotal"].ToString()); servicemasterinfo.VoucherTypeId = decimal.Parse(sdrreader["voucherTypeId"].ToString()); servicemasterinfo.FinancialYearId = decimal.Parse(sdrreader["financialYearId"].ToString()); servicemasterinfo.ExtraDate = DateTime.Parse(sdrreader["extraDate"].ToString()); servicemasterinfo.Extra1 = sdrreader["extra1"].ToString(); servicemasterinfo.Extra2 = sdrreader["extra2"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(servicemasterinfo); }
/// <summary> /// Function to get values for Service VoucherTypeId By ServiceMasterId And VocherNo /// </summary> /// <param name="decServiceMasterId"></param> /// <param name="decVoucherNo"></param> /// <returns></returns> public ServiceMasterInfo GetServiceVoucherTypeIdByServiceMasterIdAndVocherNo(decimal decServiceMasterId, decimal decVoucherNo) { ServiceMasterInfo servicemasterinfo = new ServiceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("GetServiceVoucherTypeIdByServiceMasterIdAndVocherNo", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = decServiceMasterId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.Decimal); sprmparam.Value = decVoucherNo; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { servicemasterinfo.VoucherTypeId = decimal.Parse(sdrreader["voucherTypeId"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return servicemasterinfo; }
/// <summary> /// Function to insert values to ServiceMaster Table /// </summary> /// <param name="servicemasterinfo"></param> /// <returns></returns> public decimal ServiceMasterAdd(ServiceMasterInfo servicemasterinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ServiceMasterAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ServiceMasterId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = servicemasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.TotalAmount; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@creditPeriod", SqlDbType.Int); sprmparam.Value = servicemasterinfo.CreditPeriod; sprmparam = sccmd.Parameters.Add("@serviceAccount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ServiceAccount; sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.ExchangeRateId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@customer", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Customer; sprmparam = sccmd.Parameters.Add("@discount", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.Discount; sprmparam = sccmd.Parameters.Add("@grandTotal", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.GrandTotal; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = servicemasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = servicemasterinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = servicemasterinfo.Extra2; decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decIdentity; }
/// <summary> /// Function to get particular values from ServiceMaster Table based on the parameter /// </summary> /// <param name="serviceMasterId"></param> /// <returns></returns> public ServiceMasterInfo ServiceMasterView(decimal serviceMasterId) { ServiceMasterInfo servicemasterinfo = new ServiceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ServiceMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@serviceMasterId", SqlDbType.Decimal); sprmparam.Value = serviceMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { servicemasterinfo.ServiceMasterId = decimal.Parse(sdrreader["serviceMasterId"].ToString()); servicemasterinfo.VoucherNo = sdrreader["voucherNo"].ToString(); servicemasterinfo.InvoiceNo = sdrreader["invoiceNo"].ToString(); servicemasterinfo.SuffixPrefixId = decimal.Parse(sdrreader["suffixPrefixId"].ToString()); servicemasterinfo.Date = DateTime.Parse(sdrreader["date"].ToString()); servicemasterinfo.LedgerId = decimal.Parse(sdrreader["ledgerId"].ToString()); servicemasterinfo.TotalAmount = decimal.Parse(sdrreader["totalAmount"].ToString()); servicemasterinfo.Narration = sdrreader["narration"].ToString(); servicemasterinfo.UserId = decimal.Parse(sdrreader["userId"].ToString()); servicemasterinfo.CreditPeriod = int.Parse(sdrreader["creditPeriod"].ToString()); servicemasterinfo.ServiceAccount = decimal.Parse(sdrreader["serviceAccount"].ToString()); servicemasterinfo.ExchangeRateId = decimal.Parse(sdrreader["exchangeRateId"].ToString()); servicemasterinfo.EmployeeId = Convert.ToDecimal(sdrreader["employeeId"].ToString()); servicemasterinfo.Customer = sdrreader["customer"].ToString(); servicemasterinfo.Discount = decimal.Parse(sdrreader["discount"].ToString()); servicemasterinfo.GrandTotal = decimal.Parse(sdrreader["grandTotal"].ToString()); servicemasterinfo.VoucherTypeId = decimal.Parse(sdrreader["voucherTypeId"].ToString()); servicemasterinfo.FinancialYearId = decimal.Parse(sdrreader["financialYearId"].ToString()); servicemasterinfo.ExtraDate = DateTime.Parse(sdrreader["extraDate"].ToString()); servicemasterinfo.Extra1 = sdrreader["extra1"].ToString(); servicemasterinfo.Extra2 = sdrreader["extra2"].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return servicemasterinfo; }
/// <summary> /// Function to save the service voucher /// </summary> public void SaveFunction() { try { ServiceMasterInfo infoServiceMaster = new ServiceMasterInfo(); ServiceMasterSP spServiceMaster = new ServiceMasterSP(); ServiceDetailsInfo infoServiceDetails = new ServiceDetailsInfo(); ServiceDetailsSP spServiceDetails = new ServiceDetailsSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo(); ExchangeRateSP spExchangeRate = new ExchangeRateSP(); int inRowCount = dgvServiceVoucher.RowCount; int inValue = 0; for (int ini = 0; ini < inRowCount - 1; ini++) { if (dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty) { inValue++; } } if (inValue > 0) { txtDiscount.Enabled = true; infoServiceMaster.InvoiceNo = txtInvoiceNumber.Text; if (isAutomatic) { infoServiceMaster.VoucherNo = strVoucherNo; } else { infoServiceMaster.VoucherNo = Convert.ToString(spServiceMaster.ServiceMasterGetMax(DecServicetVoucherTypeId) + 1); } infoServiceMaster.SuffixPrefixId = decServiceSuffixPrefixId; infoServiceMaster.Date = Convert.ToDateTime(txtVoucherDate.Text); infoServiceMaster.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); infoServiceMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text); infoServiceMaster.Narration = txtNarration.Text.Trim(); infoServiceMaster.UserId = PublicVariables._decCurrentUserId; infoServiceMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text); infoServiceMaster.ServiceAccount = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString()); decimal decExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());//spExchangeRate.GetExchangeRateByCurrencyId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString())); infoServiceMaster.ExchangeRateId = decExchangeRateId; infoServiceMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString()); infoServiceMaster.Customer = txtCustomer.Text.Trim(); infoServiceMaster.Discount = Convert.ToDecimal(txtDiscount.Text.Trim()); infoServiceMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text); infoServiceMaster.VoucherTypeId = DecServicetVoucherTypeId; infoServiceMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoServiceMaster.ExtraDate = PublicVariables._dtCurrentDate; infoServiceMaster.Extra1 = string.Empty; infoServiceMaster.Extra2 = string.Empty; decServiceMasterId = spServiceMaster.ServiceMasterAddReturnWithIdentity(infoServiceMaster); infoServiceDetails.ServiceMasterId = decServiceMasterId; infoServiceDetails.Extra1 = string.Empty; infoServiceDetails.Extra2 = string.Empty; infoServiceDetails.ExtraDate = PublicVariables._dtCurrentDate; for (int i = 0; i < inRowCount - 1; i++) { if (dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty) { infoServiceDetails.ServiceId = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString()); } if (dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString() != string.Empty) { infoServiceDetails.Measure = dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString(); } if (dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { infoServiceDetails.Amount = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); decAmount += Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value); } decServiceDetailsId = spServiceDetails.ServiceDetailsAddReturnWithIdentity(infoServiceDetails); } decSelectedCurrencyRate = spExchangeRate.GetExchangeRateByExchangeRateId(infoServiceMaster.ExchangeRateId); decConvertRate = decAmount * decSelectedCurrencyRate; decCredit = 0; decDebit = decConvertRate; decLedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); LedgerPosting(decLedgerId, decCredit, decDebit, decServiceDetailsId, infoServiceMaster.VoucherNo); AccountLedgerSP spAccountLedger = new AccountLedgerSP(); decimal decI = Convert.ToDecimal(spAccountLedger.AccountGroupIdCheck(cmbCashParty.Text)); if (decI > 0) { PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo(); PartyBalanceSP spPartyBalance = new PartyBalanceSP(); infoPartyBalance.Date = Convert.ToDateTime(txtVoucherDate.Text); infoPartyBalance.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); infoPartyBalance.VoucherTypeId = DecServicetVoucherTypeId; infoPartyBalance.VoucherNo = strVoucherNo; infoPartyBalance.AgainstVoucherTypeId = 0; infoPartyBalance.AgainstVoucherNo = "0"; infoPartyBalance.InvoiceNo = strInvoiceNo; infoPartyBalance.AgainstInvoiceNo = "0"; infoPartyBalance.ReferenceType = "New"; infoPartyBalance.Debit = decAmount; infoPartyBalance.Credit = 0; infoPartyBalance.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text); infoPartyBalance.ExchangeRateId = decExchangeRateId; infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoPartyBalance.Extra1 = string.Empty; infoPartyBalance.Extra2 = string.Empty; spPartyBalance.PartyBalanceAdd(infoPartyBalance); } Messages.SavedMessage(); if (cbxPrintAfterSave.Checked) { if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decServiceMasterId); } else { Print(decServiceMasterId, infoServiceMaster.ExchangeRateId); } } Clear(); } else { Messages.InformationMessage("Can't save Service Voucher without atleast one ledger with complete details"); dgvServiceVoucher.ClearSelection(); dgvServiceVoucher.CurrentCell = dgvServiceVoucher.Rows[0].Cells["dgvcmbParticulars"]; dgvServiceVoucher.Rows[0].Cells["dgvcmbParticulars"].Selected = true; } } catch (Exception ex) { MessageBox.Show("SV 19 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill the fields for edit or delete /// </summary> public void FillFunction() { try { ServiceDetailsSP spServiceDetails = new ServiceDetailsSP(); ServiceMasterSP spServiceMaster = new ServiceMasterSP(); ServiceMasterInfo infoServiceMaster = new ServiceMasterInfo(); LedgerPostingSP SpLedgerPosting = new LedgerPostingSP(); VoucherTypeSP spVoucherType = new VoucherTypeSP(); VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); PartyBalanceSP spPartyBalance = new PartyBalanceSP(); PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo(); decServiceMasterId = decMasterId; infoServiceMaster = spServiceMaster.ServiceMasterView(decServiceMasterId); infoVoucherType = spVoucherType.VoucherTypeView(infoServiceMaster.VoucherTypeId); this.Text = infoVoucherType.VoucherTypeName; isAutomatic = spVoucherType.CheckMethodOfVoucherNumbering(infoServiceMaster.VoucherTypeId); txtInvoiceNumber.ReadOnly = true; strVoucherNo = infoServiceMaster.VoucherNo.ToString(); txtInvoiceNumber.Text = infoServiceMaster.InvoiceNo; txtCreditPeriod.Text = infoServiceMaster.CreditPeriod.ToString(); strInvoiceNo = infoServiceMaster.InvoiceNo.ToString(); decServiceSuffixPrefixId = Convert.ToDecimal(infoServiceMaster.SuffixPrefixId.ToString()); DecServicetVoucherTypeId = Convert.ToDecimal(infoServiceMaster.VoucherTypeId.ToString()); int inDecimalPlace = PublicVariables._inNoOfDecimalPlaces; txtVoucherDate.Text = infoServiceMaster.Date.ToString("dd-MMM-yyyy"); dtpVoucherDate.Value = Convert.ToDateTime(infoServiceMaster.Date); cmbCashParty.SelectedValue = infoServiceMaster.LedgerId; cmbServiceAC.SelectedValue = infoServiceMaster.ServiceAccount; cmbSalesman.SelectedValue = infoServiceMaster.EmployeeId; txtCustomer.Text = infoServiceMaster.Customer; txtNarration.Text = infoServiceMaster.Narration; DataTable dtblServiceDetails = new DataTable(); dtblServiceDetails = spServiceDetails.ServiceDetailsViewWithMasterId(decServiceMasterId); for (int i = 0; i < dtblServiceDetails.Rows.Count; i++) { dgvServiceVoucher.Rows.Add(); dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value = Convert.ToDecimal(dtblServiceDetails.Rows[i]["serviceDetailsId"].ToString()); dgvServiceVoucher.Rows[i].Cells["dgvtxtServiceMasterId"].Value = Convert.ToDecimal(dtblServiceDetails.Rows[i]["serviceMasterId"].ToString()); dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value = Convert.ToDecimal(dtblServiceDetails.Rows[i]["serviceId"].ToString()); dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value = dtblServiceDetails.Rows[i]["measure"].ToString(); dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value = dtblServiceDetails.Rows[i]["amount"].ToString(); decimal decDetailsId1 = Convert.ToDecimal(dtblServiceDetails.Rows[i]["serviceDetailsId"].ToString()); decimal decLedgerPostingId = SpLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, DecServicetVoucherTypeId); dgvServiceVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString(); } cmbCurrency.SelectedValue = infoServiceMaster.ExchangeRateId; txtTotalAmount.Text = infoServiceMaster.TotalAmount.ToString(); txtDiscount.Text = infoServiceMaster.Discount.ToString(); txtGrandTotal.Text = infoServiceMaster.GrandTotal.ToString(); infoPartyBalance = spPartyBalance.PartyBalanceViewByVoucherNoAndVoucherTypeId(DecServicetVoucherTypeId, strVoucherNo, infoServiceMaster.Date); decPartyBalanceId = infoPartyBalance.PartyBalanceId; } catch (Exception ex) { MessageBox.Show("SV 32 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to edit the service voucher /// </summary> /// <param name="decServiceMasterId"></param> public void EditFunction(decimal decServiceMasterId) { try { ServiceMasterInfo infoServiceMaster = new ServiceMasterInfo(); ServiceMasterSP spServiceMaster = new ServiceMasterSP(); ServiceDetailsInfo infoServiceDetails = new ServiceDetailsInfo(); ServiceDetailsSP spServiceDetails = new ServiceDetailsSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo(); ExchangeRateSP spExchangeRate = new ExchangeRateSP(); int inRowCount = dgvServiceVoucher.RowCount; int inValue = 0; decimal decLedgerPostingId1 = 0; decimal decLedgerPostingId2 = 0; DataTable dtblLedgerPostingId = new DataTable(); dtblLedgerPostingId = spServiceMaster.LedgerPostingIdByServiceMaasterId(decServiceMasterId); decLedgerPostingId1 = Convert.ToDecimal(dtblLedgerPostingId.Rows[0]["ledgerPostingId"].ToString()); decLedgerPostingId2 = Convert.ToDecimal(dtblLedgerPostingId.Rows[1]["ledgerPostingId"].ToString()); for (int ini = 0; ini < inRowCount - 1; ini++) { if (dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[ini].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty) { inValue++; } } if (inValue > 0) { infoServiceMaster.ServiceMasterId = decServiceMasterId; infoServiceMaster.SuffixPrefixId = decServiceSuffixPrefixId; infoServiceMaster.Date = Convert.ToDateTime(txtVoucherDate.Text); infoServiceMaster.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); infoServiceMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text); infoServiceMaster.Narration = txtNarration.Text.Trim(); infoServiceMaster.UserId = PublicVariables._decCurrentUserId; infoServiceMaster.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text); infoServiceMaster.ServiceAccount = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString()); decimal decExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());//spExchangeRate.GetExchangeRateByCurrencyId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString())); infoServiceMaster.ExchangeRateId = decExchangeRateId; infoServiceMaster.EmployeeId = Convert.ToDecimal(cmbSalesman.SelectedValue.ToString()); infoServiceMaster.Customer = txtCustomer.Text.Trim(); infoServiceMaster.Discount = Convert.ToDecimal(txtDiscount.Text); infoServiceMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text); infoServiceMaster.VoucherTypeId = DecServicetVoucherTypeId; infoServiceMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoServiceMaster.ExtraDate = PublicVariables._dtCurrentDate; infoServiceMaster.Extra1 = string.Empty; infoServiceMaster.Extra2 = string.Empty; //------------------deleting removed rows----------------------------------------// BankReconciliationSP spBankReconciliation = new BankReconciliationSP(); foreach (object obj in strArrOfRemove) { string str = Convert.ToString(obj); spServiceDetails.ServiceDetailsDelete(Convert.ToDecimal(str)); } spServiceMaster.ServiceMasterEdit(infoServiceMaster); infoServiceDetails.ServiceMasterId = decServiceMasterId; infoServiceDetails.Extra1 = string.Empty; infoServiceDetails.Extra2 = string.Empty; infoServiceDetails.ExtraDate = PublicVariables._dtCurrentDate; for (int i = 0; i < inRowCount - 1; i++) { if (dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString() != string.Empty) { infoServiceDetails.ServiceId = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value.ToString()); } if (dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString() != string.Empty) { infoServiceDetails.Measure = dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value.ToString(); } if (dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty) { infoServiceDetails.Amount = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString()); if (dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value != null && dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty) { infoServiceDetails.ServiceDetailsId = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString()); infoServiceDetails.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); spServiceDetails.ServiceDetailsEdit(infoServiceDetails); } else { infoServiceDetails.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()); decServiceDetailsId = spServiceDetails.ServiceDetailsAddReturnWithIdentity(infoServiceDetails); } decSelectedCurrencyRate = spExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString())); decAmount = Convert.ToDecimal(dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value); decConvertRate += decAmount * decSelectedCurrencyRate; } } decCredit = 0; decDebit = decConvertRate; decLedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); LedgerPostingEdit(decLedgerPostingId1, decLedgerId, decCredit, decDebit); decCredit = decConvertRate; decDebit = 0; decLedgerId = Convert.ToDecimal(cmbServiceAC.SelectedValue.ToString()); LedgerPostingEdit(decLedgerPostingId2, decLedgerId, decCredit, decDebit); AccountLedgerSP spAccountLedger = new AccountLedgerSP(); decimal decI = Convert.ToDecimal(spAccountLedger.AccountGroupIdCheck(cmbCashParty.Text)); if (decI > 0) { PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo(); PartyBalanceSP spPartyBalance = new PartyBalanceSP(); infoPartyBalance.PartyBalanceId = decPartyBalanceId; infoPartyBalance.Date = Convert.ToDateTime(txtVoucherDate.Text); infoPartyBalance.LedgerId = Convert.ToDecimal(cmbCashParty.SelectedValue.ToString()); infoPartyBalance.VoucherTypeId = DecServicetVoucherTypeId; infoPartyBalance.VoucherNo = strVoucherNo; infoPartyBalance.AgainstVoucherTypeId = 0; infoPartyBalance.AgainstVoucherNo = "0"; infoPartyBalance.InvoiceNo = strInvoiceNo; infoPartyBalance.AgainstInvoiceNo = "0"; infoPartyBalance.ReferenceType = "New"; infoPartyBalance.Debit = decAmount; infoPartyBalance.Credit = 0; infoPartyBalance.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text); infoPartyBalance.ExchangeRateId = decExchangeRateId; infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId; infoPartyBalance.Extra1 = string.Empty; infoPartyBalance.Extra2 = string.Empty; spPartyBalance.PartyBalanceEdit(infoPartyBalance); } Messages.UpdatedMessage(); if (cbxPrintAfterSave.Checked) { if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decServiceMasterId); } else { Print(decServiceMasterId, infoServiceMaster.ExchangeRateId); } } this.Close(); if (frmServiceVoucherRegisterObj != null) { frmServiceVoucherRegisterObj.Show(); frmServiceVoucherRegisterObj.GridFill(); } else if (frmServiceReportObj != null) { frmServiceReportObj.Show(); frmServiceReportObj.GridFill(); } } else { Messages.InformationMessage("Can't save Service Voucher without atleast one ledger with complete details"); } } catch (Exception ex) { MessageBox.Show("SV 24 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }