/// <summary>
/// actual transfer fund operation
/// </summary>
/// <param name="ubo"></param>
/// <returns></returns>
public string Transfer(IFundsTransferBO ubo)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_InsertTransfer", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@custID", ubo.CustID));
cmd.Parameters.Add(new SqlParameter("@CustAccno", Convert.ToDouble(ubo.CustAcc)));
cmd.Parameters.Add(new SqlParameter("@PayeeAccno", Convert.ToDouble(ubo.Payee)));
cmd.Parameters.Add(new SqlParameter("@Amt", Convert.ToDouble(ubo.Amt)));
cmd.Parameters.Add(new SqlParameter("@rmk", ubo.Rmk));
cmd.Parameters.Add("@txn", SqlDbType.VarChar, 10);
cmd.Parameters["@txn"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string message = cmd.Parameters["@txn"].Value.ToString();
return(message);
}
catch (DataException de)
{
return(de.Message);
}
catch (Exception e)
{
return(e.Message);
}
}
/// <summary>
/// update customer account balance
/// </summary>
/// <param name="updateBo"></param>
/// <returns></returns>
public string Update(IFundsTransferBO updateBo)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_UpdateCAcc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CustAcc", Convert.ToDouble(updateBo.Accno)));
cmd.Parameters.Add(new SqlParameter("@Balance", Convert.ToDouble(updateBo.Balance)));
cmd.Parameters.Add("@Avail", SqlDbType.VarChar, 500);
cmd.Parameters["@Avail"].Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
string Available = cmd.Parameters["@Avail"].Value.ToString();
cn.Close();
if (i > 0)
{
return(" Transaction done Successfully in your account " + updateBo.Accno + " " + "and your balance is Rs." + Available + ".00");
}
else
{
return("Insufficient Funds");
}
}
catch (DataException de)
{
return(de.Message);
}
catch (Exception e)
{
return(e.Message);
}
}
/// <summary>
/// to check transaction password
/// </summary>
/// <param name="checkBO"></param>
/// <returns></returns>
public string CheckPassword(IFundsTransferBO checkBO)
{
try
{
//Check transaction password
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_CheckTxnPwd", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CustID", checkBO.CustID));
cmd.Parameters.Add(new SqlParameter("@TxnPwd",FTEncryptEngine.Md5Logic.Decrypt( checkBO.Pwd,true)));
cmd.Parameters.Add("@Check", SqlDbType.VarChar, 500);
cmd.Parameters["@Check"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string Check = (string)cmd.Parameters["@Check"].Value;
cn.Close();
if (Check == "right")
return "right";
else
return "wrong";
}
catch (Exception)
{
return "error";
}
}
/// <summary>
/// Get Payee details from the database
/// </summary>
/// <param name="ubo"></param>
/// <returns></returns>
public DataSet GetPayee(IFundsTransferBO ubo)
{
string cnstr = ConfigurationManager.ConnectionStrings["DB08H98ConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
SqlCommand cmd = new SqlCommand("usp_GetPayeeFT", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@custID", ubo.CustID));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
adapter.Dispose();
return(dataset);
}
/// <summary>
/// to check transaction password
/// </summary>
/// <param name="checkBO"></param>
/// <returns></returns>
public string CheckPassword(IFundsTransferBO checkBO)
{
try
{
//Check transaction password
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_CheckTxnPwd", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CustID", checkBO.CustID));
cmd.Parameters.Add(new SqlParameter("@TxnPwd", FTEncryptEngine.Md5Logic.Decrypt(checkBO.Pwd, true)));
cmd.Parameters.Add("@Check", SqlDbType.VarChar, 500);
cmd.Parameters["@Check"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string Check = (string)cmd.Parameters["@Check"].Value;
cn.Close();
if (Check == "right")
{
return("right");
}
else
{
return("wrong");
}
}
catch (Exception)
{
return("error");
}
}
/// <summary>
/// Update the Payee balance if account exists in accounts table
/// </summary>
/// <param name="updateBoP"></param>
/// <returns></returns>
public string UpdatePayee(IFundsTransferBO updateBoP)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_UpdatePAcc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PayeeAcc", updateBoP.PAccno));
cmd.Parameters.Add(new SqlParameter("@Balance", Convert.ToDouble(updateBoP.Amt1)));
int j = cmd.ExecuteNonQuery();
cn.Close();
if (j > 0)
{
return(" Money Transfered Successfully to Payee account " + updateBoP.PAccno);
}
else
{
return(" Money Transfered Successfully to Payee account " + updateBoP.PAccno + " But Payee Not Registered ");
}
}
catch (DataException de)
{
return(de.Message);
}
catch (Exception e)
{
return(e.Message);
}
}
/// <summary>
///this method is used to call Transfer method of the DAL
/// </summary>
/// <param name="ubo"></param>
/// <returns>string</returns>
public string Transfer(IFundsTransferBO ubo)
{
return(ftDal.Transfer(ubo));
}
public DataSet GetThirdParty(IFundsTransferBO ubo)
{
return(ftDal.GetThridParty(ubo));
}
public DataSet GetSelfOthers(IFundsTransferBO ubo)
{
return(ftDal.GetSelfOthers(ubo));
}
/// <summary>
///this method is used to call PayeeGet method of the DAL
/// </summary>
/// <param name="ubo"></param>
/// <returns>Dataset</returns>
public DataSet PayeeGet(IFundsTransferBO ubo)
{
return(ftDal.GetPayee(ubo));
}
/// <summary>
///this method is used to call get method of the DAL
/// </summary>
/// <param name="ubo"></param>
/// <returns>Dataset</returns>
public DataSet Get(IFundsTransferBO ubo)
{
return(ftDal.GetData(ubo));
}
/// <summary>
/// actual transfer fund operation
/// </summary>
/// <param name="ubo"></param>
/// <returns></returns>
public string Transfer(IFundsTransferBO ubo)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_InsertTransfer", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@custID", ubo.CustID));
cmd.Parameters.Add(new SqlParameter("@CustAccno", Convert.ToDouble(ubo.CustAcc)));
cmd.Parameters.Add(new SqlParameter("@PayeeAccno", Convert.ToDouble(ubo.Payee)));
cmd.Parameters.Add(new SqlParameter("@Amt", Convert.ToDouble(ubo.Amt)));
cmd.Parameters.Add(new SqlParameter("@rmk", ubo.Rmk));
cmd.Parameters.Add("@txn", SqlDbType.VarChar, 10);
cmd.Parameters["@txn"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string message = cmd.Parameters["@txn"].Value.ToString();
return message;
}
catch (DataException de)
{
return de.Message;
}
catch (Exception e)
{
return e.Message;
}
}
/// <summary>
/// Update the Payee balance if account exists in accounts table
/// </summary>
/// <param name="updateBoP"></param>
/// <returns></returns>
public string UpdatePayee(IFundsTransferBO updateBoP)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_UpdatePAcc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@PayeeAcc", updateBoP.PAccno));
cmd.Parameters.Add(new SqlParameter("@Balance", Convert.ToDouble(updateBoP.Amt1)));
int j = cmd.ExecuteNonQuery();
cn.Close();
if (j > 0)
return " Money Transfered Successfully to Payee account " + updateBoP.PAccno;
else
return " Money Transfered Successfully to Payee account " + updateBoP.PAccno + " But Payee Not Registered ";
}
catch (DataException de)
{
return de.Message;
}
catch (Exception e)
{
return e.Message;
}
}
/// <summary>
/// update customer account balance
/// </summary>
/// <param name="updateBo"></param>
/// <returns></returns>
public string Update(IFundsTransferBO updateBo)
{
try
{
string cnstr = ConfigurationManager.ConnectionStrings["FTConfig"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
cn.Open();
SqlCommand cmd = new SqlCommand("usp_UpdateCAcc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CustAcc", Convert.ToDouble(updateBo.Accno)));
cmd.Parameters.Add(new SqlParameter("@Balance", Convert.ToDouble(updateBo.Balance)));
cmd.Parameters.Add("@Avail", SqlDbType.VarChar, 500);
cmd.Parameters["@Avail"].Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
string Available = cmd.Parameters["@Avail"].Value.ToString();
cn.Close();
if (i > 0)
return " Transaction done Successfully in your account " + updateBo.Accno + " " + "and your balance is Rs." + Available+".00";
else
return "Insufficient Funds";
}
catch (DataException de)
{
return de.Message;
}
catch (Exception e)
{
return e.Message;
}
}
/// <summary>
///this method is used to call UpdatePayee method of the DAL
/// </summary>
/// <param name="updateBop"></param>
/// <returns>string</returns>
public string UpdatePayee(IFundsTransferBO updateBop)
{
return(ftDal.UpdatePayee(updateBop));
}
/// <summary>
///this method is used to call CheckPassword method of the DAL
/// </summary>
/// <param name="ubo"></param>
/// <returns>string</returns>
public string CheckPassword(IFundsTransferBO checkBO)
{
return(ftDal.CheckPassword(checkBO));
}
public DataSet GetThridParty(IFundsTransferBO ubo)
{
string cnstr = ConfigurationManager.ConnectionStrings["DB08H98ConnectionString"].ConnectionString;
SqlConnection cn = new SqlConnection(cnstr);
SqlCommand cmd = new SqlCommand("usp_GetThridPartyFT", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@custID", ubo.CustID));
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
adapter.Dispose();
return dataset;
}
