private UserHeckTotal UserHeckTotalColumnMapper(DataTable dataTable) { UserHeckTotal item = new UserHeckTotal(); item.HeckTotal = float.Parse(Convert.ToString(dataTable.Rows[0][0])); item.WeightTotal = float.Parse(Convert.ToString(dataTable.Rows[0][1])); item.HecksWeighted = float.Parse(Convert.ToString(dataTable.Rows[0][2])); item.AvailableHecks = float.Parse(Convert.ToString(dataTable.Rows[0][3])); return(item); }
public DataResponse GetUserHeckTotal(int UserID) { DataResponse resp; connection.Open(); DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("GetUserHeckTotals")) { cmd.Connection = connection; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", UserID); using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { sda.Fill(dt); } } UserHeckTotal item = ColumnMapper(dt) as UserHeckTotal; if (item != null) { HeckUserModel mdl = new HeckUserModel(null); DataResponse usrResp = mdl.GetUserByID(UserID); if (usrResp.Result) { item.User = usrResp.Item as HeckUser; } mdl.Dispose(); resp = new DataResponse("User Heck Total Found", true); resp.Item = item; } else { resp = new DataResponse("User Heck Total could not be found.", true); } return(resp); }