public ActionResult Product()
{
using (Database1Entities1 db = new Database1Entities1())
{
return(View(db.Products.ToList()));
}
}
public bool IsLoginNameExist(string loginName)
{
using (Database1Entities1 db = new Database1Entities1())
{
return(db.SYSUsers.Where(o => o.LoginName.Equals(loginName)).Any());
}
}
public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (Database1Entities1 dc = new Database1Entities1())
{
var user = dc.RegisterUsers.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.Password = model.NewPassword;
user.ResetPasswordCode = "";
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "New password updated successfully";
}
}
}
else
{
message = "Something invalid";
}
ViewBag.Message = message;
return(View(model));
}
public ActionResult AllClient()
{
Database1Entities1 db = new Database1Entities1();
List <Client> clientList = db.Clients.ToList();
return(View(clientList));
}
public ActionResult ForgotPassword(string EmailID)
{
string message = "";
using (Database1Entities1 dc = new Database1Entities1())
{
var account = dc.RegisterUsers.Where(a => a.Email == EmailID).FirstOrDefault();
var accountCustomer = dc.RegisterCustomers.Where(a => a.Email == EmailID).FirstOrDefault();
if (account != null)
{
//Send email for reset password
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "Reset password link has been sent to your email id.";
}
else
{
ViewBag.message1 = "Account not found";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult AppointmentList()
{
using (Database1Entities1 db = new Database1Entities1())
{
return(View(db.Apointments.ToList()));
}
}
// [ValidateAntiForgeryToken]
public ActionResult Login(Trainer_Details model)
{
if (ModelState.IsValid)
{
Database1Entities1 db = new Database1Entities1();
var user = (from Mem_Tab in db.Mem_Tab
where Mem_Tab.Email == model.TEmail && Mem_Tab.PWD == model.TPWD
select new
{
model.TEmail,
model.TName
}).ToList();
if (user.FirstOrDefault() != null)
{
Session["Email"] = user.FirstOrDefault().TEmail;
Session["Name"] = user.FirstOrDefault().TName;
//return View("Create", "Resumes");
}
else
{
ModelState.AddModelError("", "Invalid login credentials.");
}
}
return(RedirectToAction("Create", "Resumes"));
}
public ActionResult OrderUpdateX(OrderMix model, string status)
{
using (var db = new Database1Entities1())
{
var p = db.OrderMixes.Find(model.OrderMixId);
var q = db.Items.Find(p.ItemId);
if (p.Status != status)
{
if (status == "未出荷")
{
q.Stock = q.Stock + p.Quantity;
db.SaveChanges();
p.Status = status;
db.SaveChanges();
}
else if (status == "出荷済")
{
if (q.Stock >= p.Quantity)
{
q.Stock = q.Stock - p.Quantity;
db.SaveChanges();
p.Status = status;
db.SaveChanges();
}
else if (q.Stock < p.Quantity)
{
ViewBag.message = "在庫数量が不足しています。";
return(View("OrderUpdateInput", Session["Update"]));
}
}
}
return(View("OrderUpdate", p));
}
}
public ActionResult Login(User model, string returnUrl)
{
Database1Entities1 db = new Database1Entities1();
var dataItem = db.User.Where(x => x.Username == model.Username && x.Password == model.Password).First();
if (dataItem != null)
{
FormsAuthentication.SetAuthCookie(dataItem.Username, false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
if (dataItem.Role == "Administrator")
{
return(RedirectToAction("Index"));
}
else if (dataItem.Role == "Redaktor")
{
return(RedirectToAction("RedaktorSite"));
}
else
{
return(RedirectToAction("SekretarzSite"));
}
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
// [ValidateAntiForgeryToken]
public ActionResult Login(Comapny_Registration model)
{
if (ModelState.IsValid)
{
Database1Entities1 db = new Database1Entities1();
var user = (from CRD in db.Comapny_Registration
where CRD.Email == model.Email && CRD.Password == model.Password
select new
{
model.Email,
model.Name
}).ToList();
if (user.FirstOrDefault() != null)
{
Session["Email"] = user.FirstOrDefault().Email;
Session["Name"] = user.FirstOrDefault().Name;
//return View("Create", "Resumes");
}
else
{
ModelState.AddModelError("", "Invalid login credentials.");
}
}
return(RedirectToAction("Create", "Company_Details"));
}
public JsonResult SaveEvent(Event e)
{
var status = false;
using (Database1Entities1 dc = new Database1Entities1())
{
if (e.Id > 0)
{
//Update the event
var v = dc.Events.Where(a => a.Id == e.Id).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult CsLoginIndex(CsLoginModel model, int customerid)
{
using (var db = new Database1Entities1())
{
var ul = db.Customers.Find(int.Parse(model.CustomerId));
if (int.Parse(model.CustomerId) == ul.CustomerId && model.Password == ul.Password)
{
var CsSession = new Customer()
{
CustomerId = customerid
};
Session["cslogin"] = CsSession;
FormsAuthentication.SetAuthCookie(userName: model.CustomerId, createPersistentCookie: false);
// ユーザー認証 成功
return(this.Redirect("/Login/CsMainMenu"));
}
else
{
// ユーザー認証 失敗
ModelState.AddModelError(string.Empty, "入力された顧客IDまたはパスワードが誤っています");
return(View(model));
}
}
}
public House getHouses(int?Id)
{
Database1Entities1 dc = new Database1Entities1();
var acc = dc.Houses.Where(s => s.PropId == Id).FirstOrDefault();
return(acc);
}
// GET: Employee
public ActionResult EmpList()
{
using (var db = new Database1Entities1())
{
var EmployeeList = db.Employees.ToList();
return(View(EmployeeList));
}
}
// GET: Stock
public ActionResult StockList()
{
using (var db = new Database1Entities1())
{
var StockList = db.Items.ToList();
return(View(StockList));
}
}
// GET: Item
public ActionResult ItemCatalog()
{
using (var db = new Database1Entities1())
{
var ul = db.Items.ToList();
return(View("ItemCatalog", ul));
}
}
public ActionResult EditProfile(RegisterUser Registers)
{
Database1Entities1 dc = new Database1Entities1();
dc.Entry(Registers).State = EntityState.Modified;
dc.SaveChanges();
return(RedirectToAction("UserData", "User"));
}
//見積商品の数量・希望納期の変更
public ActionResult CartUpdate(Cart cart)
{
using (var db = new Database1Entities1())
{
db.SaveChanges();
return(Redirect("CartCalc"));
}
}
public bool IsEmailExist(string emailID)
{
using (Database1Entities1 dc = new Database1Entities1())
{
var v = dc.Users.Where(a => a.EmailID == emailID).FirstOrDefault();
return(v != null);
}
}
public ActionResult BookedList()
{
string Emailid = User.Identity.Name;
Database1Entities1 dc = new Database1Entities1();
var acc = dc.Bookings.Where(s => s.SellEmail == Emailid && s.Book == "Accepted");
return(View(acc));
}
public ActionResult Edit(RegisterUser Registers)
{
Database1Entities1 dc = new Database1Entities1();
dc.Entry(Registers).State = EntityState.Modified;
dc.SaveChanges();
return(RedirectToAction("Admin", "House"));
}
public override string[] GetRolesForUser(string username)
{
Database1Entities1 db = new Database1Entities1();
string data = db.User.Where(x => x.Username == username).FirstOrDefault().Role;
string[] result = { data };
return(result);
}
public ActionResult UserBooking()
{
Database1Entities1 dc = new Database1Entities1();
string Emailid = User.Identity.Name;
var acc = dc.Bookings.Where(s => s.CustEmail == Emailid).OrderByDescending(s => s.Book);
return(View(acc));
}
public JsonResult searchStudentFunction(string term)
{
Database1Entities1 db = new Database1Entities1();
List <Student> d = db.Students
.Where(s => s.Name.StartsWith(term)).ToList();
return(Json(d, JsonRequestBehavior.AllowGet));
}
public ActionResult CsList()
{
using (var db = new Database1Entities1())
{
var CustomerList = db.Customers.ToList();
return(View(CustomerList));
}
}
public ActionResult curr()
{
int I = Convert.ToInt32(Session["UserID"]);
var ctx = new Database1Entities1();
var l = ctx.Projects.Where(u => u.MD_ID == I && u.Status == 0).ToList <Project>();
return(View(l.ToList()));
}
public ActionResult listD()
{
int I = Convert.ToInt32(Session["UserID"]);
var ctx = new Database1Entities1();
var l = ctx.Teams.Where(u => u.MTL_id == I && u.IsApproved == 0).ToList <Team>();
return(View(l.ToList()));
}
public ActionResult CreateTeam()
{
var ctx = new Database1Entities1();
ViewBag.user_id = new SelectList(db.Users.Where(s => s.user_type == 4), "ID", "FirstName");
ViewBag.user_mk = new SelectList(ctx.Users.Where(q => q.user_type == 2), "ID", "FirstName");
ViewBag.proj_id = new SelectList(ctx.Projects.Where(o => o.Status == 0), "ID", "Title");
return(View());
}
public ActionResult OrderUpdateInput(OrderMix om)
{
using (var db = new Database1Entities1())
{
var p = db.OrderMixes.Find(om.OrderMixId);
Session["Update"] = p;
return(View(Session["Update"]));
}
}
public RegisterUser getRegisterUser(int?Id)
{
Database1Entities1 dc = new Database1Entities1();
var acc = dc.Houses.Where(s => s.PropId == Id).FirstOrDefault();
var SellerEmail = acc.Email;
var sellerdetails = dc.RegisterUsers.Where(s => s.Email == SellerEmail).FirstOrDefault();
return(sellerdetails);
}
public ActionResult Login(User u)
{
// this action is for handle post (login)
if (ModelState.IsValid) // this is check validity
{
using (Database1Entities1 dc = new Database1Entities1())
{
var v = dc.Table.FirstOrDefault(a => a.UserName.Equals(u.UserName) && a.Password.Equals(u.Password));
if (v != null)
{
Session["LogedUserID"] = v.UserID.ToString();
Session["LogedUserFullname"] = v.FullName.ToString();
return RedirectToAction("AfterLogin");
}
}
}
return View(u);
}
public RequestLogger()
{
objContext = new Database1Entities1();
}
