public int getTotalRecords(PracticeCriteria conditions) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { return(PracticeDataLayer.GetInstance().GetTotalRecords(connection, conditions)); } }
public void UpdateUser(PracticeInfo _user) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); PracticeLogInfo record = new PracticeLogInfo(); using (SqlConnection connection = sqlConnection.GetConnection()) { PracticeDataLayer.GetInstance().UpdateUser(connection, _user); } }
public List <PracticeInfo> GetList(PracticeCriteria conditions) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <PracticeInfo> ListUserInfo = PracticeDataLayer.GetInstance().Getlist(connection, conditions); return(ListUserInfo); } }
public void DeleteAllUser(string ids) { //connection SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { //gọi tương tác tới datalayer PracticeDataLayer.GetInstance().DeleteAllUser(connection, ids); } }
public PracticeInfo GetDetail(string id) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); PracticeInfo record = new PracticeInfo(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = PracticeDataLayer.GetInstance().GetUser(connection, id); return(record); } }
public void CreateConfirm(ConfirmInfo value) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); PracticeInfo record = new PracticeInfo(); using (SqlConnection connection = sqlConnection.GetConnection()) { //string applicationId = EncryptionUtils.GetApplicationId(); //string applicationName = EncryptionUtils.GetApplicationName(); PracticeDataLayer.GetInstance().CreateConfirm(connection, value); } }