public ActionResult Register(UserModel account, HttpPostedFileBase upload)
{
try
{
var userNameToCheck = account.Username;
var EmailToCheck = account.Email;
var EmailExists = db.userModel.Any(x => x.Email == userNameToCheck);
var userNameExists = db.userModel.Any(x => x.Username == userNameToCheck);
if (!EmailExists && !userNameExists)
{
if (ModelState.IsValid)
{
if (upload != null && upload.ContentLength > 0)
{
var avatar = new File
{
FileName = System.IO.Path.GetFileName(upload.FileName),
FileType = FileType.Avatar,
ContentType = upload.ContentType
};
using (var reader = new System.IO.BinaryReader(upload.InputStream))
{
avatar.Content = reader.ReadBytes(upload.ContentLength);
}
account.Files = new List <File> {
avatar
};
}
using (OurDbContext db = new OurDbContext())
{
db.userModel.Add(account);
db.SaveChanges();
}
ModelState.Clear();
}
}
else if (EmailExists)
{
ModelState.AddModelError("CustomErrorEmail", "There is already a user with that Email.");
return(View(account));
}
else if (userNameExists)
{
ModelState.AddModelError("CustomErrorUser", "There is already a user with that UserName.");
return(View(account));
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
//ViewBag.Message = "Du har blivit registerad. Var vänlig logga in";
return(RedirectToAction("Login"));
}
public JsonResult CheckDavanameno(string davaadi, string musteritanimi, string musterino, string davano)
{
string[] donut = new string[2];
using (OurDbContext db = new OurDbContext())
{
Davalar mst;
BitenDavalar bmst;
if (davaadi != null && musteritanimi != null && musterino != null)
{
if (musteritanimi == "k" || musteritanimi == "kk")
{
mst = db.musterilers.Where(x => x.musteriTc == musterino).FirstOrDefault().Davalars.Where(y => y.DavaAdi == davaadi).FirstOrDefault();
bmst = db.musterilers.Where(x => x.musteriTc == musterino).FirstOrDefault().BDavalars.Where(y => y.DavaAdi == davaadi).FirstOrDefault();
if (mst == null && bmst == null)
{
donut[0] = "Avaliable";
}
else
{
donut[0] = "Not Avaliable";
}
}
else if (musteritanimi == "b" || musteritanimi == "bk")
{
bmst = db.bitenmusterilers.Where(x => x.musteriTc == musterino).FirstOrDefault().BDavalars.Where(y => y.DavaAdi == davaadi).FirstOrDefault();
if (bmst == null)
{
donut[0] = "Avaliable";
}
else
{
donut[0] = "Not Avaliable";
};
}
else
{
donut[0] = "externalerror";
}
}
else
{
donut[0] = "externalerror";
}
Davalar dv = new Davalar();
BitenDavalar dvb = new BitenDavalar();
dv = db.davalars.Where(x => x.DavaNo == davano).FirstOrDefault();
dvb = db.bitendavalars.Where(x => x.DavaNo == davano).FirstOrDefault();
if (dv == null && dvb == null)
{
donut[1] = "Avaliable";
}
else
{
donut[1] = "Not Avaliable";
}
}
return(Json(donut, JsonRequestBehavior.AllowGet));
}
public IActionResult Index()
{
using (OurDbContext db = new OurDbContext())
{
return(View(db.userAccount.ToList()));
}
}
//
// GET: /Account/
public ActionResult Index()
{
using (var db = new OurDbContext())
{
return(View(db.User.ToList()));
}
}
public string ucretGuncelle(string ID, string TC, string yeni, string tercih)
{
using (OurDbContext db = new OurDbContext())
{
if (tercih == "tc")
{
Davalar guncellenecek = db.davalars.Where(x => ((x.Musteriler.musteriTc == TC) && ((x.DavaAdi + x.DavaAciklama.ToString()).Equals(ID)))).FirstOrDefault();
if (guncellenecek != null)
{
guncellenecek.DavaUcret = Int32.Parse(yeni, CultureInfo.CurrentCulture);
db.SaveChanges();
return("basarili");
}
return("basarisiz");
}
else
{
Davalar guncellenecek = db.davalars.Where(x => x.DavaNo == TC).FirstOrDefault();
if (guncellenecek != null)
{
guncellenecek.DavaUcret = Int32.Parse(yeni, CultureInfo.CurrentCulture);
db.SaveChanges();
return("basarili");
}
return("basarisiz");
}
}
}
public ActionResult Login(UserAccount user)
{
using (OurDbContext db = new OurDbContext())
{
System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();
byte[] bs = System.Text.Encoding.UTF8.GetBytes(user.Password);
bs = x.ComputeHash(bs);
System.Text.StringBuilder s = new System.Text.StringBuilder();
foreach (byte b in bs)
{
s.Append(b.ToString("x2").ToLower());
}
user.Password = s.ToString();
var usr = db.userAccount.Single(u => u.Email == user.Email && u.Password == user.Password);
if (usr != null)
{
Session["UserId"] = usr.UserId.ToString();
Session["Email"] = usr.Email.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
ModelState.AddModelError("", "Email or password is wrong.");
}
}
return(View());
}
public ActionResult Login(string tc, string tcsifre)
{
using (OurDbContext db = new OurDbContext())
{
global = "";
var usr = db.musterilers.Where(x => x.musteriTc == tc && x.MusteriSifre == tcsifre).FirstOrDefault();
var biten = db.bitenmusterilers.Where(x => x.musteriTc == tc && x.MusteriSifre == tcsifre).FirstOrDefault();
if (usr != null)
{
Session["user"] = "******";
musteritc = usr.musteriTc;
return(RedirectToAction("musteriPanel"));
}
else if (biten != null)
{
Session["user"] = "******";
musteritc = biten.musteriTc;
return(RedirectToAction("musteriPanel"));
}
else
{
Session["user"] = "******";
global = "error";
return(RedirectToAction("Index"));
}
}
}
protected override void Seed(OurDbContext context)
{
var assembly = Assembly.GetExecutingAssembly();
try
{
using (var stream = assembly.GetManifestResourceStream("EBanking.Data.Seed-1.txt"))
using (var reader = new StreamReader(stream))
{
context.Database.ExecuteSqlCommand(reader.ReadToEnd());
}
}
catch (NpgsqlException ex)
{
if (!ex.Message.Contains("extension \"uuid-ossp\" already exists"))
{
throw ex;
}
}
using (var stream = assembly.GetManifestResourceStream("EBanking.Data.Seed-2.txt"))
using (var reader = new StreamReader(stream))
{
context.Database.ExecuteSqlCommand(reader.ReadToEnd());
}
}
public ActionResult Register(UserAccount account)
{
if (ModelState.IsValid)
{
//string fileName = null;
//string extension = null;
string fileName = Path.GetFileNameWithoutExtension(account.ImageFile.FileName);
string extension = Path.GetExtension(account.ImageFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
account.ImagePath = fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
account.ImageFile.SaveAs(fileName);
using (OurDbContext db = new OurDbContext())
{
db.userAccount.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.FullName + "succesfully registerd";
return(RedirectToAction("Login"));
}
else
{
ViewBag.Message = "username or passsword is wrong.";
string newUrl = Url.Action("Login#signup");
string plussedUrl = newUrl.Replace("%23", "#");
return(new RedirectResult(plussedUrl));
//return RedirectToAction("Login#signup");
}
}
public ActionResult Register(UserAccount account)
{
if (ModelState.IsValid)
{
List <String> userNames = new List <String>();
using (var db = new OurDbContext())
{
var result = from u in db.userAccount
select u.Username;
foreach (var item in result)
{
userNames.Add(item);
}
}
foreach (var item in userNames)
{
if (item == account.Username)
{
ModelState.AddModelError("Username", "Användarnamnet är redan upptaget");
return(View(account));
}
}
using (OurDbContext db = new OurDbContext())
{
db.userAccount.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.Name + " successfully registered.";
}
return(View(account));
}
public ActionResult ShowUser(string username)
{
try
{
if (username != System.Web.HttpContext.Current.User.Identity.Name)
{
using (var db = new OurDbContext())
{
UserAccount user = new UserAccount();
var result = from u in db.userAccount
where u.Username == username
select u;
foreach (var u in result)
{
user.Username = u.Username;
user.Name = u.Name;
user.age = u.age;
user.Description = u.Description;
user.ProfilePicture = u.ProfilePicture;
}
return(View(user));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
catch
{
return(RedirectToAction("Index", "Home"));
}
}
private bool UsernameAvailable(string username)
{
var usernames = new List <String>();
bool available = false;
using (var db = new OurDbContext())
{
var result = from u in db.userAccount
select u.Username;
foreach (var u in result)
{
usernames.Add(u);
}
}
foreach (var u in usernames)
{
if (u == username)
{
available = false;
break;
}
else
{
available = true;
}
}
return(available);
}
public ActionResult EditProfile()
{
try
{
var username = System.Web.HttpContext.Current.User.Identity.Name;
using (var db = new OurDbContext())
{
UserAccount user = new UserAccount();
var result = from u in db.userAccount
where u.Username == username
select u;
foreach (var u in result)
{
user.ProfilePicture = u.ProfilePicture;
user.Username = u.Username;
user.Description = u.Description;
user.age = u.age;
user.Visible = u.Visible;
}
return(View(user));
}
}
catch
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult List()
{
using (OurDbContext db = new OurDbContext())
{
return(View(db.regemp.ToList()));
}
}
// GET: Account
public ActionResult Index()
{
using (OurDbContext db = new OurDbContext())
{
return(View(db.userAccount.ToList().OrderBy(u => u.Age)));
}
}
public ActionResult Login(UserAccount user)
{
using (OurDbContext db = new OurDbContext())
{
if (user.Email != null && user.Password != null)
{
//db.userAccount.Single(u => u.Email == user.Email && u.Password == user.Password);
var usr = db.userAccount.Where(u => u.Email.Equals(user.Email) && u.Password.Equals(user.Password)).FirstOrDefault();
if (usr != null)
{
Session["UserID"] = usr.UserID.ToString();
Session["Email"] = usr.Email.ToString();
Session["FullName"] = usr.FullName.ToString();
Session["ImgPath"] = usr.ImagePath.ToString();
Session["UserType_Id"] = usr.UserType_Id.ToString();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "username or passsword is wrong.");
return(View());
}
}
else
{
ModelState.AddModelError("", "PLZ fill All the fileds.");
return(View());
}
}
}
// GET: Account
public ActionResult Index()
{
using (OurDbContext db = new OurDbContext())
{
return(View());
}
}
public ActionResult Details(int id)
{
OurDbContext ourDbContext = new OurDbContext();
OsobaZaginiona osobaZaginiona = ourDbContext.Zaginieci.Single(emp => emp.UserId == id);
return(View(osobaZaginiona));
}
public static void Work()
{
using (var db = new OurDbContext())
{
db.ApplyInterest(0.01m);
}
}
public ActionResult Edit(int id)
{
using (OurDbContext edit = new OurDbContext())
{
return(View(edit.Users.Where(x => x.UserId == id).FirstOrDefault()));
}
}
public ActionResult musteriPanel()
{
if (Session["user"] != null)
{
if (Session["user"].ToString() == "aktif")
{
OurDbContext db = new OurDbContext();
musteriPanelViewModel mst = new musteriPanelViewModel();
var usr = db.musterilers.Where(x => x.musteriTc == musteritc).FirstOrDefault();
var biten = db.bitenmusterilers.Where(x => x.musteriTc == musteritc).FirstOrDefault();
if (usr != null)
{
mst.musteriler = usr;
return(View(mst));
}
else
{
mst.bitenMusteriler = biten;
return(View(mst));
}
}
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int id)
{
using (OurDbContext delete = new OurDbContext())
{
return(View(delete.Users.Where(x => x.UserId == id).FirstOrDefault()));
}
}
public ActionResult Register(UserAccount account)
{
if (ModelState.IsValid)
{
using (var db = new OurDbContext())
{
var hash = PasswordUncode.Hash(account.Password);
var user = new DataBaseUserModel
{
UserName = account.UserName,
Password = hash,
FullName = account.FullName,
Email = account.Email,
DateRegistered = DateTime.Now
};
db.User.Add(user);
db.SaveChanges();
}
ModelState.Clear();
//ViewBag.Message = account.FullName + " successfully registered";
return(RedirectToAction("RegisterSuccessfully"));
}
return(View());
}
public ActionResult Login(UserAccount user)
{
using (OurDbContext db = new OurDbContext())
{
var usr = db.Users.Single(u => u.Username == user.Username && u.Password == user.Password);
if (usr != null)
{
if (usr.IsAdmin == true)
{
Session["UserIdAdmin"] = usr.UserId.ToString();
Session["Username"] = usr.Username.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
if (usr.ConfirmRegistration == true)
{
Session["UserID"] = usr.UserId.ToString();
Session["Username"] = usr.Username.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
ModelState.AddModelError("", "Konto nie zostało zweryfikowane");
}
}
}
else
{
ModelState.AddModelError("", "Logi lub hasło jest nieprawidłowe");
}
}
return(View());
}
public JsonResult kurumsalDavaGetir(string ID)
{
using (OurDbContext db = new OurDbContext())
{
string[] veriler = new string[8];
Davalar dv = new Davalar();
dv = db.davalars.Where(x => x.DavaId.ToString() == ID).FirstOrDefault();
if (dv != null)
{
veriler[0] = "geldi";
veriler[1] = dv.Musteriler.musteriAd;
veriler[2] = dv.DavaAdi;
veriler[3] = dv.DavaAciklama;
veriler[4] = dv.davaturu.ToString();
veriler[5] = dv.BaslangicTarihi.ToString(CultureInfo.CurrentCulture);
veriler[6] = dv.Avukat.AvukatAd + " " + dv.Avukat.AvukatSoyad;
veriler[7] = dv.DavaUcret.ToString(CultureInfo.CurrentCulture);
return(Json(veriler, JsonRequestBehavior.AllowGet));
}
else
{
veriler[0] = "gelmedi";
return(Json(veriler, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult Register(UserAccount user)
{
try
{
if (ModelState.IsValid)
{
using (OurDbContext db = new OurDbContext())
{
if (db.userAccount.Any(u => u.Username == user.Username))
{
ModelState.AddModelError("", "Username already exists");
return(View());
}
db.userAccount.Add(user);
db.SaveChanges();
}
ModelState.Clear();
}
return(View());
}
catch (Exception e)
{
ModelState.AddModelError("", "Username already exists");
return(View());
}
}
public ActionResult Register(UserAccounts account)
{
using (OurDbContext db = new OurDbContext())
{
var UserStatus = db.userAccounts.FirstOrDefault(u => u.Anummer == account.Anummer);
if (UserStatus != null)
{
ViewBag.message = account.Anummer + " " + "already exists, Contact Administrator. ";
}
else if (ModelState.IsValid)
{
//using (OurDbContext db = new OurDbContext())
{
db.userAccounts.Add(account);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = account.FullName + " " + "has been successfully registered";
}
return(View());
}
}
// Delete Multiple Images
public ActionResult DeleteImages()
{
using (OurDbContext db = new OurDbContext())
{
return(View(db.gallery.ToList()));
}
}
// GET: Account
public ActionResult Index()
{
using (OurDbContext db = new OurDbContext())
{
return(View(db.pengguna.ToList()));
}
}
public ActionResult Login(UserAccount user)
{
using (OurDbContext db = new OurDbContext())
{
try
{
var usr = db.UserAccounts.SingleOrDefault(c => c.UserName == user.UserName && c.Password == user.Password);
if (usr != null)
{
Session["UserId"] = usr.UserId.ToString();
Session["UserName"] = usr.UserName.ToString();
return(RedirectToAction("LoggedIn"));
}
else
{
ModelState.AddModelError("", "User Name or Password is Wrong");
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
return(View());
}
