public void SaveData(List <CashBackRegBO> cashBackRegBos)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
// cashBackRegBo.SlNo = commonBAL.GenerateID("SBP_CashBack_Reg", "CB_ID");
queryString = @"SBPSaveCashBackReg";
try
{
_dbConnection.ConnectDatabase();
foreach (CashBackRegBO cashBackRegBo in cashBackRegBos)
{
_dbConnection.ActiveStoredProcedure();
// _dbConnection.AddParameter("@cbID", SqlDbType.Int, cashBackRegBo.SlNo);
_dbConnection.AddParameter("@sessionID", SqlDbType.Int, cashBackRegBo.SessionId);
_dbConnection.AddParameter("@custCode", SqlDbType.NVarChar, cashBackRegBo.CustCode);
_dbConnection.AddParameter("@planID", SqlDbType.Int, cashBackRegBo.PlanId);
_dbConnection.AddParameter("@planName", SqlDbType.VarChar, cashBackRegBo.PlanName);
_dbConnection.AddParameter("@cashbackamount", SqlDbType.Money, cashBackRegBo.CashBackAmount);
_dbConnection.AddParameter("@remark", SqlDbType.VarChar, cashBackRegBo.Remarks);
// _dbConnection.AddParameter("@entryDate", SqlDbType.DateTime, cashBackRegBo.EntryDate);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GetCustSummery(string custCode, DateTime fromDate, DateTime toDate)
{
_dbConnection.TimeoutPeriod = 3000;
DataTable dtCustSummery = null;
string quryString = "";
quryString = "SP_TaxCerfificate";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@custCode", SqlDbType.NVarChar, custCode);
_dbConnection.AddParameter("@dateFrom", SqlDbType.DateTime, fromDate.ToShortDateString());
_dbConnection.AddParameter("@dateTo", SqlDbType.DateTime, toDate.ToShortDateString());
dtCustSummery = _dbConnection.ExecuteProQuery(quryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dtCustSummery);
}
public void SaveOthersHoliday(HolidayBO holydayBo)
{
string queryString = "";
CommonBAL comBAL = new CommonBAL();
// holydayBo.SlNo = comBAL.GenerateID("SBP_Holiday", "Sl_No");
queryString = @"SBPSaveHoliday";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
//_dbConnection.AddParameter("@SlNo", SqlDbType.Int, holydayBo.SlNo);
_dbConnection.AddParameter("@HolydayDate", SqlDbType.DateTime, holydayBo.HolydayDate.ToShortDateString());
_dbConnection.AddParameter("@Purpose", SqlDbType.VarChar, holydayBo.Purpose);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public bool Check_All_Hide(int resourceId, int criteriaId)
{
bool result = false;
string queryString = @"GetIsAllHide";
DataTable data = new DataTable();
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@ResourceId", SqlDbType.Int, resourceId);
_dbConnection.AddParameter("@CriteriaId", SqlDbType.Int, criteriaId);
_dbConnection.AddParameter("@UserName", SqlDbType.VarChar, GlobalVariableBO._userName);
data = _dbConnection.ExecuteProQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
if (data.Rows.Count > 0)
{
if (data.Rows[0][0].ToString() != "0")
{
result = true;
}
}
return(result);
}
public DataTable GetIPOCustSummeryLedger(string custCode, DateTime fromDate, DateTime toDate)
{
DataTable dtShareDWReview = null;
string quryString = "";
quryString = @"RptIPOGetCustomerSummeryLedger";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@custCode", SqlDbType.NVarChar, custCode);
_dbConnection.AddParameter("@fromDate", SqlDbType.DateTime, fromDate);
_dbConnection.AddParameter("@toDate", SqlDbType.DateTime, toDate);
dtShareDWReview = _dbConnection.ExecuteProQuery(quryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dtShareDWReview);
}
public DataTable GetBonusInstrumentConfirmationData(string instrumentID, DateTime fromDate, DateTime toDate, string Investor_ID, string BOID)
{
DataTable data = new DataTable();
try
{
string Query = @"rptBonus_Instrument_Confirmation_Report_DSE_21_2";
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Start_Date", SqlDbType.DateTime, fromDate);
_dbConnection.AddParameter("@End_Date", SqlDbType.DateTime, toDate);
_dbConnection.AddParameter("@Instrument_ID", SqlDbType.VarChar, instrumentID);
_dbConnection.AddParameter("@Investor_ID", SqlDbType.VarChar, Investor_ID);
_dbConnection.AddParameter("@BO_ID", SqlDbType.VarChar, BOID);
data = _dbConnection.ExecuteProQuery(Query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
this._dbConnection.CloseDatabase();
}
return(data);
}
///////////////////////////////////////////////////////////////////////////////////////////////////
public DataTable IPO_Money_Trns(String fromDate, string toDate)
{
DataTable dtPaymentReview = null;
string quryString = "";
quryString = @"Rpt_IPO_Money_Trns_ApplyTogether";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@fromDate", SqlDbType.DateTime, fromDate);
_dbConnection.AddParameter("@toDate", SqlDbType.DateTime, toDate);
dtPaymentReview = _dbConnection.ExecuteProQuery(quryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dtPaymentReview);
}
public void Insert(BranchManagementBO branchMngmntBO)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
branchMngmntBO.BranchId = commonBAL.GenerateID("SBP_Broker_Branch", "Branch_ID");
queryString = @"SBPSaveBranch";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@branchID", SqlDbType.Int, branchMngmntBO.BranchId);
_dbConnection.AddParameter("@branchName", SqlDbType.VarChar, branchMngmntBO.BranchName);
_dbConnection.AddParameter("@address", SqlDbType.VarChar, branchMngmntBO.BranchAddress);
_dbConnection.AddParameter("@telePhone", SqlDbType.VarChar, branchMngmntBO.TelePhone);
_dbConnection.AddParameter("@fax", SqlDbType.VarChar, branchMngmntBO.Fax);
_dbConnection.AddParameter("@eMail", SqlDbType.VarChar, branchMngmntBO.Email);
_dbConnection.AddParameter("@web", SqlDbType.VarChar, branchMngmntBO.Web);
_dbConnection.AddParameter("@openDate", SqlDbType.DateTime, branchMngmntBO.BranchOpeningdate.ToShortDateString());
_dbConnection.AddParameter("@isActive ", SqlDbType.Int, branchMngmntBO.BranchIsActive);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable getBoInfo(DateTime FromDate, DateTime ToDate)
{
DataTable dt = null;
string query = "";
query = @"rptBoOpeningInformationForReport";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@StartDate", SqlDbType.DateTime, FromDate);
_dbConnection.AddParameter("@EndDate", SqlDbType.DateTime, ToDate);
dt = _dbConnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dt);
}
public DataTable GetReport(int CatgId, int FreqId, int BranchID, DateTime FromDate, DateTime ToDate, bool IsExpenseDate)
{
DataTable dataTable = new DataTable();
string queryString = @"RptGetExepenseReport";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@ExpenseCatgType_ID", SqlDbType.Int, CatgId);
_dbConnection.AddParameter("@ExpenseFrequency", SqlDbType.Int, FreqId);
_dbConnection.AddParameter("@Branch_ID", SqlDbType.Int, BranchID);
_dbConnection.AddParameter("@FromDate", SqlDbType.DateTime, FromDate);
_dbConnection.AddParameter("@ToDate", SqlDbType.DateTime, ToDate);
_dbConnection.AddParameter("@IsExpenseDate", SqlDbType.Bit, IsExpenseDate);
dataTable = _dbConnection.ExecuteProQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dataTable);
}
public void Insert(UserManagementBO userBO)
{
string userQueryString = "";
userQueryString = @"SBPSaveUserInfo";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@userName", SqlDbType.NVarChar, userBO.UserName);
_dbConnection.AddParameter("@roleName", SqlDbType.NVarChar, userBO.RoleName);
_dbConnection.AddParameter("@password", SqlDbType.NVarChar, userBO.Password);
_dbConnection.AddParameter("@name", SqlDbType.VarChar, userBO.Name);
_dbConnection.AddParameter("@address", SqlDbType.VarChar, userBO.Address);
_dbConnection.AddParameter("@contact", SqlDbType.VarChar, userBO.ContactNo);
_dbConnection.AddParameter("@remark", SqlDbType.VarChar, userBO.Remarks);
_dbConnection.AddParameter("@isActive", SqlDbType.Bit, userBO.IsActive);
_dbConnection.AddParameter("@branchID", SqlDbType.Int, userBO.BranchId);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.AddParameter("@employeeCode", SqlDbType.VarChar, userBO.EmployeeCode);
_dbConnection.ExecuteNonQuery(userQueryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GetAccruedBalanceData(string custCode, DateTime fromDate, DateTime toDate)
{
DataTable dt = new DataTable();
string Query = @"Accrued_Money_Transaction";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
if (!string.IsNullOrEmpty(custCode))
{
_dbConnection.AddParameter("@Cust_Code", SqlDbType.NVarChar, custCode);
}
_dbConnection.AddParameter("@StartDate", SqlDbType.DateTime, fromDate);
_dbConnection.AddParameter("@EndDate", SqlDbType.DateTime, toDate);
dt = _dbConnection.ExecuteProQuery(Query);
}
catch
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dt);
}
public void Insert(MarginPlanBO marginPlanBo)
{
string queryString = "";
queryString = @"SBPSaveMarginChargePlan";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@CustCode", SqlDbType.NVarChar, marginPlanBo.CustCode);
_dbConnection.AddParameter("@PlanName", SqlDbType.VarChar, marginPlanBo.PlanName);
_dbConnection.AddParameter("@EffectiveCount", SqlDbType.Int, marginPlanBo.EffectiveCount);
_dbConnection.AddParameter("@ChargeRate", SqlDbType.Float, marginPlanBo.ChargeRate);
if (marginPlanBo.CommissionRate > 0)
{
_dbConnection.AddParameter("@CommissionRate", SqlDbType.Float, marginPlanBo.CommissionRate);
}
_dbConnection.AddParameter("@FreeAmount", SqlDbType.Money, marginPlanBo.FreeAmount);
_dbConnection.AddParameter("@MarginRatio", SqlDbType.Float, marginPlanBo.MarginRatio);
_dbConnection.AddParameter("@Remarks", SqlDbType.VarChar, marginPlanBo.Remarks);
_dbConnection.AddParameter("@EDate", SqlDbType.DateTime, marginPlanBo.EDate.ToShortDateString());
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GetCashDividedSatellmentReport(DateTime RecDate, decimal FaceValue, decimal Percentage, string InstrumentCode)
{
DataTable dt = new DataTable();
string query = "CashDividedSatellmentReport";
//string query = "FindCashDividedCustCode";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Rec_Date", SqlDbType.DateTime, RecDate);
_dbConnection.AddParameter("@FaceValue", SqlDbType.Decimal, FaceValue);
_dbConnection.AddParameter("@Percentage", SqlDbType.Decimal, Percentage);
_dbConnection.AddParameter("@InsTrumentCode", SqlDbType.VarChar, InstrumentCode);
dt = _dbConnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dt);
}
public void Insert(CustomerCommisionBO commisionBo)
{
CommonBAL commonBAL = new CommonBAL();
commisionBo.CommID = commonBAL.GenerateID("SBP_Cust_Commissions", "Commission_ID");
string queryString = "";
queryString = @"SBPSaveCustCommissionDef";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@CommID", SqlDbType.Int, commisionBo.CommID);
_dbConnection.AddParameter("@GroupId", SqlDbType.Int, commisionBo.GroupId);
_dbConnection.AddParameter("@MinComm", SqlDbType.Money, commisionBo.MinComm);
_dbConnection.AddParameter("@GroupCommRate", SqlDbType.Money, commisionBo.GroupCommRate);
_dbConnection.AddParameter("@Category", SqlDbType.VarChar, commisionBo.Category);
_dbConnection.AddParameter("@EffectiveFrom", SqlDbType.DateTime, commisionBo.EffectiveFrom);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void SaveCommonOpexInfo(OpexDailyBO opexDailyBo)
{
string queryString = "SP_CommonExpense";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Expense_Purpose_ID", SqlDbType.Int, (object)opexDailyBo.PurposeId);
_dbConnection.AddParameter("@Purpose", SqlDbType.VarChar, (object)opexDailyBo.Purpose);
_dbConnection.AddParameter("@Amount", SqlDbType.Money, (object)opexDailyBo.Amount);
_dbConnection.AddParameter("@Expense_Date", SqlDbType.DateTime, (object)opexDailyBo.ExpenseDate.ToShortDateString());
_dbConnection.AddParameter("@Expense_Month", SqlDbType.DateTime, (object)opexDailyBo.MonthOfExpense.ToShortDateString());
_dbConnection.AddParameter("@Remarks", SqlDbType.VarChar, (object)opexDailyBo.Remarks);
_dbConnection.AddParameter("@Entry_By", SqlDbType.VarChar, (object)GlobalVariableBO._userName);
_dbConnection.AddParameter("@VoucharNo", SqlDbType.VarChar, (object)opexDailyBo.VoucherNo);
_dbConnection.AddParameter("@VoucherImage", SqlDbType.Image, (object)opexDailyBo.VoucherImage);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GnerateIPOPaymentReview(DateTime fromDate, DateTime toDate, int isSorted, int Branch_ID)
{
DataTable dtPaymentReview = null;
int isAccountsView = 0;
string quryString = "";
quryString = @"RptIPONewPaymentReviewSorted";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@fromDate", SqlDbType.DateTime, fromDate.ToShortDateString());
_dbConnection.AddParameter("@toDate", SqlDbType.DateTime, toDate.ToShortDateString());
_dbConnection.AddParameter("@IsSorted", SqlDbType.Int, isSorted);
_dbConnection.AddParameter("@IsAccountsView", SqlDbType.Int, isAccountsView);
_dbConnection.AddParameter("@Branch_ID", SqlDbType.Int, Branch_ID);
dtPaymentReview = _dbConnection.ExecuteProQuery(quryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dtPaymentReview);
}
public DataTable Get_DW_ReturnInformation(string paymentMedia, string depositWithdraw, string CustCode)
{
DataTable dataTable = new DataTable();
string queryString = @"GetReturnTransaction";
// string queryString = @"SELECT *
// FROM [SBP_Database].[dbo].[SBP_Payment_Posting_Request]
// WHERE Cust_Code='" + custcode + "' AND Payment_Media='"+paymentMedia + "' AND Deposit_Withdraw='"+depositWithdraw + "' AND Approval_Status=1";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Payment_Media", SqlDbType.VarChar, paymentMedia);
_dbConnection.AddParameter("@deposit_withdraw", SqlDbType.VarChar, depositWithdraw);
_dbConnection.AddParameter("@Cust_Code", SqlDbType.VarChar, CustCode);
dataTable = _dbConnection.ExecuteProQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dataTable);
}
public void Insert(IPOChargeDefBO ipoChargeDefBo)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
ipoChargeDefBo.SlNo = commonBAL.GenerateID("SBP_Ch_Def_IPO", "Sl_No");
queryString = @"SBPSaveIPOChargeDef";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@SlNo", SqlDbType.Int, ipoChargeDefBo.SlNo);
_dbConnection.AddParameter("@CompShortCode", SqlDbType.NVarChar, ipoChargeDefBo.CompShortCode);
_dbConnection.AddParameter("@CompName", SqlDbType.NVarChar, ipoChargeDefBo.CompName);
_dbConnection.AddParameter("@ShareType", SqlDbType.VarChar, ipoChargeDefBo.ShareType);
_dbConnection.AddParameter("@Commision", SqlDbType.Money, ipoChargeDefBo.Commision);
_dbConnection.AddParameter("@EffectiveDate", SqlDbType.DateTime, ipoChargeDefBo.EffectiveDate.ToShortDateString());
_dbConnection.AddParameter("@remark1", SqlDbType.VarChar, ipoChargeDefBo.Remarks1);
_dbConnection.AddParameter("@remark2", SqlDbType.VarChar, ipoChargeDefBo.Remarks2);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GetNettingSumery(DateTime date)
{
string queryString = "SP_FinNetting";
DataTable data = new DataTable();
try
{
_dbConnection.ConnectDatabase();
_dbConnection.TimeoutPeriod = 5000;
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@date", SqlDbType.DateTime, date.ToString("yyyy-MM-dd"));
data = _dbConnection.ExecuteProQuery(queryString);
}
catch (Exception)
{
throw;
}
finally
{
_dbConnection.CloseDatabase();
}
return(data);
}
public DataTable IPOSingleApplicationReport(DateTime FromDate, DateTime ToDate, string Status, string Company, int BranchId)
{
DataTable dt = new DataTable();
string query = @"Rpt_IPOSingleApplication_Process";
try
{
_dbconnection.ConnectDatabase();
_dbconnection.ActiveStoredProcedure();
_dbconnection.AddParameter("@Session_ID", SqlDbType.Int, Company);
_dbconnection.AddParameter("@Start_Date", SqlDbType.Date, FromDate.ToShortDateString());
_dbconnection.AddParameter("@End_Date", SqlDbType.Date, ToDate.ToShortDateString());
_dbconnection.AddParameter("@Application_Status", SqlDbType.VarChar, Status);
_dbconnection.AddParameter("@Branch_Id", SqlDbType.Int, BranchId);
dt = _dbconnection.ExecuteProQuery(query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dbconnection.CloseDatabase();
}
return(dt);
}
public DataTable GetShareInfo(ShareListBO shareBo)
{
string queryString = "";
DataTable dataTable = new DataTable();
queryString = @"RptGetShareInfo";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@fromDate", SqlDbType.DateTime, shareBo.DtFrom.ToShortDateString());
_dbConnection.AddParameter("@toDate", SqlDbType.DateTime, shareBo.DtTo.ToShortDateString());
_dbConnection.AddParameter("@userID", SqlDbType.NVarChar, shareBo.WorkStation);
dataTable = _dbConnection.ExecuteProQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dataTable);
}
public void InsertPrintLog(CheckPrintLogBO checkPrintLogBo)
{
string queryString = "";
queryString = @"SBPSaveCheckPrintHistory";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@SlNo", SqlDbType.Int, checkPrintLogBo.SlNo);
_dbConnection.AddParameter("@CustCode", SqlDbType.VarChar, checkPrintLogBo.CustCode);
_dbConnection.AddParameter("@PaymentMediaNo", SqlDbType.VarChar, checkPrintLogBo.PaymentMediaNo);
_dbConnection.AddParameter("@BankName", SqlDbType.VarChar, checkPrintLogBo.Bankname);
_dbConnection.AddParameter("@VoucheNo", SqlDbType.VarChar, checkPrintLogBo.VoucherSlNo);
_dbConnection.AddParameter("@RecievedDate", SqlDbType.DateTime, checkPrintLogBo.RecievedDate.ToShortDateString());
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Insert(ClosingChargeBO closingChargeBo)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
closingChargeBo.ChId = commonBAL.GenerateID("SBP_Account_Closing_Charge", "Ch_ID");
queryString = @"SBPSaveClosingCharge";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@ChId", SqlDbType.Int, closingChargeBo.ChId);
_dbConnection.AddParameter("@ClosingChargeRate", SqlDbType.Money, closingChargeBo.ClosingCharge);
_dbConnection.AddParameter("@EffectiveDate", SqlDbType.DateTime, closingChargeBo.EffectiveDate.ToShortDateString());
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Insert(PaymentMaturityBO paymentMaturityBo)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
paymentMaturityBo.Id = commonBAL.GenerateID("SBP_Payment_Media_Maturity", "ID");
queryString = @"SBPSavePaymentMediaMaturity";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Id", SqlDbType.Int, paymentMaturityBo.Id);
_dbConnection.AddParameter("@PaymentMedia", SqlDbType.VarChar, paymentMaturityBo.PaymentMedia);
_dbConnection.AddParameter("@MaturityDays", SqlDbType.Int, paymentMaturityBo.MaturityDays);
_dbConnection.AddParameter("@effectiveDate", SqlDbType.DateTime, paymentMaturityBo.EffectiveDate);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public void Insert(CompanyCategoryChangeBO changeBo)
{
string compCatChangeQryString = "";
CommonBAL commonBAL = new CommonBAL();
changeBo.SlNo = commonBAL.GenerateID("SBP_Comp_Cat_Log", "Sl_No");
try
{
_dbConnection.ConnectDatabase();
_dbConnection.StartTransaction();
compCatChangeQryString = @"SBPSaveCompCatChange";
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@SlNo", SqlDbType.Int, changeBo.SlNo);
_dbConnection.AddParameter("@CompShortCode", SqlDbType.NVarChar, changeBo.CompShortCode);
_dbConnection.AddParameter("@OldCategoryId", SqlDbType.Int, changeBo.OldCategoryId);
_dbConnection.AddParameter("@NewCategoryId", SqlDbType.Int, changeBo.NewCategoryId);
_dbConnection.AddParameter("@EffectiveDate", SqlDbType.DateTime, changeBo.EffectiveDate);
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(compCatChangeQryString);
_dbConnection.Commit();
}
catch (Exception exception)
{
_dbConnection.Rollback();
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataSet GetData(string custCode, DateTime StartDate, DateTime EndDate)
{
DataSet PaymentReceiptSummary = null;
string queryString = "";
queryString = @"RptTaxStatement";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@FromDate", SqlDbType.DateTime, StartDate);
_dbConnection.AddParameter("@ToDate", SqlDbType.DateTime, EndDate);
_dbConnection.AddParameter("@Cust_Code", SqlDbType.NVarChar, custCode);
PaymentReceiptSummary = _dbConnection.ExecuteProQueryDataset(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(PaymentReceiptSummary);
}
public void Insert(ChargeDefBO chargeDefBo)
{
string queryString = "";
CommonBAL commonBAL = new CommonBAL();
chargeDefBo.ChDefId = commonBAL.GenerateID("SBP_Ch_Def_All", "Ch_ID");
queryString = @"SBPSaveChargeDef";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@ChDefId", SqlDbType.Int, chargeDefBo.ChDefId);
_dbConnection.AddParameter("@ChItem", SqlDbType.VarChar, chargeDefBo.ChItem);
_dbConnection.AddParameter("@ChItemDescription", SqlDbType.VarChar, chargeDefBo.ChItemDescription);
_dbConnection.AddParameter("@Category", SqlDbType.VarChar, chargeDefBo.Category);
_dbConnection.AddParameter("@MinCh", SqlDbType.Money, chargeDefBo.MinCh);
_dbConnection.AddParameter("@ChRate", SqlDbType.Decimal, chargeDefBo.ChRate);
_dbConnection.AddParameter("@EffectiveDate", SqlDbType.DateTime, chargeDefBo.EffectiveDate.ToShortDateString());
_dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName);
_dbConnection.ExecuteNonQuery(queryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
}
public DataTable GetStatement(DateTime RporotDate)
{
_dbConnection.TimeoutPeriod = 3000;
DataTable dtStatement = null;
string quryString = "";
quryString = "SP_TaxCerfificate";
try
{
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@dateFrom", SqlDbType.DateTime, RporotDate.ToShortDateString());
dtStatement = _dbConnection.ExecuteProQuery(quryString);
}
catch (Exception exception)
{
throw exception;
}
finally
{
_dbConnection.CloseDatabase();
}
return(dtStatement);
}
public DataTable GetBO_Modification_ReportData(string CustCode, string BOID, DateTime fromDate, DateTime toDate)
{
DataTable data = new DataTable();
try
{
string Query = @"rptBO_Modification_Report_DSE_21_5";
_dbConnection.ConnectDatabase();
_dbConnection.ActiveStoredProcedure();
_dbConnection.AddParameter("@Investor_ID", SqlDbType.VarChar, CustCode);
_dbConnection.AddParameter("@BO_ID", SqlDbType.VarChar, BOID);
_dbConnection.AddParameter("@Start_Date", SqlDbType.DateTime, fromDate);
_dbConnection.AddParameter("@End_Date", SqlDbType.DateTime, toDate);
data = _dbConnection.ExecuteProQuery(Query);
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(data);
}