public List <UserLibrary> GetTestType(string testType)
{
List <UserLibrary> list = new List <UserLibrary>();
conn.Open();
cmdGetTestQuestion = new SqlCommand("proc_GetTestTypeQuestions", conn);
cmdGetTestQuestion.Parameters.AddWithValue("@TestModel", testType);
cmdGetTestQuestion.CommandType = CommandType.StoredProcedure;
cmdGetTestQuestion.Parameters[0].Value = testType;
SqlDataReader drQuestionType = cmdGetTestQuestion.ExecuteReader();
UserLibrary examen = null;
while (drQuestionType.Read())
{
examen = new UserLibrary();
examen.Sno = Convert.ToInt32(drQuestionType[0]);
examen.Testmodel = drQuestionType[1].ToString();
examen.Question = drQuestionType[2].ToString();
examen.Answer = drQuestionType[3].ToString();
examen.Option1 = drQuestionType[4].ToString();
examen.Option2 = drQuestionType[5].ToString();
examen.Option3 = drQuestionType[6].ToString();
examen.Option4 = drQuestionType[7].ToString();
examen.Mark = Convert.ToInt32(drQuestionType[8]);
list.Add(examen);
}
conn.Close();
return(list);
}
public override Library[] Dump()
{
Library dumpedLibrary = new UserLibrary();
UriBuilder dumpUriBuilder = LocalBaseURI;
dumpUriBuilder.Path = string.Join("/", this.IDPrefix, LibraryItemsPath);
dumpUriBuilder.Query = ComposeURIQuery(AuthenticationQuery);
Task <HttpResponseMessage> dumpRequestTask = HttpClient.GetAsync(dumpUriBuilder.ToString());
dumpRequestTask.Wait();
HttpResponseMessage dumpRequestResponse = dumpRequestTask.Result;
if (dumpRequestResponse.IsSuccessStatusCode)
{
Task <string> readJSONDumpResponse = dumpRequestResponse.Content.ReadAsStringAsync();
readJSONDumpResponse.Wait();
string JSONDumpResponse = readJSONDumpResponse.Result;
JSONNode node = new JSONNode(JSONDumpResponse);
Newtonsoft.Json.Linq.JObject mainNode = Newtonsoft.Json.Linq.JObject.Parse(JSONDumpResponse);
}
return(new Library[] { dumpedLibrary });
}
private async void BotOnMessageReceived(object sender, MessageEventArgs messageEventArgs)
{
var message = messageEventArgs.Message;
var username = message.Chat.Username;
if (!UserLibrary.ContainsUser(username))
{
var user = new TelegramBotUser()
{
ChatId = message.Chat.Id,
UserName = username,
Lock = true,
CurrentState = TelegramBotStateEnum.MainMenu
};
State = new MainMenuState(this);
UserLibrary.AddUser(user);
}
else
{
var userState = UserLibrary.GetTelegramBotUserState(username);
SetState(userState);
}
Console.WriteLine(message.Chat.Id);
State.Response(_bot, messageEventArgs);
}
public UserLibrary AddQuestions(UserLibrary examen)
{
try
{
conn.Open();
cmdAddQuestion = new SqlCommand("proc_AddQuestion", conn);
cmdAddQuestion.Parameters.AddWithValue("@TestModel", examen.Testmodel);
cmdAddQuestion.Parameters.AddWithValue("@Questions", examen.Question);
cmdAddQuestion.Parameters.AddWithValue("@Answers", examen.Answer);
cmdAddQuestion.Parameters.AddWithValue("@option1", examen.Option1);
cmdAddQuestion.Parameters.AddWithValue("@option2", examen.Option2);
cmdAddQuestion.Parameters.AddWithValue("@option3", examen.Option3);
cmdAddQuestion.Parameters.AddWithValue("@option4", examen.Option4);
cmdAddQuestion.Parameters.AddWithValue("@Mark", examen.Mark);
cmdAddQuestion.CommandType = CommandType.StoredProcedure;
if (cmdAddQuestion.ExecuteNonQuery() > 0)
{
examen = null;
}
}
catch (SqlException se)
{
Console.WriteLine(se.Message);
}
conn.Close();
return(examen);
}
public List <UserLibrary> GetUpcomingTestResults(string Username, string Teststatus)
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetUpcomingTestResults = new SqlCommand("proc_GetUpcomingTestResults", conn);
cmdGetUpcomingTestResults.Parameters.AddWithValue("@username", Username);
cmdGetUpcomingTestResults.Parameters.AddWithValue("@teststatus", Teststatus);
cmdGetUpcomingTestResults.CommandType = CommandType.StoredProcedure;
SqlDataReader dataReader = cmdGetUpcomingTestResults.ExecuteReader();
while (dataReader.Read())
{
user = new UserLibrary();
UserLibrary users = new UserLibrary();
user.Username = dataReader[0].ToString();
user.Testid = dataReader[1].ToString();
user.Testmodel = dataReader[2].ToString();
//user.Testdate = (Convert.ToDateTime(dataReader[3]));
user.Testdate = dataReader[3].ToString();
user.Paymentmode = dataReader[4].ToString();
user.Teststatus = dataReader[5].ToString();
user.Result = Convert.ToInt32(dataReader[6]);
user.Payeddate = dataReader[7].ToString();
user.Cancelleddate = dataReader[8].ToString();
examens.Add(user);
}
conn.Close();
return(examens);
}
public List <UserLibrary> GetQuestions()
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetAllQuestions = new SqlCommand("proc_GetQuestions", conn);
cmdGetAllQuestions.CommandType = CommandType.StoredProcedure;
UserLibrary examen;
SqlDataReader dataReader = cmdGetAllQuestions.ExecuteReader();
while (dataReader.Read())
{
examen = new UserLibrary();
examen.Sno = Convert.ToInt32(dataReader[0]);
examen.Testmodel = dataReader[1].ToString();
examen.Question = dataReader[2].ToString();
examen.Answer = dataReader[3].ToString();
examen.Option1 = (dataReader[4].ToString());
examen.Option3 = (dataReader[5].ToString());
examen.Option2 = (dataReader[6].ToString());
examen.Option4 = (dataReader[7].ToString());
examen.Mark = Convert.ToInt32(dataReader[8]);
examens.Add(examen);
}
conn.Close();
return(examens);
}
public bool InsertintoPayment(string paymenttype, string testid, UserLibrary user)
{
conn.Open();
string teststatus = "Upcoming";
int res = 0;
String payeddate = DateTime.Now.ToString("yyy/MM/dd");
string cancelledate = "InProgress";
cmdInsertPayment = new SqlCommand("proc_InsertIntoPaymentTable", conn);
cmdInsertPayment.Parameters.AddWithValue("@username", user.Username);
cmdInsertPayment.Parameters.AddWithValue("@testid", testid);
cmdInsertPayment.Parameters.AddWithValue("@testmodel", user.Testmodel);
cmdInsertPayment.Parameters.AddWithValue("@testdate", user.Testdate);
cmdInsertPayment.Parameters.AddWithValue("@paymentmode", paymenttype);
cmdInsertPayment.Parameters.AddWithValue("@teststatus", teststatus);
cmdInsertPayment.Parameters.AddWithValue("@result", res);
cmdInsertPayment.Parameters.AddWithValue("@payeddate", payeddate);
cmdInsertPayment.Parameters.AddWithValue("@cancelleddate", cancelledate);
cmdInsertPayment.CommandType = CommandType.StoredProcedure;
if (cmdInsertPayment.ExecuteNonQuery() > 0)
{
result = true;
}
conn.Close();
return(result);
}
[Authorize] // c2-d2
public async Task <IActionResult> AddToMyLibrary(int appId)
{
//var user = await _userManager.FindByNameAsync(User.Identity.Name);
var user = await _userManager.GetUserAsync(User);
var userId = user.Id;
var userLibrary = _context.UserLibraries.FirstOrDefault(f => f.UserId == userId);
if (userLibrary == null)
{
UserLibrary newLibrary = new UserLibrary
{
UserId = userId
};
userLibrary = _context.UserLibraries.Add(newLibrary).Entity;
_context.SaveChanges();
}
if (_context.LibraryApps.FirstOrDefault(f => f.AppId == appId && f.LibaryId == userLibrary.Id) == null)
{
_context.LibraryApps.Add(new LibraryApps
{
AppId = appId,
LibaryId = userLibrary.Id
});
}
_context.SaveChanges();
return(RedirectToAction("Details", new { id = appId }));
}
public List <UserLibrary> SelectQuestionsBySno(int Sno, int Qno, int flags)
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdSelectBySno = new SqlCommand("proc_SelectQuestionsBySno", conn);
cmdSelectBySno.Parameters.AddWithValue("@sno", Sno);
cmdSelectBySno.CommandType = CommandType.StoredProcedure;
SqlDataReader dataReader = cmdSelectBySno.ExecuteReader();
while (dataReader.Read())
{
user = new UserLibrary();
UserLibrary users = new UserLibrary();
user.Sno = Convert.ToInt32(dataReader[0]);
user.Testmodel = dataReader[1].ToString();
user.Question = dataReader[2].ToString();
user.Answer = dataReader[3].ToString();
user.Option1 = (dataReader[4].ToString());
user.Option3 = (dataReader[5].ToString());
user.Option2 = (dataReader[6].ToString());
user.Option4 = (dataReader[7].ToString());
user.Mark = Convert.ToInt32(dataReader[8]);
user.Flag = flags;
user.Qno = Qno;
examens.Add(user);
}
conn.Close();
return(examens);
}
public List <UserLibrary> DisplayQuestionsforTest(string testmodel)
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
List <UserLibrary> Options = new List <UserLibrary>();
cmdDisplayQuastions = new SqlCommand("proc_GetAllQuestions", conn);
cmdDisplayQuastions.Parameters.Add("@TestModel", SqlDbType.VarChar, 50);
cmdDisplayQuastions.CommandType = CommandType.StoredProcedure;
cmdDisplayQuastions.Parameters[0].Value = testmodel;
SqlDataReader dataReader = cmdDisplayQuastions.ExecuteReader();
while (dataReader.Read())
{
user = new UserLibrary();
UserLibrary users = new UserLibrary();
user.Sno = Convert.ToInt32(dataReader[0]);
user.Testmodel = dataReader[1].ToString();
user.Question = dataReader[2].ToString();
user.Answer = dataReader[3].ToString();
user.Option1 = (dataReader[4].ToString());
user.Option3 = (dataReader[5].ToString());
user.Option2 = (dataReader[6].ToString());
user.Option4 = (dataReader[7].ToString());
user.Mark = Convert.ToInt32(dataReader[8]);
no = no + 1;
user.Qno = no;
examens.Add(user);
}
conn.Close();
return(examens);
}
public List <UserLibrary> GetPaidUsers()
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetPaidUsers = new SqlCommand("proc_GetPaidUsers", conn);
cmdGetPaidUsers.CommandType = CommandType.StoredProcedure;
UserLibrary examen;
SqlDataReader dataReader = cmdGetPaidUsers.ExecuteReader();
while (dataReader.Read())
{
examen = new UserLibrary();
examen.Username = dataReader[0].ToString();
examen.Testid = dataReader[1].ToString();
examen.Testmodel = dataReader[2].ToString();
//examen.Testdate = (Convert.ToDateTime(dataReader[3]));
examen.Testdate = dataReader[3].ToString();
examen.Paymentmode = dataReader[4].ToString();
examen.Teststatus = dataReader[5].ToString();
examen.Result = Convert.ToInt32(dataReader[6]);
examens.Add(examen);
}
conn.Close();
return(examens);
}
public bool Post([FromBody] UserLibrary value)
{
if (User != null)
{
return(bl.AdminLogInUserValidation(value));
}
else
{
return(false);
}
}
// POST api/values
public UserLibrary Post([FromBody] UserLibrary examen)
{
if (User != null)
{
return(bl.AddQuestions(examen));
}
else
{
return(new UserLibrary());
}
}
public ActionResult Create([FromForm] UserLibrary library)
{
try
{
_repository.Add(library);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(new BadRequestResult());
}
}
public async Task <UserLibrary> AddUserLibrary(int libraryId, string userId)
{
var userLibrary = new UserLibrary
{
LibraryId = libraryId,
userId = userId
};
_context.Add <UserLibrary>(userLibrary);
await _context.SaveChangesAsync();
return(userLibrary);
}
public ActionResult Edit(int id, [FromForm] UserLibrary library)
{
try
{
_repository.Update(library);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(new BadRequestResult());
}
}
// PUT api/values/5
public UserLibrary Put([FromBody] UserLibrary examen)
{
//var user = (from u in examen
// where u.SNo == id
// select u).First();
if (User != null)
{
return(bl.UpdateQuestion(examen));
}
else
{
return(examen);
}
}
public ActionResult Delete(int id)
{
UserLibrary library = _repository.GetById(id);
if (library != null)
{
_repository.Remove(library);
return(RedirectToAction(nameof(Index)));
}
else
{
return(new BadRequestResult());
}
}
public bool LogInValidation(UserLibrary user)
{
conn.Open();
cmdLogInUserValidation = new SqlCommand("proc_UserValidation", conn);
cmdLogInUserValidation.Parameters.AddWithValue("@p_Username", user.Username);
cmdLogInUserValidation.Parameters.AddWithValue("@p_password", user.Password);
cmdLogInUserValidation.CommandType = CommandType.StoredProcedure;
SqlDataReader dataReader = cmdLogInUserValidation.ExecuteReader();
if (dataReader.HasRows == true)
{
result = true;
}
conn.Close();
return(result);
}
public List <UserLibrary> GetAllUsers()
{
List <UserLibrary> users = new List <UserLibrary>();
conn.Open();
cmdGetAllUsers = new SqlCommand("proc_GetAllUsers", conn);
SqlDataReader drUsers = cmdGetAllUsers.ExecuteReader();
UserLibrary user = null;
while (drUsers.Read())
{
user = new UserLibrary();
user.Username = drUsers[1].ToString();
user.Password = drUsers[0].ToString();
users.Add(user);
}
conn.Close();
return(users);
}
public List <UserLibrary> ScoresforChart(int Sno)
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetScoresForChart = new SqlCommand("proc_dummy", conn);
cmdGetScoresForChart.Parameters.AddWithValue("@id", Sno);
cmdGetScoresForChart.CommandType = CommandType.StoredProcedure;
SqlDataReader dataReader = cmdGetScoresForChart.ExecuteReader();
while (dataReader.Read())
{
user = new UserLibrary();
UserLibrary users = new UserLibrary();
user.Sno = Convert.ToInt32(dataReader[0]);
examens.Add(user);
}
conn.Close();
return(examens);
}
public UserLibrary UpdateQuestion(UserLibrary examen)
{
conn.Open();
cmdUpdateQuestion = new SqlCommand("proc_UpdateQuestion", conn);
cmdUpdateQuestion.CommandType = CommandType.StoredProcedure;
cmdUpdateQuestion.Parameters.AddWithValue("@SNo", examen.Sno);
cmdUpdateQuestion.Parameters.AddWithValue("@TestModel", examen.Testmodel);
cmdUpdateQuestion.Parameters.AddWithValue("@Question", examen.Question);
cmdUpdateQuestion.Parameters.AddWithValue("@Answer", examen.Answer);
cmdUpdateQuestion.Parameters.AddWithValue("@option1", examen.Option1);
cmdUpdateQuestion.Parameters.AddWithValue("@option2", examen.Option2);
cmdUpdateQuestion.Parameters.AddWithValue("@option3", examen.Option3);
cmdUpdateQuestion.Parameters.AddWithValue("@option4", examen.Option4);
cmdUpdateQuestion.Parameters.AddWithValue("@Mark", examen.Mark);
if (cmdUpdateQuestion.ExecuteNonQuery() > 0)
{
examen = null;
}
conn.Close();
return(examen);
}
public bool InsertintoPayment(string paymentmode, UserLibrary user)
{
string num = "123456789";
int len = num.Length;
string otp = string.Empty;
int otpdigit = 5;
string finaldigit;
int getindex;
for (int i = 0; i < otpdigit; i++)
{
do
{
getindex = new Random().Next(0, len);
finaldigit = num.ToCharArray()[getindex].ToString();
} while (otp.IndexOf(finaldigit) != -1);
otp += finaldigit;
}
string testid = otp;
return(dal.InsertintoPayment(paymentmode, testid, user));
}
public List <UserLibrary> GetRegisterDetails()
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetRegisterDetails = new SqlCommand("proc_GetUserDetails", conn);
cmdGetRegisterDetails.CommandType = CommandType.StoredProcedure;
UserLibrary examen;
SqlDataReader dataReader = cmdGetRegisterDetails.ExecuteReader();
while (dataReader.Read())
{
examen = new UserLibrary();
examen.Phone = dataReader[0].ToString();
examen.Email = dataReader[1].ToString();
examen.Username = dataReader[2].ToString();
examen.Name = dataReader[4].ToString();
examens.Add(examen);
}
conn.Close();
return(examens);
}
public ActionResult EditMovie(UserMovie model)
{
string currentUser = User.Identity.GetUserId();
if (ModelState.IsValid)
{
foreach (Location l in model.locations)
{
if (!l.selected)
{
UserLibrary itemToRemove = db.UserLibraries.FirstOrDefault(ul => ul.userID == currentUser && ul.movieID == model.movie.movieID && ul.locationID == l.locationID);
if (itemToRemove != null)
{
db.UserLibraries.Remove(itemToRemove);
db.SaveChanges();
}
}
else
{
if (db.UserLibraries.FirstOrDefault(ul => ul.userID == currentUser && ul.movieID == model.movie.movieID && ul.locationID == l.locationID) == null)
{
UserLibrary itemToAdd = new UserLibrary()
{
userID = currentUser, locationID = l.locationID, movieID = model.movie.movieID
};
db.UserLibraries.Add(itemToAdd);
db.SaveChanges();
}
}
}
return(RedirectToAction("MyLibrary"));
}
else
{
return(View(model.movie.movieID));
}
}
public List <UserLibrary> GetAdminDetails()
{
conn.Open();
List <UserLibrary> examens = new List <UserLibrary>();
cmdGetAdminDetails = new SqlCommand("proc_AdminDetails", conn);
cmdGetAdminDetails.CommandType = CommandType.StoredProcedure;
UserLibrary examen;
SqlDataReader dataReader = cmdGetAdminDetails.ExecuteReader();
while (dataReader.Read())
{
examen = new UserLibrary();
examen.Admin_name = dataReader[0].ToString();
examen.Admin_email = dataReader[1].ToString();
examen.Admin_phone = dataReader[2].ToString();
examen.Admin_username = dataReader[3].ToString();
examen.Admin_Image = dataReader[5].ToString();
examens.Add(examen);
}
conn.Close();
return(examens);
}
static void Main(string[] args)
{
Console.WriteLine("Start!");
var genre = new Genre("Dubstep");
_genreRepository.Add(genre);
Console.WriteLine("Genre created");
var country = new Country("Germany");
_countryRepository.Add(country);
Console.WriteLine("Country created");
var userData = new CommonUserData("Egop", "Bird", "Tit", DateTime.Today);
_commonUserDataRepository.Add(userData);
Console.WriteLine("CommonUserData created");
var userLibrary = new UserLibrary(new List <Album>(), new List <Playlist>());
_userLibraryRepository.Add(userLibrary);
Console.WriteLine("UserLibrary created");
var art = new Art("image.jpg");
_artRepository.Add(art);
Console.WriteLine("Art created");
var playlist = new Playlist("test playlist", "test description", art, userLibrary,
new List <TrackToPlaylist>());
_playlistRepository.Add(playlist);
Console.WriteLine("Playlist created");
userLibrary.Playlists.Add(playlist);
_userLibraryRepository.Update(userLibrary);
Console.WriteLine("Playlist added to UserLibrary");
var distributorData = new DistributorData("test distributor", country, new List <Album>(),
new List <ArtistToDistributor>());
_distributorDataRepository.Add(distributorData);
Console.WriteLine("DistributorData created");
var album = new Album("test album", DateTime.Now, art, genre, distributorData, new List <Track>());
_albumRepository.Add(album);
Console.WriteLine("Album created");
var track = new Track("Terror Drums", "test.mp3", 0, false, album, new List <TrackToPlaylist>());
track.Playlists.Add(new TrackToPlaylist(track, playlist));
_trackRepository.Add(track);
Console.WriteLine("Track created");
//foreach (var genre in _genreRepository.GetAll())
//{
// Console.WriteLine(genre.Title);
//}
Console.ReadKey();
}
public LoginController(UserLibrary userLibrary, CompanyLibrary companyLibrary, ILogger <LoginController> logger)
{
_userLibrary = userLibrary;
_companyLibrary = companyLibrary;
_logger = logger;
}
public bool AdminLogInUserValidation(UserLibrary user)
{
return(dal.AdminLogInValidation(user));
}
public UserLibrary UpdateQuestion(UserLibrary examen)
{
return(dal.UpdateQuestion(examen));
}
