//TODO pazi ne setujemo avatar
public static User addUser(string name, string username, string password, string email, string bio = null, string location = null, string surname = null)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
User u = new User
{
name = name,
username = username,
password = password,
email = email,
bio = bio,
location = location,
surname = surname,
score = 0,
avatar = null,
lastLogin = DateTime.Now,
dateRegistered = DateTime.Now,
totalCardsLearned = 0,
streak = 0,
};
dc.Users.InsertOnSubmit(u);
dc.SubmitChanges();
return u;
}
public string RegisterUser(string username, string password, string confirmPassword)
{
// If there is already a logged in user, the action returns There is already a logged in user
if (this.Data.CurrentUser != null)
{
return "There is already a logged in user";
}
// If the two passwords do not match, the action returns The provided passwords do not match
if (password != confirmPassword)
{
return "The provided passwords do not match";
}
// If the username is already taken, the action returns A user with username <username> already exists
if (this.Data.UserName_User.ContainsKey(username))
{
return string.Format("A user with username {0} already exists", username);
}
// In case of success, the action returns User <username> registered successfully
var user = new User(username, password);
this.Data.UserName_User.Add(username, user);
return string.Format("User {0} registered successfully", username);
}
public static void AddUser(User user)
{
DataClassesDataContext db = new DataClassesDataContext();
user.id = GetNextId();
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
}
public int Create(User user)
{
shoppingCardDB.Users.Add(user);
Save();
return user.PKUserId;
}
public ActionResult Create([Bind(Include = "FirstName,LastName,EmailId,Password,Address,City,State,Country,ZipCode,Mobile")] RegisterViewModel viewModel)
{
try
{
if (ModelState.IsValid)
{
Data.User user = new Data.User();
Data.UserAddress userAddress = new UserAddress();
// ShippingAddressRepository shReop = new ShippingAddressRepository();
user.FirstName = viewModel.FirstName;
user.LastName = viewModel.LastName;
user.EmailId = viewModel.EmailId;
user.Password = viewModel.Password;
user.Role = "U";
user.UserName = viewModel.FirstName + " " + viewModel.LastName;
if (!userRepo.VerifyEmail(viewModel.EmailId))
{
userRepo.Create(user);
int userId = userRepo.GetByEmail(viewModel.EmailId).PKUserId;
userAddress.FKUserId = userId;
userAddress.Address = viewModel.Address;
userAddress.City = viewModel.City;
userAddress.State = viewModel.State;
userAddress.Country = viewModel.Country;
userAddress.ZipCode = viewModel.ZipCode;
userAddress.Mobile = viewModel.Mobile;
sAddresRepo.Create(userAddress);
TempData["Msg"] = "Created Successfully";
return RedirectToAction("Index");
}
else
{
TempData["Msg"] = "Email already exits";
return RedirectToAction("Index");
}
}
else
{
return View("Index");
}
}
catch (Exception e)
{
TempData["Msg"] = "Create Failed : " + e.Message;
return RedirectToAction("Index");
}
}
public TastingContest CreateTastingContest(User organizor, string description)
{
var tastingContest = new TastingContest();
tastingContest.OrganizorId = organizor.Id;
tastingContest.Description = description;
tastingContest.CreatedDate = DateTime.UtcNow;
//tastingContest.StartDate = DateTime.UtcNow;
return tastingContest;
}
public static void UpdateUser(User user)
{
DataClassesDataContext db = new DataClassesDataContext();
db.Users.Where(u => u.id == user.id)
.ToList()
.ForEach(u =>
{
u.name = user.name;
u.password = user.password;
u.role = user.role;
});
db.SubmitChanges();
}
public void Init()
{
// prepare traveler
traveler = new User()
{
FirstName = "Miroslaw",
LastName = "Luch",
Email = "*****@*****.**",
BirthDate = DateTime.Now,
Languages = new List<Language>()
{
new Language("English"),
new Language("German")
} ,
Interests = new List<Interest>()
{
new Interest("Volleyball"),
new Interest("Singing"),
new Interest("Programming"),
new Interest("Sailing"),
new Interest("Weaponry")
}
};
// prepare guide
guide = new User()
{
FirstName = "Johnny",
LastName = "Jay",
Email = "*****@*****.**",
BirthDate = DateTime.Now,
Languages = new List<Language>()
{
new Language("English"),
new Language("German"),
new Language("Japanese")
},
Interests = new List<Interest>()
{
new Interest("Volleyball"),
new Interest("Singing"),
new Interest("Science"),
new Interest("Animals"),
new Interest("Sightseeing")
}
};
}
public Session(User user)
{
UserID = user.Id;
Token = GenerateToken();
TimeStamp = DateTime.Now;
}
private void Save()
{
if (ViewState["mode"].ToString() == "Add")
{
ProgrammingContestDataContextHandler pcdch = new ProgrammingContestDataContextHandler();
Data.User user = new Data.User();
user.Name = txtName.Text;
user.IPAddress = txtIPAddress.Text;
pcdch.ProgrammingContestDatabase.Users.InsertOnSubmit(user);
pcdch.ProgrammingContestDatabase.SubmitChanges();
user = pcdch.Users.GetByName(txtName.Text);
long contestId = Convert.ToInt64(ddlSelectContest.SelectedValue);
if (CheckBox1.Checked == true)
{
if (pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId) == null)
{
ContestPermission cp = new ContestPermission();
cp.ContestSetting = pcdch.ContestSetting.GetById(contestId);
cp.ContestId = contestId;
cp.User = user;
cp.UserId = user.ID;
pcdch.ProgrammingContestDatabase.ContestPermissions.InsertOnSubmit(cp);
}
}
else
{
if (pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId) != null)
{
ContestPermission cp = pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId);
pcdch.ProgrammingContestDatabase.ContestPermissions.DeleteOnSubmit(cp);
}
}
pcdch.ProgrammingContestDatabase.SubmitChanges();
rptProblems.DataSource = pcdch.Users.GetAllWithOutAdmin();
rptProblems.DataBind();
}
else if (ViewState["mode"].ToString() == "Edit")
{
ProgrammingContestDataContextHandler pcdch = new ProgrammingContestDataContextHandler();
Data.User user = pcdch.Users.GetById(Convert.ToInt64(ViewState["ID"].ToString()));
user.Name = txtName.Text;
user.IPAddress = txtIPAddress.Text;
pcdch.ProgrammingContestDatabase.SubmitChanges();
user = pcdch.Users.GetByName(txtName.Text);
long contestId = Convert.ToInt64(ddlSelectContest.SelectedValue);
if (CheckBox1.Checked == true)
{
if (pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId) == null)
{
ContestPermission cp = new ContestPermission();
cp.ContestSetting = pcdch.ContestSetting.GetById(contestId);
cp.ContestId = contestId;
cp.User = user;
cp.UserId = user.ID;
pcdch.ProgrammingContestDatabase.ContestPermissions.InsertOnSubmit(cp);
}
}
else
{
if (pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId) != null)
{
ContestPermission cp = pcdch.ContestPermission.GetByUserIdAndContestId(user.ID, contestId);
pcdch.ProgrammingContestDatabase.ContestPermissions.DeleteOnSubmit(cp);
}
}
pcdch.ProgrammingContestDatabase.SubmitChanges();
rptProblems.DataSource = pcdch.Users.GetAllWithOutAdmin();
rptProblems.DataBind();
}
mvProblem.ActiveViewIndex = 0;
}
partial void DeleteUser(User instance);
partial void UpdateUser(User instance);
partial void InsertUser(User instance);
public ActionResult OrderDetail(OrderViewModel model)
{
OrderRepository orderRepo = new OrderRepository();
OrderDetailRepository orderDetailRepo = new OrderDetailRepository();
ShippingAddressRepository shARepo = new ShippingAddressRepository();
Data.Order order = new Order();
Data.OrderDetail orderDetail = new Data.OrderDetail();
UserAddress userAddress = new UserAddress();
IEnumerable<Data.User> userList =userRepo.GetAllUsers();
Data.User user = new Data.User();
string body = null;
using (StreamReader sr = new StreamReader(Server.MapPath("~/Template/EmailTemp.html")))
{
body = sr.ReadToEnd();
}
if (User.Identity.IsAuthenticated)
{
string userEmail = User.Identity.Name;
currentUer = userRepo.GetByEmail(userEmail);
order.FKUserId = currentUer.PKUserId;
int orderId = orderRepo.Create(order);
order.User = currentUer;
productId = (IList<string>)Session["ProId"];
foreach (var item in productId)
{
int id = Convert.ToInt32(item);
orderDetail.FKOrderId = orderId;
orderDetail.FKProductId = id;
orderDetail.Status = "In Store";
orderDetail.Quantity = (int)prodReop.GetById(id).Quantity;
orderDetail.Cost = (decimal)prodReop.GetById(id).Price;
orderDetailRepo.Create(orderDetail);
}
model.UserName = currentUer.FirstName+" "+currentUer.LastName;
userAddress = shARepo.GetAddressByUserId(currentUer.PKUserId);
model.Address = userAddress.Address;
model.Mobile = userAddress.Mobile;
AddCart();
model.Carts = cartReop.GetCartItems(currentUer.PKUserId);
model.SubPrice = cart.Quantity * cart.Price;
model.TotalPrice = Convert.ToDecimal(GetItemsPrice());
TempData["Tax"] = .25;
body = body.Replace("[UserName]", currentUer.FirstName + " " + currentUer.LastName);
body = body.Replace("[Mobile]", userAddress.Mobile);
body = body.Replace("[Adderss]", userAddress.Address);
body = body.Replace("[Date]", DateTime.Now.ToString());
body = RazorEngine.Razor.Parse(body, model);
body = body.Replace("[SubPrice]", model.SubPrice.ToString());
//body = body.Replace("[Tax]", tax.ToString());
body = body.Replace("[TotalPrice]", model.TotalPrice.ToString());
EmailUtility.SendEmail(userEmail, "E-Shop", body, null);
cartReop.EmptyCart(currentUer.PKUserId);
return View("OrderDetail", model);
}
else
{
user.UserName = model.FirstName + " " + model.LastName;
user.FirstName = model.FirstName;
user.LastName = model.LastName;
user.EmailId = model.Email;
user.Password = model.Password;
user.Role = "U";
userId = userRepo.Create(user);
order.FKUserId = userId;
int orderId = orderRepo.Create(order);
productId = (IList<string>)Session["ProId"];
foreach (var item in productId)
{
int id = Convert.ToInt32(item);
orderDetail.FKOrderId = orderId;
orderDetail.FKProductId = id;
orderDetail.Status = "In Store";
orderDetail.Quantity = (int)prodReop.GetById(id).Quantity;
orderDetail.Cost = (decimal)prodReop.GetById(id).Price;
orderDetailRepo.Create(orderDetail);
}
userAddress.FKUserId = userId;
userAddress.Address = model.Address;
userAddress.City = model.City;
userAddress.State = model.State;
userAddress.Mobile = model.Mobile;
userAddress.Country = model.Country;
userAddress.ZipCode = Convert.ToInt32(model.Zipcode);
shARepo.Create(userAddress);
TempData["UserName"] = model.FirstName + " " + model.LastName;
TempData["Adderss"] = model.Address;
TempData["Mobile"] = model.Mobile;
TempData["Tax"] = .25;
AddCart();
model.Carts = cartReop.GetCartItems(userId);
model.SubPrice = cart.Quantity * cart.Price;
model.TotalPrice = Convert.ToDecimal(GetItemsPrice());
decimal tax = Convert.ToDecimal(model.TotalPrice) * Convert.ToDecimal(.25f);
body = body.Replace("[UserName]", model.FirstName + " " + model.LastName);
body = body.Replace("[Mobile]", model.Mobile);
body = body.Replace("[Adderss]", model.Address);
body = body.Replace("[Date]", DateTime.Now.ToString());
body = RazorEngine.Razor.Parse(body, model);
body = body.Replace("[SubPrice]", model.SubPrice.ToString());
body = body.Replace("[Tax]", tax.ToString());
body = body.Replace("[TotalPrice]", model.TotalPrice.ToString());
EmailUtility.SendEmail(model.Email, "E-Shop", body, null);
cartReop.EmptyCart(userId);
return PartialView("_OrderDetail", model);
}
}
private void RefreshCurrentUser(User user)
{
AvatarUri = user.AvatarMediumUrl;
}
public void Update(User user)
{
shoppingCardDB.Entry(user).State = EntityState.Modified;
Save();
}
private void UserHubOnUserUpdated(User user)
{
if (user.Id == App.CurrentUserId.ToString())
{
RefreshCurrentUser(user);
}
}
public int Update(User item)
{
using (var connection = GetRealTimeConnection())
{
connection.Open();
return connection.Execute("UPDATE [dbo].[Users] SET UserName = @UserName, Email = @Email, HashedPassword = @HashedPassword, Created = @Created, GlobalRole = @GlobalRole WHERE UserId = @UserId", item);
}
}
public short Create(User item)
{
using (var connection = GetRealTimeConnection())
{
connection.Open();
short newId = connection.ExecuteScalar<short>("INSERT INTO [dbo].[Users] VALUES(@UserName, @Email, @HashedPassword, @Created, @GlobalRole);SELECT SCOPE_IDENTITY()", item);
return newId;
}
}
public Registration()
{
User = new User();
Interests = new List<InterestModel>();
LanguageContainer = new List<Language>();
}
public ActionResult OrderDetail(OrderViewModel model)
{
OrderRepository orderRepo = new OrderRepository();
OrderDetailRepository orderDetailRepo = new OrderDetailRepository();
ProductRepository prodReop = new ProductRepository();
Data.Order order = new Order();
Data.OrderDetail orderDetail = new Data.OrderDetail();
IEnumerable<Data.User> userList = userRepo.GetAllUsers();
Data.User user = new Data.User();
if (User.Identity.IsAuthenticated)
{
return PartialView("_OrderDetail", model);
}
else
{
foreach (Data.User u in userList)
{
if (model.Email == u.EmailId)
{
//throw new ApplicationException("Email is already registered");
TempData["Msg"] = "Email is already registerd";
return RedirectToAction("CheckOut");
}
}
user.UserName = model.FirstName + " " + model.LastName;
user.FirstName = model.FirstName;
user.LastName = model.LastName;
user.EmailId = model.Email;
user.Password = model.Password;
user.Role = "U";
int userId = userRepo.Create(user);
order.FKUserId = userId;
int orderId = orderRepo.Create(order);
productId = (IList<string>)Session["ProId"];
foreach (var item in productId)
{
int id = Convert.ToInt32(item);
orderDetail.FKOrderId = orderId;
orderDetail.FKProductId = id;
orderDetail.Status = "In Store";
orderDetail.Quantity = (int)prodReop.GetById(id).Quantity;
orderDetail.Cost = (decimal)prodReop.GetById(id).Price;
orderDetailRepo.Create(orderDetail);
//products.Add(db.Products.Find(productId));
}
}
return PartialView("_OrderDetail", model);
}
public override async Task Invoke(IOwinContext context)
{
if (context.Request.Uri.AbsolutePath == "/login")
{
var userName = context.Request.Query["user"] ?? context.Request.Cookies["userName"];
var password = context.Request.Query["password"];
if (userName == null || password == null) throw new Exception();
using (var prov = DbManager.Factory.GetProvider())
{
if (!prov.Users.CheckPassword(userName, password))
{
AuthFailed(context);
return;
}
}
// check if he is not already logged at another node
int alreadyLoggedIn;
if (Global.AllClients.TryGetValue(userName, out alreadyLoggedIn))
{
if (alreadyLoggedIn != Global.OperatorId)
{
using (var p = DbManager.Factory.GetProvider())
{
context.Response.Redirect(p.Operators.Get(alreadyLoggedIn).PublicAddress);
}
return;
}
}
var token = Guid.NewGuid();
TokensToDelete.Enqueue(new TokenToDelete { Token = token, Created = DateTime.Now });
Global.Tickets.TryAdd(token, new AuthTicket() { ConnectionId = null, Token = token, UserName = userName });
context.Response.Cookies.Append("userName", userName);
context.Response.Write(token.ToString());
}
else if (context.Request.Uri.AbsolutePath == "/register")
{
// TODO: validate
var now = DateTime.Now;
var user = new User()
{
Name = context.Request.Query["name"],
Email = context.Request.Query["email"],
Registered = now
};
var group = new Group
{
Name = string.Format("_{0}", user.Name),
RegisteredUsers = new string[]{ user.Name },
ProfilePage = "Primary group of " + user.Name,
PrivateData = new byte[0],
PublicKeys = new Dictionary<string, byte[]>()
};
user.PersonalGroup = group.Name;
using (var prov = DbManager.Factory.GetProvider())
{
prov.Groups.Save(group);
user.PasswordHash = prov.Users.Crypter.Crypt(Encoding.Unicode.GetBytes(context.Request.Query["password"]));
prov.Users.Save(user);
}
}
else if(context.Request.Uri.AbsolutePath == "/ping")
{
await context.Response.WriteAsync("hi, I am here");
}
else await Next.Invoke(context);
}
public void CleanUp()
{
traveler = null;
guide = null;
}
