public ActionResult Upload(HttpPostedFileBase jsonFile)
{
{
using (OnlinePharmacyEntities db = new OnlinePharmacyEntities())
{
if (!jsonFile.FileName.EndsWith(".json"))
{
ViewBag.Error = "Invalid file type(Only JSON file allowed)";
}
else
{
jsonFile.SaveAs(Server.MapPath("~/FileUpload/" + Path.GetFileName(jsonFile.FileName)));
StreamReader streamReader = new StreamReader(Server.MapPath("~/FileUpload/" + Path.GetFileName(jsonFile.FileName)));
string data = streamReader.ReadToEnd();
List <Prescription> Prescription = JsonConvert.DeserializeObject <List <Prescription> >(data);
Prescription.ForEach(p =>
{
Prescription prescription = new Prescription()
{
Prescription_Date = p.Prescription_Date,
PrescriptionLines = p.PrescriptionLines,
};
db.Prescriptions.Add(prescription);
db.SaveChanges();
});
ViewBag.Success = "File uploaded Successfully..";
}
}
return(View());
}
}
public bool IslogedIn(OnlinePharmacyEntities db, string userGUID)
{
db.Configuration.ProxyCreationEnabled = false;
user = db.Users.Where(usr => usr.GUID == userGUID && usr.GUIDExpiry > DateTime.Now).FirstOrDefault();
if (user != null)
{
return(true);
}
return(false);
}
public bool IslogedIn(OnlinePharmacyEntities db)
{
db.Configuration.ProxyCreationEnabled = false;
var guids = db.Users.Where(usr => usr.GUID == user.GUID && usr.GUIDExpiry > DateTime.Now).Count();
if (guids > 0)
{
return(true);
}
return(false);
}
public void RefreshGUID(OnlinePharmacyEntities db)
{
db.Configuration.ProxyCreationEnabled = false;
user.GUID = Guid.NewGuid().ToString();
user.GUIDExpiry = DateTime.Now.AddMinutes(30);
int guids = db.Users.Where(usr => usr.GUID == user.GUID).Count();
if (guids > 0)
{
RefreshGUID(db);
}
else
{
var u = db.Users.Where(zz => zz.UserID == user.UserID).FirstOrDefault();
db.Entry(u).CurrentValues.SetValues(user);
db.SaveChanges();
}
}
