public JsonResult SaveEvent(Event_Schedule e)
{
var status = false;
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
if (e.EventID > 0)
{
//Update the event
var v = dc.Event_Schedule.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.EventEnd = e.EventEnd;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColour = e.ThemeColour;
}
}
else //Add Event
{
dc.Event_Schedule.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult save(Vet_Appointment_Master vetApp)
{
bool status = false;
DateTime dateOrg;
var isValidDate = DateTime.TryParseExact(vetApp.VetDateString, "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrg);
if (isValidDate)
{
vetApp.Appointment_Date = dateOrg;
}
var isValidModel = TryUpdateModel(vetApp);
if (isValidModel)
{
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
dc.Vet_Appointment_Master.Add(vetApp);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public JsonResult GetEvents()
{
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
var events = dc.Event_Schedule.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult getSickType(int Animal_Type_ID)
{
List <VetAppReason> reason = new List <VetAppReason>();
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
reason = dc.VetAppReasons.Where(a => a.Animal_Type_ID.Equals(Animal_Type_ID)).OrderBy(a => a.Reason).ToList();
}
return(new JsonResult {
Data = reason, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult getAnimals()
{
List <Animal> animals = new List <Animal>();
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
animals = dc.Animals.OrderBy(a => a.Animal_Name).ToList();
}
return(new JsonResult {
Data = animals, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult ResetPassword(string EmailID)
{
//Verify Email ID
//Generate Reset password link
//Send Email
string message = "";
//bool status = false;
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
//adding a employee
//Employee emp = new Employee();
//emp.Emp_Name = "jem";
//emp.Emp_Email = "*****@*****.**";
//dc.Employees.Add(emp);
//dc.SaveChanges();
//User_ useremp = new User_();
//useremp.Emp_ID = 1;
//useremp.Username = "******";
//useremp.Password = "******";
//dc.User_.Add(useremp);
//dc.SaveChanges();
var account = dc.Employees.Where(a => a.Emp_Email == EmailID).FirstOrDefault();
if (account != null)
{
var user = dc.User_.Where(a => a.Emp_ID == account.Emp_ID).FirstOrDefault();
if (user != null)
{
//Send email for reset password
string resetCode = Membership.GeneratePassword(12, 1);
SendVerificationLinkEmail(account.Emp_Email, resetCode, "ResetPassword");
user.Password = resetCode;
//This line I have added here to avoid confirm password not match issue , as we had added a confirm password property
//in our model class in part 1
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "Reset password link has been sent to your email id.";
}
else
{
message = "Account not found";
}
}
else
{
message = "Account not found";
}
}
ViewBag.Message = message;
return(View());
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (Wollies_ShelterEntities dc = new Wollies_ShelterEntities())
{
var v = dc.Event_Schedule.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
dc.Event_Schedule.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
// GET: VetAppointReport
public ActionResult Index()
{
Wollies_ShelterEntities db = new Wollies_ShelterEntities();
List <Veterinarian> VetDetails = db.Veterinarians.ToList();
List <Animal> AnimalDetails = db.Animals.ToList();
List <Vet_Appointment_Master> VetAppointLineDetails = db.Vet_Appointment_Master.ToList();
var combinedTable = from a in AnimalDetails
join v in VetAppointLineDetails on a.Animal_ID equals v.Animal_ID into table1
from v in table1.DefaultIfEmpty()
join s in VetDetails on v.Vet_ID equals s.Vet_ID into table2
from s in table2.DefaultIfEmpty()
select new VetAppointReport {
AnimalList = a, AppointList = v, VetList = s
};
return(View(combinedTable));
}
public ActionResult Login(User_ login)
{
bool status = false;
Wollies_ShelterEntities db = new Wollies_ShelterEntities();
//check username and password form our database here
//for demo I am going to use Admin as Username and Password1 as Password static value
List <User_> Users;
try
{
//User_ user = new User_();
//user.Username = "******";
//user.Password = "******";
//db.User_.Add(user);
//db.SaveChanges();
Users = db.User_.ToList();
}
catch (Exception e)
{
throw;
}
foreach (var item in Users)
{
if (item.Username == login.Username && item.Password == login.Password)
{
status = true; // show 2FA form
Session["Username"] = login.Username;
//2FA Setup
TwoFactorAuthenticator tfa = new TwoFactorAuthenticator();
string UserUniqueKey = (login.Username + key);
Session["UserUniqueKey"] = UserUniqueKey;
var setupInfo = tfa.GenerateSetupCode("Wollies Shelter", login.Username, UserUniqueKey, 300, 300);
ViewBag.BarcodeImageUrl = setupInfo.QrCodeSetupImageUrl;
ViewBag.SetupCode = setupInfo.ManualEntryKey;
//message = "Credentials are correct";
return(View("Authorize", setupInfo));
}
}
return(View());
}
public ActionResult Login(User_ login)
{
//bool status = false;
Wollies_ShelterEntities db = new Wollies_ShelterEntities();
List <User_> Users;
try
{
Users = db.User_.ToList();
}
catch (Exception e)
{
ViewBag.err = e.Message;
throw;
}
foreach (var item in Users)
{
if (item.Username == login.Username && item.Password == login.Password)
{
Session["Username"] = login.Username;
flex.currentuser = item;
//2FA Setup
TwoFactorAuthenticator tfa = new TwoFactorAuthenticator();
string UserUniqueKey = (login.Username + key);
Session["UserUniqueKey"] = UserUniqueKey;
//var setupInfo = tfa.GenerateSetupCode("Wollies Shelter", login.Username, UserUniqueKey, 300, 300);
//ViewBag.BarcodeImageUrl = setupInfo.QrCodeSetupImageUrl;
//ViewBag.SetupCode = setupInfo.ManualEntryKey;
//message = "Credentials are correct";
return(View("Authorize", flex));
}
}
return(View());
}
