internal System.Data.DataTable GetActiveCompany(Tech.LumexDBPlayer db) { try { DataTable dt = db.ExecuteDataTable("GET_ACTIVE_COMPANY_LIST", false); return dt; } catch (Exception) { throw; } }
internal System.Data.DataTable SaveOpenningBalance(BLL.OpenningBalanceBLL openningBalanceBLL, Tech.LumexDBPlayer db) { try { DataTable dt=new DataTable(); if (openningBalanceBLL.PayToFromType == "ven") { db.AddParameters("@WarehouseId", openningBalanceBLL.OfficeBranchId.Trim()); db.AddParameters("@PurchaseRequisitionId", ""); db.AddParameters("@PurchaseOrderId", ""); db.AddParameters("@VendorId", openningBalanceBLL.PayToFromCompany); db.AddParameters("@VendorOrderDate", openningBalanceBLL.TransectionDate); db.AddParameters("@VendorOrderNumber", ""); db.AddParameters("@VendorInvoiceNumber",""); db.AddParameters("@ReceivedDate", ""); db.AddParameters("@TotalAmount", openningBalanceBLL.Amount); //db.AddParameters("@VAT", purchaseRecord.VAT.Trim()); db.AddParameters("@DiscountAmount", "0.00"); if (openningBalanceBLL.Type == "Rec") { db.AddParameters("@TotalPayable", "0.00"); db.AddParameters("@PaidAmount", openningBalanceBLL.Amount); db.AddParameters("@Narration", "Purchase Entry for Opening Balance Receivable Amount. "+openningBalanceBLL.Naretion); } else { db.AddParameters("@TotalPayable", openningBalanceBLL.Amount); db.AddParameters("@PaidAmount", "0.00"); db.AddParameters("@Narration", "Purchase Entry for Opening Balance Payable Amount. "+ openningBalanceBLL.Naretion); } db.AddParameters("@TransportCost", "0.00"); db.AddParameters("@LCNumber", ""); db.AddParameters("@TransportType", ""); db.AddParameters("@ShippingAddress", ""); db.AddParameters("@BillingAddress",""); db.AddParameters("@PaymentMode", ""); db.AddParameters("@AccountId", "A45"); db.AddParameters("@Bank", ""); db.AddParameters("@BankBranch", ""); db.AddParameters("@ChequeNumber", ""); db.AddParameters("@ChequeDate",""); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); dt = db.ExecuteDataTable("INSERT_WAREHOUSE_PURCHASE_RECORD_FOR_OPENING", true); } else if (openningBalanceBLL.PayToFromType == "cus") { db.AddParameters("@CustomerId", openningBalanceBLL.PayToFromCompany.Trim()); db.AddParameters("@CustomerName", openningBalanceBLL.PayToFromCompanyName); db.AddParameters("@CustomerContactNumber", ""); db.AddParameters("@CustomerAddress", ""); db.AddParameters("@SalesCenterId", openningBalanceBLL.OfficeBranchId); db.AddParameters("@TotalAmount", openningBalanceBLL.Amount); db.AddParameters("@DiscountAmount", "0.00"); db.AddParameters("@VAT", "0.00"); if (openningBalanceBLL.Type == "Rec") { db.AddParameters("@TotalReceivable", openningBalanceBLL.Amount); db.AddParameters("@ReceivedAmount", "0.00"); db.AddParameters("@Narration", "Sales Entry for Opening Balance Receivable Amount. "+openningBalanceBLL.Naretion); } else { db.AddParameters("@TotalReceivable", "0.00"); db.AddParameters("@ReceivedAmount", openningBalanceBLL.Amount); db.AddParameters("@Narration", "Sales Entry for Opening Balance Payable Amount. "+openningBalanceBLL.Naretion); } db.AddParameters("@ChangeAmount", "0.00"); db.AddParameters("@TotalVATAmount", "0.00"); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); db.AddParameters("@SalesOrderId", ""); //New Add db.AddParameters("@PaymentMode", ""); db.AddParameters("@AccountId", "A45"); db.AddParameters("@Bank", ""); db.AddParameters("@BankBranch", ""); db.AddParameters("@ChequeNumber", ""); db.AddParameters("@ChequeDate", ""); db.AddParameters("@OthersDes", ""); db.AddParameters("@OthersAmount", "0.00"); // dt = db.ExecuteDataTable("[INSERT_RETAIL_SALES_RECORD_FOR_OPENING]", true); } //db.AddParameters("@AccountId",openningBalanceBLL.AccountId); //db.AddParameters("@Amount",openningBalanceBLL.Amount); //db.AddParameters("@OfficeBranchId", openningBalanceBLL.OfficeBranchId); //db.AddParameters("@DebitCredit",openningBalanceBLL.DebitOrCredit); //db.AddParameters("@PayToFromCompany",openningBalanceBLL.PayToFromCompany); //db.AddParameters("@Narration",openningBalanceBLL.Naretion); //db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); //db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); //db.AddParameters("@TransectionDate",openningBalanceBLL.TransectionDate); //db.AddParameters("@IsRecPay",openningBalanceBLL.Type); //DataTable dt = db.ExecuteDataTable("INSERT_OPANING_BALANCE_LEDGER_WISE", true); return dt; } catch (Exception) { throw; } finally { openningBalanceBLL = null; } }