public List <CapitalInfo> getAllCapital() { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <CapitalInfo> ListCapital = CapitalDataLayer.GetInstance().GetAllCapital(connection); return(ListCapital); } }
public List <CapitalInfo> GetByName(string name) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <CapitalInfo> ListCapital = CapitalDataLayer.GetInstance().GetByName(connection, name); return(ListCapital); } }
public ActionMessage deleteCapital(int id) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { CapitalDataLayer.GetInstance().DeleteCapital(connection, id); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.ToString(); } } return(ret); }