// GET: Login
public ActionResult Login(FormCollection fc)
{
string email = fc["txtEmail"].ToString();
string password = fc["txtPassword"].ToString();
string passMD5 = "";
byte[] buffer = Encoding.UTF8.GetBytes(password);
MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
buffer = md5.ComputeHash(buffer);
for (int i = 0; i < buffer.Length; i++)
{
passMD5 = passMD5 + buffer[i].ToString("x2");
}
tbl_Admin Admin = db.tbl_Admin.SingleOrDefault(n => n.emailAdmin == email && n.password == passMD5);
if (Admin == null)
{
ViewBag.Noti = "Wrong email or password";
return(View());
}
else
{
Session["Admin"] = Admin;
return(View("EditAdmin"));
}
}
public ActionResult AddAdmin(AdminMangementModel AddAdmin)
{
// شرط بيستخدم إن لو في حد حاول يدخل الرابط وهو مش مسجل دخول فبيرجعه لصفحة تسجيل الدخول
if (Session["Admin_Id"] == null || Session["Admin_Name"] == null)
{
return(RedirectToAction("AdminLogin", "Home"));
}
else
{
if (ModelState.IsValid)
{
// التأكد أن البريد المدخل ليس موجود مسبقا
if (!db.tbl_Admin.Any(x => x.Admin_Email == AddAdmin.Admin_Email))
{
tbl_Admin adm = new tbl_Admin();
adm.Admin_Name = AddAdmin.Admin_Name;
adm.Admin_Email = AddAdmin.Admin_Email;
adm.Admin_Password = AddAdmin.Password;
adm.Admin_Phone = AddAdmin.Admin_Phone;
adm.Admin_CreatedOn = DateTime.Now;
adm.IsDeleted = false;
db.tbl_Admin.Add(adm);
db.SaveChanges();
return(RedirectToAction("AdminMangement"));
}
else
{
ViewBag.msg = "هذا الحساب موجود بالفعل";
}
}
return(View(AddAdmin));
}
}
public IHttpActionResult Puttbl_Admin(string id, tbl_Admin tbl_Admin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_Admin.Email)
{
return(BadRequest());
}
db.Entry(tbl_Admin).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_AdminExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void btnLogin_Click(object sender, EventArgs e)
{
string email = txtEmail.Text;
string passwrod = txtPassword.Text;
if (email != null && passwrod != null)
{
tbl_Admin Selectadmin = db.tbl_Admin.FirstOrDefault(ad => ad.Email == email);
if (Selectadmin != null)
{
if (Selectadmin.Password == passwrod)
{
Reserv rsv = new Reserv();
rsv.ShowDialog();
}
else
{
lblerror.Visible = true;
lblerror.Text = "Sifre yalnisdir ";
}
}
else
{
lblerror.Visible = true;
lblerror.Text = "Email yalnisdir";
}
}
}
public HttpResponseMessage Post([FromUri] int id, [FromBody] tbl_Customer customer)
{
System.Data.Entity.DbContextTransaction transaction = entities.Database.BeginTransaction();
tbl_Card card = new tbl_Card();
try
{
tbl_Card c = entities.tbl_Card.Where(ca => ca.Customer_Id == customer.Customer_Id).FirstOrDefault();
if (c != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Customer already activated."));
}
proc_ActivateCustomer_Result rslt = entities.proc_ActivateCustomer(customer.Customer_Id).FirstOrDefault();
card.Customer_Id = customer.Customer_Id;
card.Card_Number = RandomDigits(10);
card.Valid_till = DateTime.Today.AddYears(2).Date;
card.Card_Type = customer.Card_Type;
card.Total_credit = customer.Card_Type == "Gold" ? 50000 : 100000;
card.credit_used = 0;
card.Card_cost = customer.Card_Type == "Gold" ? 1000 : 2000;
card.Status = "Activated";
tbl_Admin admin = entities.tbl_Admin.Where(a => a.Admin_Id == id).FirstOrDefault();
card.ApprovedBy = id;
entities.tbl_Card.Add(card);
entities.SaveChanges();
proc_ActivateCard_Result result = entities.proc_ActivateCard(customer.Customer_Id).FirstOrDefault();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.Created, card));
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Could not add card"));
}
}
public ActionResult AdminSil(int id)
{
tbl_Admin t = repo.Find(x => x.Id == id);
repo.TDelete(t);
return(RedirectToAction("Index"));
}
public ActionResult Ekle(tbl_Admin k)
{
if (ModelState.IsValid)
{
try
{
int say = db.Adminler.Where(x => x.AdminAdi.ToLower() == k.AdminAdi.ToLower()).Count();
if (say == 0)
{
k.AdminAdi = k.AdminAdi.ToUpper();
db.Adminler.Add(k);
db.SaveChanges();
}
else
{
ModelState.AddModelError("", "böyle bir Admin zaten var.");
}
}
catch (Exception)
{
ViewBag.Hata = "Admin eklenirken Hatalar Oluştu.";
}
}
else
{
if (string.IsNullOrEmpty(k.AdminAdi) || string.IsNullOrEmpty(k.AdminSifre))
{
ModelState.AddModelError("", "Lütfe tüm alanları doldurunuz.");
}
}
return(View());
}
public HttpResponseMessage Postmanagerial(UyeBilgisi uyee)
{
try
{
using (var db = new HastaneDBEntities())
{
tbl_Doctor Doctor = new tbl_Doctor();
tbl_Admin Admin = new tbl_Admin();
tbl_HospitalManager Manager = new tbl_HospitalManager();
Doctor = db.tbl_Doctor.FirstOrDefault(x => x.Tckn == uyee.TcNo);
Admin = db.tbl_Admin.FirstOrDefault(x => x.Tckn == uyee.TcNo);
Manager = db.tbl_HospitalManager.FirstOrDefault(x => x.Tckn == uyee.TcNo);
if (Doctor != null)
{
if (Doctor.DoctorPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Doctor));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
if (Admin != null)
{
if (Admin.AdminPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Admin));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
if (Manager != null)
{
if (Manager.ManagerPassword == uyee.Password)
{
return(Request.CreateResponse(HttpStatusCode.OK, Manager));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Yanlış şifre"));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "TcNo Hatalı"));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public ViewResult ViewDetailAndImage(int HouseID = 0)
{
tbl_House house = db.tbl_House.SingleOrDefault(n => n.houseID == HouseID);
if (house == null)
{
Response.StatusCode = 404;
return(null);
}
House h = new House();
h.house = house;
h.listImage = db.tbl_Image.Where(n => n.houseID == house.houseID).ToList();
h.areaName = db.tbl_Area.SingleOrDefault(n => n.areaID == house.areaID).areaName;
int districtID = int.Parse(db.tbl_Area.SingleOrDefault(n => n.areaID == house.areaID).districtID.ToString());
h.districtName = db.tbl_District.SingleOrDefault(n => n.districtID == districtID).districtName;
string email = house.emailAdmin;
tbl_Admin admin = db.tbl_Admin.SingleOrDefault(n => n.emailAdmin == email);
ViewBag.InfoAdmin = admin.fullname + ", " + admin.phoneNumber;
return(View(h));
}
public void Delete(int id) //Upadate single records
{
tbl_Admin admin = db.tbl_Admin.Find(id);
db.tbl_Admin.Remove(admin);
save();
}
public ActionResult GetListHouseByAdmin()
{
tbl_Admin admin = (tbl_Admin)Session["Admin"];
string email = admin.emailAdmin;
List <tbl_House> listHouse = db.tbl_House.Where(n => n.emailAdmin == email).ToList();
return(View(listHouse));
}
public ActionResult AdminDuzenle(tbl_Admin p)
{
tbl_Admin t = repo.Find(x => x.Id == p.Id);
t.KullaniciAdi = p.KullaniciAdi;
t.Sifre = p.Sifre;
repo.TUpdate(t);
return(RedirectToAction("Index"));
}
public ActionResult AdminEdit(int?id)
{
var result = Context.tbl_Admin.SingleOrDefault(a => a.AdminID == id);
Session["Password"] = result.Password;
tbl_Admin std = new tbl_Admin();
std = Context.tbl_Admin.Find(id);
return(View(std));
}
// AdminCustomModel METHODS
public int Insert_Admin(AdminCustomModel model)
{
tbl_Admin admin = model.Admin;
//AdminCustomModel image_path = model.UserImageFiles;
int id = AdminSecurityDB_Obj.Insert(admin);
return(id);
}
public int Insert(tbl_Admin obj) //Insert single records
{
db.tbl_Admin.Add(obj);
save();
int Id = obj.ID;
return(Id);
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
tbl_Admin tbl_Admin = db.tbl_Admin.Find(id);
db.tbl_Admin.Remove(tbl_Admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult Posttbl_Admin(tbl_Admin tbl_Admin)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
string email = tbl_Admin.Email;
int myUser = db.tbl_Admin.Where(u => u.Email == tbl_Admin.Email && u.Password == tbl_Admin.Password).Count();
tbl_Admin tbl_User2 = db.tbl_Admin.ToList().Find(u => u.Email == tbl_Admin.Email && u.Password == tbl_Admin.Password);
if (myUser == 0)
{
return(NotFound());
}
if (myUser == 1)
{
//tbl_User tbl_User1 = db.tbl_User.Find(email);
return(Ok(tbl_User2.Email));
}
else
{
return(NotFound());
}
}
// db.tbl_Admin.Add(tbl_Admin);
catch (DbUpdateException)
{
if (tbl_AdminExists(tbl_Admin.Email))
{
return(Conflict());
}
else
{
throw;
}
}
// return CreatedAtRoute("DefaultApi", new { id = tbl_Admin.Email }, tbl_Admin);
}
public IHttpActionResult Deletetbl_Admin(string id)
{
tbl_Admin tbl_Admin = db.tbl_Admin.Find(id);
if (tbl_Admin == null)
{
return(NotFound());
}
db.tbl_Admin.Remove(tbl_Admin);
db.SaveChanges();
return(Ok(tbl_Admin));
}
public ActionResult AdminPersonalInfo()
{
int a = Convert.ToInt32(Session["AdminID"]);
tbl_Admin user = Context.tbl_Admin.Find(a);
if (user == null)
{
return(HttpNotFound());
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "id,username,pass,name")] tbl_Admin tbl_Admin)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
if (ModelState.IsValid)
{
db.Entry(tbl_Admin).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_Admin));
}
public ActionResult Create([Bind(Include = "id,username,pass,name")] tbl_Admin tbl_Admin)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
if (ModelState.IsValid)
{
db.tbl_Admin.Add(tbl_Admin);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_Admin));
}
public ActionResult adminManagementEdit(FormCollection form)
{
tbl_Admin tic = getAdmin();
var password = form["password"];
if (form["password"] != null)
{
tic.Password = password;
}
UpdateModel(tic);
data.SubmitChanges();
DataHelper.AccountHelper.getInstance().logoutAdmin(this);
return(RedirectToAction("Index", "Admin"));
}
public ActionResult DeleteMe([Bind(Exclude = ("Admin_CreatedOn,Admin_Name,Admin_Email,Admin_Password,Admin_CreatedOn"))] tbl_Admin EdAdm)
{
if (Session["Admin_Id"] == null || Session["Admin_Name"] == null)
{
return(RedirectToAction("AdminLogin", "Home"));
}
else
{
int id = (int)TempData["AdminId"];
var adm = db.tbl_Admin.Where(a => a.Admin_Id == id).FirstOrDefault();
adm.IsDeleted = true;
db.Entry(adm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Index(tbl_Admin p)
{
dbCVEntities1 db = new dbCVEntities1();
var bilgi = db.tbl_Admin.FirstOrDefault(x => x.KullaniciAdi == p.KullaniciAdi && x.Sifre == p.Sifre);
if (bilgi != null)
{
FormsAuthentication.SetAuthCookie(bilgi.KullaniciAdi, false);
Session["KullaniciAdi"] = bilgi.KullaniciAdi.ToString();
return(RedirectToAction("Index", "Deneyim"));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult DeleteAdmin([Bind(Exclude = ("Admin_CreatedOn,Admin_Name,Admin_Email,Admin_Password,Admin_CreatedOn"))] tbl_Admin EdAdm)
{
// شرط بيستخدم إن لو في حد حاول يدخل الرابط وهو مش مسجل دخول فبيرجعه لصفحة تسجيل الدخول
if (Session["Admin_Id"] == null || Session["Admin_Name"] == null)
{
return(RedirectToAction("AdminLogin", "Home"));
}
else
{
int id = (int)TempData["AdminId"];
var adm = db.tbl_Admin.Where(a => a.Admin_Id == id).FirstOrDefault();
adm.IsDeleted = true;
db.Entry(adm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("AdminMangement"));
}
}
public HttpResponseMessage RegisterAdmin(tbl_Admin admin)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
entities.tbl_Admin.Add(admin);
entities.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "Could not register admin"));
}
return(Request.CreateResponse(HttpStatusCode.Created, admin));
}
public ActionResult Authorise(tbl_Admin Login)
{
using (GästebuchEntities db = new GästebuchEntities())
{
var userDetails = db.tbl_Admin.Where(x => x.Username == Login.Username && x.Passwort == Login.Passwort).FirstOrDefault();
if (userDetails == null)
{
Login.LoginErrorMsg = "Invalid Username or Password";
return(View("Index", Login));
}
else
{
Session["rowguid"] = Login.rowguid;
return(RedirectToAction("Index", "EintragAdmin"));
}
}
}
public ActionResult Register(FormCollection fc)
{
bool error = false;
string email = fc["txtEmail"].ToString().Trim();
string password = fc["txtPassword"].ToString().Trim();
string fullname = fc["txtFullName"].ToString().Trim();
string phone = fc["txtPhoneNumber"].ToString().Trim();
string bank = fc["txtBankNumber"].ToString().Trim();
if (db.tbl_Admin.SingleOrDefault(n => n.emailAdmin == email) != null)
{
ViewBag.Noti = "Email đã tồn tại.";
error = true;
}
string passMD5 = "";
byte[] buffer = Encoding.UTF8.GetBytes(password);
MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
buffer = md5.ComputeHash(buffer);
for (int i = 0; i < buffer.Length; i++)
{
passMD5 = passMD5 + buffer[i].ToString("x2");
}
if (error == false)
{
tbl_Admin admin = new tbl_Admin
{
emailAdmin = email,
password = passMD5,
fullname = fullname,
phoneNumber = phone,
bankNumber = bank
};
db.tbl_Admin.Add(admin);
db.SaveChanges();
return(View("Login"));
}
else
{
return(View());
}
}
// GET: Admin/Details/5
public ActionResult Details(int?id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_Admin tbl_Admin = db.tbl_Admin.Find(id);
if (tbl_Admin == null)
{
return(HttpNotFound());
}
return(View(tbl_Admin));
}
//
public ActionResult GetRequestByUser()
{
tbl_Admin admin = (tbl_Admin)Session["Admin"];
string email = admin.emailAdmin;
List <tbl_Customer> listCustomer = db.tbl_Customer.Where(n => n.emailAdmin == email).OrderByDescending(n => n.date).ToList();
List <GetRequestByUserModel> listResult = new List <GetRequestByUserModel>();
foreach (var item in listCustomer)
{
GetRequestByUserModel model = new GetRequestByUserModel();
model.customer = item;
model.house = db.tbl_House.SingleOrDefault(n => n.houseID == item.houseID);
listResult.Add(model);
}
return(View(listResult));
}
