public async Task <DataSet> GetVideo(string type) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("GetVideo"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@type", type); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(await Task.FromResult(dataResult)); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <User> Authenticate(string userName, string password) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("Authenticate"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@UserName", userName); dbconn.sqlComm.Parameters.AddWithValue("@Password", password); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { User user = new User() { DisplayID = Convert.ToInt64(dataResult.Tables[0].Rows[0]["DisplayID"]), //FileUploadID = dataResult.Tables[0].Rows[0]["FileUploadID"] != null ? (Guid?)dataResult.Tables[0].Rows[0]["FileUploadID"] : null, FirstName = dataResult.Tables[0].Rows[0]["FirstName"].ToString(), LastName = dataResult.Tables[0].Rows[0]["LastName"].ToString(), LoftName = dataResult.Tables[0].Rows[0]["LoftName"].ToString(), UserID = (Guid?)dataResult.Tables[0].Rows[0]["UserID"], UserName = dataResult.Tables[0].Rows[0]["UserName"].ToString() }; if (!string.IsNullOrEmpty(dataResult.Tables[0].Rows[0]["FileUploadID"].ToString())) { user.FileUploadID = (Guid?)dataResult.Tables[0].Rows[0]["FileUploadID"]; } return(await Task.FromResult(user)); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataTable> Update(Profile profile) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("UpdateProfile"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@UserId", profile.UserID); dbconn.sqlComm.Parameters.AddWithValue("@LoftName", profile.LoftName); dbconn.sqlComm.Parameters.AddWithValue("@FirstName", profile.FirstName); dbconn.sqlComm.Parameters.AddWithValue("@LastName", profile.LastName); dbconn.sqlComm.Parameters.AddWithValue("@FileUploadId", profile.FileUploadId); if (profile.Image != null) { dbconn.sqlComm.Parameters.AddWithValue("@FileName", profile.Image.FileName); dbconn.sqlComm.Parameters.AddWithValue("@FileType", profile.Image.ContentType); dbconn.sqlComm.Parameters.AddWithValue("@Image", Helper.ImageUpload.GetImageAsBytes(profile.Image)); } SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task.FromResult(dataResult.Tables[0])); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataTable> GetRaceEntry(RaceFilter raceFilter) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("RaceDetailsGetbyKeys", raceFilter.ClubName, raceFilter.DbName); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@ClubID", 0); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", raceFilter.ClubName); dbconn.sqlComm.Parameters.AddWithValue("@ReleaseDate", raceFilter.DateRelease); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategory", raceFilter.Category); dbconn.sqlComm.Parameters.AddWithValue("@RaceCategoryGroup", raceFilter.Group); dbconn.sqlComm.Parameters.AddWithValue("@Version", 0); dbconn.sqlComm.Parameters.AddWithValue("@Name", raceFilter.FilterName); dbconn.sqlComm.Parameters.AddWithValue("@IsFromWeb", 1); dbconn.sqlComm.Parameters.AddWithValue("@Sender", raceFilter.MobileNumber); dbconn.sqlComm.Parameters.AddWithValue("@Source", raceFilter.Source); dbconn.sqlComm.Parameters.AddWithValue("@UserID", raceFilter.UserID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task <DataTable> .FromResult(dataResult.Tables[1])); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataSet> GetLinkMobileNumber(string userid) { try { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("GetLinkMobileList"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@UserID", userid); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task.FromResult(dataResult)); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } } catch (Exception ex) { throw ex; } }
public async Task <string> Insert(User user) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("Insert_MavcPigeonUser"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@FirstName", user.FirstName); dbconn.sqlComm.Parameters.AddWithValue("@LastName", user.LastName); dbconn.sqlComm.Parameters.AddWithValue("@UserName", user.UserName); dbconn.sqlComm.Parameters.AddWithValue("@Password", user.Password); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task.FromResult(dataResult.Tables[0].Rows[0]["UserID"].ToString())); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataTable> GetGroupCategory(string dbName = "", string clubName = "") { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("RaceCategoryGroupSelectAll", clubName, dbName); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@ClubID", 0); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", clubName); dbconn.sqlComm.Parameters.AddWithValue("@ReturnAll", 0); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task <DataTable> .FromResult(dataResult.Tables[0])); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataTable> GetBalance(string mobileNumber) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("MobileCheckLoadBalance"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@mobilenumber", mobileNumber); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); if (dataResult.Tables.Count > 0) { return(await Task <DataTable> .FromResult(dataResult.Tables[0])); } return(null); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataSet> GetMemberCoordinates(string memberidno, string clubname, string dbname) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("GetMemberLocationByID", clubname, dbname); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@MemberIdNo", memberidno); dbconn.sqlComm.Parameters.AddWithValue("@ClubName", clubname); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(await Task.FromResult(dataResult)); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <DataSet> ValidateMobileNumber(string email, string mobileNumber) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("ValidateMobileNumber"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@mobileNumber", "+" + mobileNumber.Trim()); dbconn.sqlComm.Parameters.AddWithValue("@email", email); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(await Task.FromResult(dataResult)); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }
public async Task <string> SetAsPrimary(String mobileNumber, string UserID) { try { DataSet dataResult = new DataSet(); dbconn = new DatabaseConnection(); dbconn.DatabaseConn("SetAsPrimaryNumber"); if (dbconn.sqlConn.State == ConnectionState.Open) { dbconn.sqlConn.Close(); } dbconn.sqlConn.Open(); dbconn.sqlComm.Parameters.Clear(); dbconn.sqlComm.CommandTimeout = 0; dbconn.sqlComm.Parameters.AddWithValue("@mobileNumber", mobileNumber); dbconn.sqlComm.Parameters.AddWithValue("@UserID", UserID); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = dbconn.sqlComm; da.Fill(dataResult); dbconn.sqlConn.Close(); return(await Task.FromResult("Success")); } catch (Exception ex) { throw ex; } finally { dbconn.sqlConn.Close(); dbconn.sqlConn.Dispose(); SqlConnection.ClearPool(dbconn.sqlConn); } }