/// <summary> /// /// </summary> /// <param name="infoAccountLedger"></param> /// <returns></returns> public decimal AccountLedgerAddWithIdentity(AccountLedgerInfo infoAccountLedger) { decimal decLedgerId = 0; try { decLedgerId = spAccountLedger.AccountLedgerAddWithIdentity(infoAccountLedger); } catch (Exception ex) { MessageBox.Show("AL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return decLedgerId; }
/// <summary> /// Account ledger edit for salesman /// </summary> /// <param name="accountledgerinfo"></param> public void AccountLedgerEditForSalesman(AccountLedgerInfo accountledgerinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerEditForSalesman", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@ledgerName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.LedgerName; sprmparam = sccmd.Parameters.Add("@openingBalance", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.OpeningBalance; sprmparam = sccmd.Parameters.Add("@crOrDr", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.CrOrDr; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Narration; sprmparam = sccmd.Parameters.Add("@mailingName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.MailingName; sprmparam = sccmd.Parameters.Add("@address", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Address; sprmparam = sccmd.Parameters.Add("@phone", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Phone; sprmparam = sccmd.Parameters.Add("@mobile", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Mobile; sprmparam = sccmd.Parameters.Add("@email", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Email; sprmparam = sccmd.Parameters.Add("@billByBill", SqlDbType.Bit); sprmparam.Value = accountledgerinfo.BillByBill; sprmparam = sccmd.Parameters.Add("@tin", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Tin; sprmparam = sccmd.Parameters.Add("@cst", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Cst; sprmparam = sccmd.Parameters.Add("@pan", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Pan; sprmparam = sccmd.Parameters.Add("@RouteId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.RouteId; sprmparam = sccmd.Parameters.Add("@bankAccountNumber", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BankAccountNumber; sprmparam = sccmd.Parameters.Add("@branchName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BranchName; sprmparam = sccmd.Parameters.Add("@branchCode", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BranchCode; sprmparam = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.AreaId; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = accountledgerinfo.ExtraDate; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to insert values to account ledger table and returns the id of inserted /// </summary> /// <param name="accountledgerinfo"></param> /// <returns></returns> public decimal AccountLedgerAddWithIdentity(AccountLedgerInfo accountledgerinfo) { decimal decLedgerId = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerAddWithIdentity", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@accountGroupId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.AccountGroupId; sprmparam = sccmd.Parameters.Add("@ledgerName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.LedgerName; sprmparam = sccmd.Parameters.Add("@openingBalance", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.OpeningBalance; sprmparam = sccmd.Parameters.Add("@crOrDr", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.CrOrDr; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Narration; sprmparam = sccmd.Parameters.Add("@mailingName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.MailingName; sprmparam = sccmd.Parameters.Add("@address", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Address; sprmparam = sccmd.Parameters.Add("@phone", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Phone; sprmparam = sccmd.Parameters.Add("@mobile", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Mobile; sprmparam = sccmd.Parameters.Add("@email", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Email; sprmparam = sccmd.Parameters.Add("@creditPeriod", SqlDbType.Int); sprmparam.Value = accountledgerinfo.CreditPeriod; sprmparam = sccmd.Parameters.Add("@creditLimit", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.CreditLimit; sprmparam = sccmd.Parameters.Add("@pricinglevelId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.PricinglevelId; sprmparam = sccmd.Parameters.Add("@billByBill", SqlDbType.Bit); sprmparam.Value = accountledgerinfo.BillByBill; sprmparam = sccmd.Parameters.Add("@tin", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Tin; sprmparam = sccmd.Parameters.Add("@cst", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Cst; sprmparam = sccmd.Parameters.Add("@pan", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Pan; sprmparam = sccmd.Parameters.Add("@RouteId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.RouteId; sprmparam = sccmd.Parameters.Add("@bankAccountNumber", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BankAccountNumber; sprmparam = sccmd.Parameters.Add("@branchName", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BranchName; sprmparam = sccmd.Parameters.Add("@branchCode", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.BranchCode; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = accountledgerinfo.Extra2; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = accountledgerinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@areaId", SqlDbType.Decimal); sprmparam.Value = accountledgerinfo.AreaId; sprmparam = sccmd.Parameters.Add("@isDefault", SqlDbType.Bit); sprmparam.Value = accountledgerinfo.IsDefault; object obj = sccmd.ExecuteScalar(); if (obj != null) { decLedgerId = Convert.ToDecimal(obj.ToString()); } else { decLedgerId = 0; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return decLedgerId; }
/// <summary> /// Account ledger view details for supplier /// </summary> /// <param name="ledgerId"></param> /// <returns></returns> public AccountLedgerInfo AccountLedgerViewForSupplier(decimal ledgerId) { AccountLedgerInfo accountledgerinfo = new AccountLedgerInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerViewForSupplier", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = ledgerId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { accountledgerinfo.LedgerId = Convert.ToDecimal(sdrreader[0].ToString()); accountledgerinfo.LedgerName = sdrreader[1].ToString(); accountledgerinfo.OpeningBalance = Convert.ToDecimal(sdrreader[2].ToString()); accountledgerinfo.CrOrDr = sdrreader[3].ToString(); accountledgerinfo.Narration = sdrreader[4].ToString(); accountledgerinfo.MailingName = sdrreader[5].ToString(); accountledgerinfo.Address = sdrreader[6].ToString(); accountledgerinfo.Phone = sdrreader[7].ToString(); accountledgerinfo.Mobile = sdrreader[8].ToString(); accountledgerinfo.Email = sdrreader[9].ToString(); accountledgerinfo.BillByBill = Convert.ToBoolean(sdrreader[10].ToString()); accountledgerinfo.Tin = sdrreader[11].ToString(); accountledgerinfo.Cst = sdrreader[12].ToString(); accountledgerinfo.Pan = sdrreader[13].ToString(); accountledgerinfo.RouteId = Convert.ToDecimal(sdrreader[14].ToString()); accountledgerinfo.BankAccountNumber = sdrreader[15].ToString(); accountledgerinfo.BranchName = sdrreader[16].ToString(); accountledgerinfo.BranchCode = sdrreader[17].ToString(); accountledgerinfo.AreaId = Convert.ToDecimal(sdrreader[18].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return accountledgerinfo; }
/// <summary> /// Function to view the account ledger details for perticular ledgerId for edit /// </summary> /// <param name="ledgerId"></param> /// <returns></returns> public AccountLedgerInfo AccountLedgerViewForEdit(decimal ledgerId) { AccountLedgerInfo accountledgerinfo = new AccountLedgerInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerViewForEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = ledgerId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { accountledgerinfo.LedgerId = decimal.Parse(sdrreader[0].ToString()); accountledgerinfo.AccountGroupId = decimal.Parse(sdrreader[1].ToString()); accountledgerinfo.LedgerName = sdrreader[2].ToString(); accountledgerinfo.OpeningBalance = decimal.Parse(sdrreader[3].ToString()); accountledgerinfo.CrOrDr = sdrreader[4].ToString(); accountledgerinfo.Narration = sdrreader[5].ToString(); accountledgerinfo.MailingName = sdrreader[6].ToString(); accountledgerinfo.Address = sdrreader[7].ToString(); accountledgerinfo.Phone = sdrreader[8].ToString(); accountledgerinfo.Mobile = sdrreader[9].ToString(); accountledgerinfo.Email = sdrreader[10].ToString(); accountledgerinfo.CreditPeriod = int.Parse(sdrreader[11].ToString()); accountledgerinfo.CreditLimit = decimal.Parse(sdrreader[12].ToString()); accountledgerinfo.PricinglevelId = decimal.Parse(sdrreader[13].ToString()); accountledgerinfo.BillByBill = bool.Parse(sdrreader[14].ToString()); accountledgerinfo.Tin = sdrreader[15].ToString(); accountledgerinfo.Cst = sdrreader[16].ToString(); accountledgerinfo.Pan = sdrreader[17].ToString(); accountledgerinfo.RouteId = decimal.Parse(sdrreader[18].ToString()); accountledgerinfo.BankAccountNumber = sdrreader[19].ToString(); accountledgerinfo.BranchName = sdrreader[20].ToString(); accountledgerinfo.BranchCode = sdrreader[21].ToString(); accountledgerinfo.ExtraDate = DateTime.Parse(sdrreader[22].ToString()); accountledgerinfo.Extra1 = sdrreader[23].ToString(); accountledgerinfo.Extra2 = sdrreader[24].ToString(); accountledgerinfo.AreaId = decimal.Parse(sdrreader[25].ToString()); accountledgerinfo.IsDefault = bool.Parse(sdrreader[26].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return accountledgerinfo; }
/// <summary> /// Account ledger details view by id /// </summary> /// <param name="ledgerId"></param> /// <returns></returns> public AccountLedgerInfo accountLedgerviewbyId(decimal ledgerId) { AccountLedgerInfo accountledgerinfo = new AccountLedgerInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = ledgerId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { accountledgerinfo.LedgerId = Convert.ToDecimal(sdrreader["ledgerId"].ToString()); accountledgerinfo.LedgerName = sdrreader["ledgerName"].ToString(); accountledgerinfo.CreditPeriod = Convert.ToInt32(sdrreader["creditPeriod"].ToString()); accountledgerinfo.PricinglevelId = Convert.ToDecimal(sdrreader["pricinglevelId"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return accountledgerinfo; }
/// <summary> /// Function to get particular values from account ledger table based on the parameter /// </summary> /// <param name="ledgerId"></param> /// <returns></returns> public AccountLedgerInfo AccountLedgerView(decimal ledgerId) { AccountLedgerInfo accountledgerinfo = new AccountLedgerInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AccountLedgerView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = ledgerId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { accountledgerinfo.LedgerId = Convert.ToDecimal(sdrreader["ledgerId"].ToString()); accountledgerinfo.AccountGroupId = Convert.ToDecimal(sdrreader["accountGroupId"].ToString()); accountledgerinfo.LedgerName = sdrreader["ledgerName"].ToString(); accountledgerinfo.OpeningBalance = Convert.ToDecimal(sdrreader["openingBalance"].ToString()); accountledgerinfo.CrOrDr = sdrreader["crOrDr"].ToString(); accountledgerinfo.Narration = sdrreader["narration"].ToString(); accountledgerinfo.MailingName = sdrreader["mailingName"].ToString(); accountledgerinfo.Address = sdrreader["address"].ToString(); accountledgerinfo.Phone = sdrreader["phone"].ToString(); accountledgerinfo.Mobile = sdrreader["mobile"].ToString(); accountledgerinfo.Email = sdrreader["email"].ToString(); accountledgerinfo.CreditPeriod = Convert.ToInt32(sdrreader["creditPeriod"].ToString()); accountledgerinfo.CreditLimit = Convert.ToDecimal(sdrreader["creditLimit"].ToString()); accountledgerinfo.PricinglevelId = Convert.ToDecimal(sdrreader["pricinglevelId"].ToString()); accountledgerinfo.BillByBill = Convert.ToBoolean(sdrreader["billByBill"].ToString()); accountledgerinfo.Tin = sdrreader["tin"].ToString(); accountledgerinfo.Cst = sdrreader["cst"].ToString(); accountledgerinfo.Pan = sdrreader["pan"].ToString(); accountledgerinfo.RouteId = Convert.ToDecimal(sdrreader["routeId"].ToString()); accountledgerinfo.BankAccountNumber = sdrreader["bankAccountNumber"].ToString(); accountledgerinfo.BranchName = sdrreader["branchName"].ToString(); accountledgerinfo.BranchCode = sdrreader["branchCode"].ToString(); accountledgerinfo.ExtraDate = Convert.ToDateTime(sdrreader["extraDate"].ToString()); accountledgerinfo.Extra1 = sdrreader["extra1"].ToString(); accountledgerinfo.Extra2 = sdrreader["extra2"].ToString(); accountledgerinfo.AreaId = Convert.ToDecimal(sdrreader["areaId"].ToString()); accountledgerinfo.IsDefault = Convert.ToBoolean(sdrreader["isDefault"].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return accountledgerinfo; }
public AccountLedgerInfo AccountLedgerViewForSupplier(decimal decLedgerId) { AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo(); try { infoAccountLedger = spAccountLedger.AccountLedgerViewForSupplier(decLedgerId); } catch (Exception ex) { MessageBox.Show("AL11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoAccountLedger; }
public AccountLedgerInfo accountLedgerviewbyId(decimal decledgerId) { AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo(); try { infoAccountLedger = spAccountLedger.accountLedgerviewbyId(decledgerId); } catch (Exception ex) { MessageBox.Show("AL38:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoAccountLedger; }
public void AccountLedgerEditForSalesman(AccountLedgerInfo infoAccountLedger) { try { spAccountLedger.AccountLedgerEditForSalesman(infoAccountLedger); } catch(Exception ex) { MessageBox.Show("AL32:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void AccountLedgerEditForCustomer(AccountLedgerInfo accountledgerinfo) { try { spAccountLedger.AccountLedgerEditForCustomer(accountledgerinfo); } catch (Exception ex) { MessageBox.Show("AL21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }