/// <summary> /// Function to view type of voucher based on parameter /// </summary> /// <param name="decVoucherTypeId"></param> /// <returns></returns> public VoucherTypeInfo TypeOfVoucherBasedOnVoucherTypeId(decimal decVoucherTypeId) { SqlDataReader sdrReader = null; VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sqlcmd = new SqlCommand("TypeOfVoucherBasedOnVoucherTypeId", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal).Value = decVoucherTypeId; sdrReader = sqlcmd.ExecuteReader(); while (sdrReader.Read()) { infoVoucherType.TypeOfVoucher = sdrReader["typeOfVoucher"].ToString(); } } catch (Exception ex) { MessageBox.Show("VTSP:1" + ex.Message, "Oneaccount", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { sdrReader.Close(); sqlcon.Close(); } return(infoVoucherType); }
/// <summary> /// Function to fill the order no combobox based on the deliverymode /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmbDeliveryMode_SelectedValueChanged(object sender, EventArgs e) { try { if (cmbDeliveryMode.SelectedIndex != 0) { cmbOrderNo.Enabled = true; DataTable dtbl = new DataTable(); if (cmbDeliveryMode.SelectedValue.ToString() != "System.Data.DataRowView") { decVoucherTypes = Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString()); } if (cmbVoucherType.SelectedValue != null) { infoVoucherType = spVoucherType.TypeOfVoucherBasedOnVoucherTypeId(Convert.ToDecimal(cmbDeliveryMode.SelectedValue.ToString())); strTypeOfVoucher = infoVoucherType.TypeOfVoucher; AgainstOrderComboFill(); } } else { cmbOrderNo.DataSource = null; cmbOrderNo.Enabled = false; } } catch (Exception ex) { formMDI.infoError.ErrorString = "DNREP12:" + ex.Message; } }
/// <summary> /// Function to insert values to table and return id /// </summary> /// <param name="vouchertypeinfo"></param> /// <returns></returns> public decimal VoucherTypeAddWithIdentity(VoucherTypeInfo vouchertypeinfo) { decimal decVoucherTypeId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("VoucherTypeAddWithIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherTypeName", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.VoucherTypeName; sprmparam = sccmd.Parameters.Add("@typeOfVoucher", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.TypeOfVoucher; sprmparam = sccmd.Parameters.Add("@methodOfVoucherNumbering", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.MethodOfVoucherNumbering; sprmparam = sccmd.Parameters.Add("@isTaxApplicable", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsTaxApplicable; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Extra2; sprmparam = sccmd.Parameters.Add("@isActive", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsActive; sprmparam = sccmd.Parameters.Add("@IsDefault", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsDefault; sprmparam = sccmd.Parameters.Add("@masterId", SqlDbType.Int); sprmparam.Value = vouchertypeinfo.MasterId; sprmparam = sccmd.Parameters.Add("@declaration", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Declarartion; sprmparam = sccmd.Parameters.Add("@heading1", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading1; sprmparam = sccmd.Parameters.Add("@heading2", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading2; sprmparam = sccmd.Parameters.Add("@heading3", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading3; sprmparam = sccmd.Parameters.Add("@heading4", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading4; object obj = sccmd.ExecuteScalar(); if (obj != null) { decVoucherTypeId = Convert.ToDecimal(obj.ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(decVoucherTypeId); }
/// <summary> /// Function to Update values in VoucherType Table /// </summary> /// <param name="vouchertypeinfo"></param> public void VoucherTypeEdit(VoucherTypeInfo vouchertypeinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("VoucherTypeEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = vouchertypeinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@voucherTypeName", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.VoucherTypeName; sprmparam = sccmd.Parameters.Add("@typeOfVoucher", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.TypeOfVoucher; sprmparam = sccmd.Parameters.Add("@methodOfVoucherNumbering", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.MethodOfVoucherNumbering; sprmparam = sccmd.Parameters.Add("@isTaxApplicable", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsTaxApplicable; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Extra2; sprmparam = sccmd.Parameters.Add("@isActive", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsActive; sprmparam = sccmd.Parameters.Add("@IsDefault", SqlDbType.Bit); sprmparam.Value = vouchertypeinfo.IsDefault; sprmparam = sccmd.Parameters.Add("@masterId", SqlDbType.Int); sprmparam.Value = vouchertypeinfo.MasterId; sprmparam = sccmd.Parameters.Add("@declaration", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Declarartion; sprmparam = sccmd.Parameters.Add("@heading1", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading1; sprmparam = sccmd.Parameters.Add("@heading2", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading2; sprmparam = sccmd.Parameters.Add("@heading3", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading3; sprmparam = sccmd.Parameters.Add("@heading4", SqlDbType.VarChar); sprmparam.Value = vouchertypeinfo.Heading4; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to view all VoucherTypes based on parameter /// </summary> /// <param name="voucherTypeId"></param> /// <returns></returns> public VoucherTypeInfo VoucherTypeView(decimal voucherTypeId) { VoucherTypeInfo vouchertypeinfo = new VoucherTypeInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("VoucherTypeView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = voucherTypeId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { vouchertypeinfo.VoucherTypeId = Convert.ToDecimal(sdrreader[0].ToString()); vouchertypeinfo.VoucherTypeName = sdrreader[1].ToString(); vouchertypeinfo.TypeOfVoucher = sdrreader[2].ToString(); vouchertypeinfo.MethodOfVoucherNumbering = sdrreader[3].ToString(); vouchertypeinfo.IsTaxApplicable = Convert.ToBoolean(sdrreader[4].ToString()); vouchertypeinfo.Narration = sdrreader[5].ToString(); vouchertypeinfo.ExtraDate = Convert.ToDateTime(sdrreader[6].ToString()); vouchertypeinfo.Extra1 = sdrreader[7].ToString(); vouchertypeinfo.Extra2 = sdrreader[8].ToString(); vouchertypeinfo.IsActive = Convert.ToBoolean(sdrreader[9].ToString()); vouchertypeinfo.MasterId = Convert.ToInt32(sdrreader[10].ToString()); vouchertypeinfo.Declarartion = sdrreader[11].ToString(); vouchertypeinfo.Heading1 = sdrreader[12].ToString(); vouchertypeinfo.Heading2 = sdrreader[13].ToString(); vouchertypeinfo.Heading3 = sdrreader[14].ToString(); vouchertypeinfo.Heading4 = sdrreader[15].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(vouchertypeinfo); }
/// <summary> /// Function to check method fo voucher numbering based on parameter /// </summary> /// <param name="voucherTypeId"></param> /// <returns></returns> public bool CheckMethodOfVoucherNumbering(decimal voucherTypeId) { VoucherTypeInfo infoVoucherType = new VoucherTypeInfo(); SqlDataReader sdrreader = null; bool isAutomatic = false; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("CheckMethodOfVoucherNumbering", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = voucherTypeId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { infoVoucherType.MethodOfVoucherNumbering = sdrreader["methodOfVoucherNumbering"].ToString(); } if (infoVoucherType.MethodOfVoucherNumbering == "Automatic") { isAutomatic = true; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(isAutomatic); }