//Method to get security Answer public DataSet GetSecurityAnsDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) try { { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } //var question = context.GetSecurityAns(todoListBO.EmailID); SqlDataAdapter da = new SqlDataAdapter("GetSecurityAns", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.VarChar)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "TodoList_UserDetails"); return(ds); } } catch { DataSet ds = new DataSet(); return(ds); } finally { context.Connection.Close(); } }
//Method to change completed Lists to TodoLists public DataSet UnArchiveUserListDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { try { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.UnArchive(todoListBO.EmailID, todoListBO.Title, todoListBO.Description, todoListBO.IsArchive); SqlDataAdapter da = new SqlDataAdapter("GetUserLists", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.Text)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "UserLIsts"); return(ds); } catch { DataSet ds = new DataSet(); return(ds); } finally { context.Connection.Close(); } } }
//Method to get user EmailID's public DataSet GetUserEmailsDA() { using (var context = new TodolistDataContext(connectionString)) { try { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.GetUserMailIds(true); SqlDataAdapter da = new SqlDataAdapter("GetUserMailIds", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@IsActive", SqlDbType.Bit)); da.SelectCommand.Parameters["@IsActive"].Value = true; DataSet ds = new DataSet(); da.Fill(ds, "TodoList_UserDetails"); return(ds); } catch { DataSet ds = new DataSet(); return(ds); } finally { context.Connection.Close(); } } }
//Method to insert the user details public DataSet InsertUserDetailsDA(TodoListBusinessObject todoListBO) { using (TodolistDataContext td = new TodolistDataContext()) //TodoListDataContext db = new DataContext()) { // Child c = new Child(); //c.ForeignKeyID = SomeID; //td.InsertOnSubmit(c); // td.SubmitChanges(); } using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.InsertUserLists(todoListBO.EmailID, todoListBO.CreatedDate, todoListBO.Title, todoListBO.Description, todoListBO.IsActive, todoListBO.IsArchive); SqlDataAdapter da = new SqlDataAdapter("GetUserLists", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.Text)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "TodoList_UserLists"); return(ds); } }
//Method to delete User public DataSet DeleteUserDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { try { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.DeleteUser(todoListBO.EmailID); SqlDataAdapter da = new SqlDataAdapter("DeleteUser", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.Text)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "TodoLists_UserDetails"); return(ds); } catch { DataSet ds = new DataSet(); return(ds); } finally { context.Connection.Close(); } } }
//Method to insert new user public string InsertNewUserDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { try { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } //context.InsertOnSubmit(todoListBO); context.InsertNewUser(todoListBO.name, todoListBO.EmailID, todoListBO.Pwd, todoListBO.SecurityQuestion, todoListBO.SecurityAnswer, todoListBO.Phone, todoListBO.ZipCode, todoListBO.Country, todoListBO.DateOfBirth, todoListBO.IsActive); context.SubmitChanges(); return("The User Registered Successfully"); } catch { return("The User Did Not Register"); } finally { context.Connection.Close(); } } }
//Method to Update User Details public void UpdateUserDetailsDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.InsertNewUser(todoListBO.name, todoListBO.EmailID, todoListBO.Pwd, todoListBO.SecurityQuestion, todoListBO.SecurityAnswer, todoListBO.Phone, todoListBO.ZipCode, todoListBO.Country, todoListBO.DateOfBirth, todoListBO.IsActive); context.SubmitChanges(); } }
//Method to get user completed Lists public DataSet GetUserArchiveDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } SqlDataAdapter da = new SqlDataAdapter("GetArchive", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.Text)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "TodoList_UserLists"); return(ds); } }
//Method to Validate User who forgot password public bool ValidateUserForgotPwdDA(TodoListBusinessObject todoListBO) { try { using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } bool isValid = context.UserValidForgotPwd(todoListBO.EmailID).Any(); return(isValid); } } catch { return(false); } }
//Method to check if the Email is already registered public bool IsAvailableEmailDA(TodoListBusinessObject todoListBO) { try { using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } bool isAvailable = context.IsAvailable(todoListBO.EmailID).Any(); return(isAvailable); } } catch { return(false); } }
//Method to update user list public string UpdateUserListsDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) try { { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.UpdateList(todoListBO.EmailID, todoListBO.TitleOld, todoListBO.TitleNew, todoListBO.Description, todoListBO.CreatedDate); return("User List Updated Successfully"); } } catch { return("User List Not Updated"); } finally { context.Connection.Close(); } }
//public List<GetUserListsResult> GetUserListsDA(TodoListBusinessObject todoListBO) //Method to get seleted user lists public DataSet GetUserListsDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } //List<GetUserListsResult> x = context.GetUserLists("*****@*****.**").ToList(); SqlDataAdapter da = new SqlDataAdapter("GetUserLists", connectionString); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add(new SqlParameter("@EmailID", SqlDbType.Text)); da.SelectCommand.Parameters["@EmailID"].Value = todoListBO.EmailID; DataSet ds = new DataSet(); da.Fill(ds, "TodoList_UserLists"); return(ds); //return ds; //return List<GetUserListsResult>; } }
//Method to Activate User public bool ActivateUserDA(TodoListBusinessObject todoListBO) { using (var context = new TodolistDataContext(connectionString)) try { { if (context.Connection.State == System.Data.ConnectionState.Closed) { context.Connection.Open(); } context.ReActivate(todoListBO.EmailID); return(true); } } catch { return(false); } finally { context.Connection.Close(); } }