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 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 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 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 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 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(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 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 DataTable Get_DSE_22_1_Report(string CustomerCode, DateTime ToDate) { DataTable dt_dse_22_1_info = new DataTable(); string queryString = "SBP_ShareLedger_New"; try { _dbConnection.ConnectDatabase(); _dbConnection.TimeoutPeriod = 1000; _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@custCode", SqlDbType.VarChar, CustomerCode); _dbConnection.AddParameter("@toDate", SqlDbType.DateTime, ToDate); dt_dse_22_1_info = _dbConnection.ExecuteProQuery(queryString); _dbConnection.TimeoutPeriod = 30; } catch (Exception) { throw; } finally { _dbConnection.CloseDatabase(); } return(dt_dse_22_1_info); }
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 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); }
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 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 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(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 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 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 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 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 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 void Insert(MarginChargeDefBO marginChargeDefBo) { string queryString = ""; CommonBAL commonBAL = new CommonBAL(); marginChargeDefBo.Id = commonBAL.GenerateID("SBP_Margin_Charge_Def", "ID"); queryString = @"SBPSaveMarginCharge"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@ChDefId", SqlDbType.Int, marginChargeDefBo.Id); _dbConnection.AddParameter("@PlanName", SqlDbType.NVarChar, marginChargeDefBo.PlanName); _dbConnection.AddParameter("@ChargeRate", SqlDbType.Float, marginChargeDefBo.ChargeRate); _dbConnection.AddParameter("@EffectiveCount", SqlDbType.Int, marginChargeDefBo.EffectiveCount); _dbConnection.AddParameter("@effectiveDate", SqlDbType.DateTime, marginChargeDefBo.EffectiveDate.ToShortDateString()); _dbConnection.AddParameter("@remarks", SqlDbType.VarChar, marginChargeDefBo.Remarks); _dbConnection.AddParameter("@entryBy", SqlDbType.VarChar, GlobalVariableBO._userName); _dbConnection.ExecuteNonQuery(queryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } }
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 DaySummaryDataCalculation(string calculationDate) { string query = @"SP_DaySammaryInformationInsert"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@InsertDate", SqlDbType.DateTime, calculationDate); _dbConnection.ExecuteProQuery(query); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void GeneratePayOutData(int minDays, string group) { string queryString = @"GeneratePayout"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@minDays", SqlDbType.Int, minDays); _dbConnection.AddParameter("@group", SqlDbType.VarChar, group); _dbConnection.ExecuteProQuery(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 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 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 void SaveEmpDocumentInfo(EmployeeDocumentBo bo) { string query = @"INSERT INTO [HR_Emp_DocFile] ( [Emp_ID] ,[Emp_NID_Photo] ,Emp_CV_PDF ) VALUES ('" + bo.Employee_Document_ID + @"' , @NationalID , @CVPDF )"; try { _dbconnection.Connect_ImageDB(); _dbconnection.AddParameter("@NationalID", SqlDbType.Binary, bo.National_Id_imag); _dbconnection.AddParameter("@CVPDF", SqlDbType.Binary, bo.CV_PDF); this._dbconnection.ExecuteNonQuery(query); query = @"INSERT INTO [SBP_Employee_Documents] ( [Employee_ID] ,[Document_Type] ,[Document_Name] ) VALUES ('" + bo.Employee_Document_ID + @"' , '" + bo.Employee_Document_Type + @"', '" + bo.Employee_Document_Name + @"' )"; _dbconnection.ConnectDatabase(); this._dbconnection.ExecuteNonQuery(query); } catch (Exception ex) { throw ex; } }
public DataTable GetBO_Closing_ReportData(DateTime fromDate, DateTime toDate) { DataTable data = new DataTable(); try { string Query = @"rptBO_Closing_Report_DSE_21_6"; _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _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); }
public DataTable GetCustWiseBuyShareList(DateTime transDate) { DataTable dtShareDWReview = null; string quryString = @"RptGetCustWiseBuyShareList"; try { _dbConnection.ConnectDatabase(); _dbConnection.ActiveStoredProcedure(); _dbConnection.AddParameter("@transDate", SqlDbType.DateTime, transDate.ToShortDateString()); dtShareDWReview = _dbConnection.ExecuteProQuery(quryString); } catch (Exception exception) { throw exception; } finally { _dbConnection.CloseDatabase(); } return(dtShareDWReview); }