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);
}
