public void UpdateCashDividedMarginLoanDepositReturn(CashDividedMarginLoanBO cashDividedMarginLoanBO)
{
string Query = string.Empty;
Query = @"UPDATE SBP_CashDivided_MarginLoan SET IsReturn=NULL,ReturnDate =NULL Where CashDividedofMarginLoanId ='" + cashDividedMarginLoanBO.CashDividedMarginLoanId + "'";
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(Query);
}
public void UpdateCashDividedMarginLoanCounting(CashDividedMarginLoanBO cashDividedMarginLoanBO)
{
string Query = string.Empty;
Query = @"UPDATE SBP_CashDivided_MarginLoan SET EmailSendCounting = ISNULL(EmailSendCounting,0)+1 WHERE CashDividedofMarginLoanId='" + cashDividedMarginLoanBO.CashDividedMarginLoanId + "' ";
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(Query);
}
public int EmailCounting(CashDividedMarginLoanBO cashDividedMarginLoanBO)
{
int EmailCount = 0;
DataTable dt = new DataTable();
string Query = @"Select ISNULL(EmailSendCounting,0) AS 'EmailSendCounting'
from SBP_CashDivided_MarginLoan WHERE CashDividedofMarginLoanId='" + cashDividedMarginLoanBO.CashDividedMarginLoanId + "'";
_dbConnection.ConnectDatabase();
dt = _dbConnection.ExecuteQuery(Query);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
EmailCount = Convert.ToInt32(dr["EmailSendCounting"].ToString());
}
}
return(EmailCount);
}
public void DeletePaymentPosting(CashDividedMarginLoanBO cashDividedMarginLoanBO)
{
string Query = string.Empty;
string query = string.Empty;
Query = @"DELETE SBP_Payment_Posting_Request WHERE Cust_Code IN (" + cashDividedMarginLoanBO.ListCustCode + @")
AND
CONVERT(VARCHAR(10),Received_Date,120)=CONVERT(VARCHAR(10),'" + cashDividedMarginLoanBO.ReturnDate.ToString("yyyy-MM-dd") + @"',120)
AND Vouchar_SN LIKE '%CD|%'
AND SUBSTRING(Vouchar_SN , CHARINDEX('|', Vouchar_SN ) + 1, LEN(Vouchar_SN )) ='" + cashDividedMarginLoanBO.CompanyName + "'";
cashDividedMarginLoanBO.ListCustCode = cashDividedMarginLoanBO.ListCustCode + "," + "99";
query = @"DELETE SBP_Payment WHERE Cust_Code IN (" + cashDividedMarginLoanBO.ListCustCode + @")
AND
CONVERT(VARCHAR(10),Received_Date,120)=CONVERT(VARCHAR(10),'" + cashDividedMarginLoanBO.ReturnDate.ToString("yyyy-MM-dd") + @"',120)
AND Voucher_Sl_No LIKE '%CD|%'
AND SUBSTRING(Voucher_Sl_No , CHARINDEX('|', Voucher_Sl_No ) + 5, LEN(Voucher_Sl_No )) ='" + cashDividedMarginLoanBO.CompanyName + "'";
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(Query);
_dbConnection.ExecuteNonQuery(query);
}
public void InsertCashDividedMarginLoan(CashDividedMarginLoanBO cashDividedMarginLoanBO)
{
string Query = string.Empty;
if (cashDividedMarginLoanBO.CashDividedMarginLoanId > 0)
{
Query = @"UPDATE [SBP_CashDivided_MarginLoan]
SET [CompanyName] = '" + cashDividedMarginLoanBO.CompanyName + @"'
,[Ref] = '" + cashDividedMarginLoanBO.Ref + @"'
,[RecordDate] = '" + cashDividedMarginLoanBO.RecordDate + @"'
,[Percentage] = '" + cashDividedMarginLoanBO.PercentageCash + @"'
,[FaceValue] = '" + cashDividedMarginLoanBO.FaceValue + @"'
,[MD_Name] = '" + cashDividedMarginLoanBO.MDName + @"'
,[Company_Address] = '" + cashDividedMarginLoanBO.Address + @"'
,[PhoneNo] = '" + cashDividedMarginLoanBO.PhoneNo + @"'
,[Email1] = '" + cashDividedMarginLoanBO.Email1 + @"'
,[Email2] = '" + cashDividedMarginLoanBO.Email2 + @"'
,[SD_Fraction_Percentage] = '" + cashDividedMarginLoanBO.FunctionPercentage + @"'
,[FunctionSharePrice] = '" + cashDividedMarginLoanBO.FunctionSharePrice + @"'
,[CreateDate] = GETDATE()
,[CreateBy] = '" + GlobalVariableBO._userName + @"'
WHERE [CashDividedofMarginLoanId]='" + cashDividedMarginLoanBO.CashDividedMarginLoanId + "'";
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(Query);
}
else
{
Query = @"INSERT INTO [SBP_CashDivided_MarginLoan]
([CompanyName]
,[Ref]
,[RecordDate]
,[Percentage]
,[FaceValue]
,[MD_Name]
,[Company_Address]
,[CreateDate]
,[CreateBy]
,[Email1]
,[Email2]
,[SD_Fraction_Percentage]
,[FunctionSharePrice]
,[PhoneNo])
VALUES(
'" + cashDividedMarginLoanBO.CompanyName + @"'
,'" + cashDividedMarginLoanBO.Ref + @"'
,'" + cashDividedMarginLoanBO.RecordDate + @"'
,'" + cashDividedMarginLoanBO.PercentageCash + @"'
,'" + cashDividedMarginLoanBO.FaceValue + @"'
,'" + cashDividedMarginLoanBO.MDName + @"'
,'" + cashDividedMarginLoanBO.Address + @"'
,'" + System.DateTime.Now + @"'
,'" + GlobalVariableBO._userName + @"'
,'" + cashDividedMarginLoanBO.Email1 + @"'
,'" + cashDividedMarginLoanBO.Email2 + @"'
,'" + cashDividedMarginLoanBO.FunctionPercentage + @"'
,'" + cashDividedMarginLoanBO.FunctionSharePrice + @"'
,'" + cashDividedMarginLoanBO.PhoneNo + @"')";
_dbConnection.ConnectDatabase();
_dbConnection.ExecuteNonQuery(Query);
}
}
