public WithDrawLimitDTO GetMinWithDraw(string stk)
{
try
{
conn.Open();
string query = "SELECT *, tblWithDrawLimit.Value FROM tblWithDrawLimit, tblAccount WHERE AccountNo=@card AND tblAccount.WDID = tblWithDrawLimit.WDID";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("card", stk);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
WithDrawLimitDTO widthDrawLimitDTO = new WithDrawLimitDTO(
int.Parse(dr["WDID"].ToString()),
int.Parse(dr["Value"].ToString()));
conn.Close();
return(widthDrawLimitDTO);
}
conn.Close();
return(null);
}
catch (Exception)
{
//throw;
return(null);
}
//return new WithDrawLimitDTO(int.Parse(dr["Value"].ToString()));
}
public int GetMinWithDraw(string stk)
{
WithDrawLimitDTO minDraw = new WithDrawLimitDTO();
minDraw = stockDAL.GetMinWithDraw(stk);
return(minDraw.Value);
}
