/// <summary> /// /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo infoPDCClearanceMaster= new PDCClearanceMasterInfo(); try { infoPDCClearanceMaster = spPDCClearanceMaster.PDCClearanceMasterView(PDCClearanceMasterId); } catch (Exception ex) { MessageBox.Show("PCRE11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoPDCClearanceMaster; }
/// <summary> /// /// </summary> /// <param name="pdcclearancemasterinfo"></param> public void PDCClearanceMasterEdit(PDCClearanceMasterInfo pdcclearancemasterinfo) { try { spPDCClearanceMaster.PDCClearanceMasterEdit(pdcclearancemasterinfo); } catch (Exception ex) { MessageBox.Show("PCRE9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// /// </summary> /// <param name="pdcclearancemasterinfo"></param> /// <returns></returns> public decimal PDCClearanceMasterAdd(PDCClearanceMasterInfo pdcclearancemasterinfo) { decimal decId = 0; try { decId = spPDCClearanceMaster.PDCClearanceMasterAdd(pdcclearancemasterinfo); } catch (Exception ex) { MessageBox.Show("PCRE8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decId; }
/// <summary> /// Function to get particular values from PDCClearanceMaster Table based on the parameter /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo pdcclearancemasterinfo = new PDCClearanceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PDCClearanceMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@PDCClearanceMasterId", SqlDbType.Decimal); sprmparam.Value = PDCClearanceMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { pdcclearancemasterinfo.PDCClearanceMasterId = decimal.Parse(sdrreader[0].ToString()); pdcclearancemasterinfo.VoucherNo = sdrreader[1].ToString(); pdcclearancemasterinfo.InvoiceNo = sdrreader[2].ToString(); pdcclearancemasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[3].ToString()); pdcclearancemasterinfo.Date = DateTime.Parse(sdrreader[4].ToString()); pdcclearancemasterinfo.LedgerId = decimal.Parse(sdrreader[5].ToString()); pdcclearancemasterinfo.Type = sdrreader[6].ToString(); pdcclearancemasterinfo.AgainstId = decimal.Parse(sdrreader[7].ToString()); pdcclearancemasterinfo.VoucherTypeId = decimal.Parse(sdrreader[8].ToString()); pdcclearancemasterinfo.Narration = sdrreader[9].ToString(); pdcclearancemasterinfo.Status = sdrreader[10].ToString(); pdcclearancemasterinfo.UserId = decimal.Parse(sdrreader[11].ToString()); pdcclearancemasterinfo.FinancialYearId = decimal.Parse(sdrreader[12].ToString()); pdcclearancemasterinfo.ExtraDate = DateTime.Parse(sdrreader[13].ToString()); pdcclearancemasterinfo.Extra1 = sdrreader[14].ToString(); pdcclearancemasterinfo.Extra2 = sdrreader[15].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return pdcclearancemasterinfo; }
/// <summary> /// Function to Update values in PDCClearanceMaster Table /// </summary> /// <param name="pdcclearancemasterinfo"></param> public void PDCClearanceMasterEdit(PDCClearanceMasterInfo pdcclearancemasterinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PDCClearanceMasterEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@PDCClearanceMasterId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.PDCClearanceMasterId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = pdcclearancemasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@type", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Type; sprmparam = sccmd.Parameters.Add("@againstId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.AgainstId; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@status", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Status; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to get particular values from PDCClearanceMaster Table based on the parameter /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo pdcclearancemasterinfo = new PDCClearanceMasterInfo(); try { pdcclearancemasterinfo = spPdcClearanceMaster.PDCClearanceMasterView(PDCClearanceMasterId); } catch (Exception ex) { MessageBox.Show("PDCC10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return pdcclearancemasterinfo; }