public ActionResult Create([Bind(Include = "allergyID,allergyName,active,cb,cd,mb,md")] Allergy allergy)
{
if (ModelState.IsValid)
{
db.Allergies.Add(allergy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(allergy));
}
public ActionResult Delete(int id)
{
if (Session["LogedUserID"] != null)
{
try
{
db.sp_DeleteAlerts(id, Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(RedirectToAction("Index"));
}
}
else
{
return(RedirectToAction("../Login/Index"));
}
}
public ActionResult ApproveReview(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
try
{
var id = Request.Form["id"].ToString();
db.sp_ApproveConsultation(Convert.ToInt64(id), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
return(RedirectToAction("ReviewsApproval"));
}
catch (Exception ex)
{
return(RedirectToAction("ReviewsApproval"));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public ActionResult Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
var systemitem = "";
var systemitemid = "";
var systemid = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
systemitem = Request.Form["systemitem"].ToString();
systemid = Request.Form["sltSystem"].ToString();
var item = (
from p in db.SystemItemsses
where (p.systemItemName == systemitem && p.active == true)
select p
).FirstOrDefault();
if (item != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "System Item already exists";
}
if (item == null)
{
db.SP_AddSystemItem(systemitem, Convert.ToInt64(systemid), Session["LogedUserID"].ToString());
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
}
if (action == "edit")
{
systemitemid = Request.Form["id"].ToString();
systemitem = Request.Form["systemitem"].ToString();
systemid = Request.Form["sltSystem"].ToString();
//var item = (
// from p in db.SystemItemss
// where (p.systemItemName == systemitem && p.active == true)
// select p
// ).FirstOrDefault();
//if (item != null)
//{
// ViewBag.successMessage = "";
// ViewBag.errorMessage = "System Item already exists";
//}
//if (item == null)
//{
db.sp_UpdateSystemItem(Convert.ToInt64(systemitemid), Convert.ToInt64(systemid), systemitem, Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
// }
}
if (action == "delete")
{
systemitemid = Request.Form["id"].ToString();
db.sp_DeleteSystemItem(Convert.ToInt64(systemitemid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existingitemList = db.SP_SelectSystemItems();
var systems = db.PatientSystems
.Where(a => a.active == true).ToList();
ViewBag.Systems = systems;
ViewBag.systemid = systemid;
return(View(__existingitemList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existingitemList = db.SP_SelectSystemItems();
var systems = db.PatientSystems.ToList();
ViewBag.Systems = systems;
return(View(_existingitemList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public ActionResult Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
var languagename = "";
var languageid = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
languagename = Request.Form["languagename"].ToString();
var language = (
from p in db.Languages
where (p.languageName == languagename && p.active == true)
select p
).FirstOrDefault();
if (language != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Language already exists";
}
if (language == null)
{
db.SP_AddLanguage(languagename, Session["LogedUserID"].ToString());
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
}
if (action == "edit")
{
languageid = Request.Form["id"].ToString();
languagename = Request.Form["languagename"].ToString();
//var language = (
// from p in db.Languages
// where (p.languageName == languagename && p.active == true)
// select p
// ).FirstOrDefault();
//if (language != null)
//{
// ViewBag.successMessage = "";
// ViewBag.errorMessage = "Language already exists";
//}
//if (language == null)
//{
db.sp_UpdateLanguages(Convert.ToInt64(languageid), languagename, Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
//}
}
if (action == "delete")
{
languageid = Request.Form["id"].ToString();
db.sp_DeleteLanguage(Convert.ToInt64(languageid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existinglangList = db.SP_SelectLanguages();
return(View(__existinglangList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existinglangList = db.SP_SelectLanguages();
return(View(_existinglangList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public ActionResult Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
var zipcode = "";
var zipcodeid = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
zipcode = Request.Form["zipname"].ToString();
var zip = (
from p in db.Zips
where (p.zipName == zipcode && p.active == true)
select p
).FirstOrDefault();
if (zip != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "ZipCode already exists";
}
if (zip == null)
{
db.SP_AddZipCode(zipcode, Session["LogedUserID"].ToString());
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
}
if (action == "edit")
{
zipcodeid = Request.Form["id"].ToString();
zipcode = Request.Form["zipname"].ToString();
//var zip = (
// from p in db.ZipCode
// where (p.zipName == zipcode && p.active == true)
// select p
// ).FirstOrDefault();
//if (zip != null)
//{
// ViewBag.successMessage = "";
// ViewBag.errorMessage = "ZipCode already exists";
// //var _existingallergyList = db.SP_SelectAllergy();
// //return View(_existingallergyList);
//}
//if (zip == null)
//{
db.sp_UpdateZipCode(Convert.ToInt64(zipcodeid), zipcode, Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
//}
}
if (action == "delete")
{
zipcodeid = Request.Form["id"].ToString();
db.sp_DeleteZipCode(Convert.ToInt64(zipcodeid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existingzipList = db.SP_SelectZipCode();
return(View(__existingzipList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existingzipList = db.SP_SelectZipCode();
return(View(_existingzipList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public async System.Threading.Tasks.Task <ActionResult> Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
var rolename = "";
var desc = "";
var roleid = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
rolename = Request.Form["rolename"].ToString();
desc = Request.Form["desc"].ToString();
var role = new RoleManager <IdentityRole>(
new RoleStore <IdentityRole>(new ApplicationDbContext()));
if (!(role.RoleExists(rolename)))
{
var rm = new RoleManager <ApplicationRole>(
new RoleStore <ApplicationRole>(new ApplicationDbContext()));
var idResult = rm.Create(new ApplicationRole(rolename));
if (idResult.Succeeded)
{
AspNetRole thisRole = db.AspNetRoles.Where(r => r.Name.Equals(rolename, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
thisRole.Description = desc;
db.Entry(thisRole).State = EntityState.Modified;
db.SaveChanges();
}
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.errorMessage = "Role already exists.";
ViewBag.successMessage = "";
}
}
if (action == "edit")
{
//roleid = Request.Form["id"].ToString();
rolename = Request.Form["rolename"].ToString();
desc = Request.Form["desc"].ToString();
AspNetRole thisRole = db.AspNetRoles.Where(r => r.Name.Equals(rolename, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
thisRole.Description = desc;
thisRole.Name = rolename;
db.Entry(thisRole).State = EntityState.Modified;
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
var _existingroleList = db.AspNetRoles.ToList();
return(View(_existingroleList));
}
if (action == "delete")
{
roleid = Request.Form["id"].ToString();
AspNetRole thisRole = db.AspNetRoles.Where(r => r.Id.Equals(roleid, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
db.AspNetRoles.Remove(thisRole);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existingroleList = db.SP_SelectRole();
return(View(__existingroleList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existingroleList = db.SP_SelectRole();
return(View(_existingroleList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public HttpResponseMessage PostDoctorTiming(DoctorTimingsModel doctorTimingModel)
{
if (doctorTimingModel.from.Contains("PM"))
{
if (doctorTimingModel.to.Contains("AM"))
{
//return BadRequest("Timings should be within single day.");
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "Timings should be within single day."
});
response.ReasonPhrase = "Timings should be within single day.";
return(response);
}
}
if (doctorTimingModel.from == doctorTimingModel.to)
{
//return BadRequest("From Time and To Time can not be same.");
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "From Time and To Time can not be same."
});
response.ReasonPhrase = "From Time and To Time can not be same.";
return(response);
}
if (DateTime.ParseExact(doctorTimingModel.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay <
DateTime.ParseExact(doctorTimingModel.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay)
{
//return BadRequest("From Time can not be greater than To Time.");
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "From Time can not be greater than To Time."
});
response.ReasonPhrase = "From Time can not be greater than To Time.";
return(response);
}
TimeSpan diff = DateTime.ParseExact(doctorTimingModel.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay -
DateTime.ParseExact(doctorTimingModel.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
if (diff.TotalMinutes < 15)
{
//return BadRequest("Timespan less than 15 minutes is not allowed.");
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "Timespan less than 15 minutes is not allowed."
});
response.ReasonPhrase = "Timespan less than 15 minutes is not allowed.";
return(response);
}
var doctorTiming = new DoctorTiming();
var timingsList = GetDoctorTimingByDoctorId(doctorTimingModel.doctorID);
var timezoneid = db.Doctors.Where(d => d.doctorID == doctorTimingModel.doctorID).Select(d => d.timezone).FirstOrDefault();
TimeZoneInfo zoneInfo = TimeZoneInfo.FindSystemTimeZoneById(timezoneid.ToString());
foreach (var y in timingsList)
{
DateTime?from = DateTime.UtcNow.Date;
from = from + DateTime.ParseExact(y.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
from = TimeZoneInfo.ConvertTimeFromUtc(from.Value, zoneInfo);
y.from = from.Value.ToString("hh:mm tt", CultureInfo.InvariantCulture);
DateTime?to = DateTime.UtcNow.Date;
to = to + DateTime.ParseExact(y.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay;
to = TimeZoneInfo.ConvertTimeFromUtc(to.Value, zoneInfo);
y.to = to.Value.ToString("hh:mm tt", CultureInfo.InvariantCulture);
}
DateTime fromtimeUTC = DateTime.ParseExact(doctorTimingModel.from,
"hh:mm tt", CultureInfo.InvariantCulture);
//fromtimeUTC = TimeZoneInfo.ConvertTimeToUtc(fromtimeUTC,zoneInfo);
DateTime totimeUTC = DateTime.ParseExact(doctorTimingModel.to,
"hh:mm tt", CultureInfo.InvariantCulture);
//totimeUTC = TimeZoneInfo.ConvertTimeToUtc(totimeUTC, zoneInfo);
var alreadItems = timingsList
.Where(o => o.day == doctorTimingModel.day &&
(o.from == fromtimeUTC.ToString("hh:mm tt") || o.to == totimeUTC.ToString("hh:mm tt")
||
(
fromtimeUTC.TimeOfDay >=
DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
&&
fromtimeUTC.TimeOfDay <
DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
)
||
(
totimeUTC.TimeOfDay >
DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
&&
totimeUTC.TimeOfDay <=
DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
)
||
(
fromtimeUTC.TimeOfDay <=
DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
&&
totimeUTC.TimeOfDay >=
DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
)
||
(
fromtimeUTC <
DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture)
&&
totimeUTC >=
DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture)
)
)).ToList();
//var alreadItems = timingsList
// .Where(o => o.day == doctorTimingModel.day &&
// (o.from == doctorTimingModel.from || o.to == doctorTimingModel.to
// ||
// (
// DateTime.ParseExact(doctorTimingModel.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay >=
// DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// &&
// DateTime.ParseExact(doctorTimingModel.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay <=
// DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// )
// ||
// (
// DateTime.ParseExact(doctorTimingModel.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay >=
// DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// &&
// DateTime.ParseExact(doctorTimingModel.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay <=
// DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// )
// ||
// (
// DateTime.ParseExact(doctorTimingModel.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay <=
// DateTime.ParseExact(o.from, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// &&
// DateTime.ParseExact(doctorTimingModel.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay >=
// DateTime.ParseExact(o.to, "hh:mm tt", CultureInfo.InvariantCulture).TimeOfDay
// )
// )).ToList();
var chkpmtoam = alreadItems.Where(x => x.from.Contains("PM") && x.to.Contains("AM")).FirstOrDefault();
//var otherthanpmtoam = alreadItems.Where(x => !(x.from.Contains("PM")) && !(x.to.Contains("AM"))).FirstOrDefault();
var flag = 0;
foreach (var t in alreadItems)
{
if (t.from.Contains("AM") && t.to.Contains("AM") ||
t.from.Contains("PM") && t.to.Contains("PM") ||
t.from.Contains("AM") && t.to.Contains("PM"))
{
flag = 1;
break;
}
}
if (alreadItems.Count > 0)
{
if (flag == 1)
{
//return BadRequest("Timings can not be overlapped across each other.");
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "Timings can not be overlapped across each other."
});
response.ReasonPhrase = "Timings can not be overlapped across each other.";
return(response);
}
//return CreatedAtRoute("DefaultApi", new { message = "Timings can not be overlapped across each other" }, doctorTiming);
}
if (!ModelState.IsValid)
{
//return BadRequest(ModelState);
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = "Model is not valid."
});
response.ReasonPhrase = "Model is not valid.";
return(response);
}
try
{
doctorTiming.doctorID = doctorTimingModel.doctorID;
doctorTiming.doctorTimingsID = 0;
doctorTiming.day = doctorTimingModel.day;
string nextDay = "";
if (doctorTimingModel.day.ToString().ToLower().Equals("monday"))
{
nextDay = "Tuesday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("tuesday"))
{
nextDay = "Wednesday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("wednesday"))
{
nextDay = "Thursday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("thursday"))
{
nextDay = "Friday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("friday"))
{
nextDay = "Saturday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("saturday"))
{
nextDay = "Sunday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("Sunday"))
{
nextDay = "Monday";
}
string prevDay = "";
if (doctorTimingModel.day.ToString().ToLower().Equals("monday"))
{
prevDay = "Sunday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("tuesday"))
{
prevDay = "Monday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("wednesday"))
{
prevDay = "tuesday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("thursday"))
{
prevDay = "Wednesday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("friday"))
{
prevDay = "Thursday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("saturday"))
{
prevDay = "Friday";
}
else if (doctorTimingModel.day.ToString().ToLower().Equals("Sunday"))
{
prevDay = "Saturday";
}
DateTime dateTimeFrom = DateTime.ParseExact(doctorTimingModel.from,
"hh:mm tt", CultureInfo.InvariantCulture);
DateTime dateTimeTo = DateTime.ParseExact(doctorTimingModel.to,
"hh:mm tt", CultureInfo.InvariantCulture);
//For DayLightTimeSaving Issue at mobile devices
TimeSpan ts = new TimeSpan(0, 0, 60, 0);
bool isDaylight = zoneInfo.IsDaylightSavingTime(dateTimeFrom);
/* if (isDaylight)
* {
* doctorTiming.from = TimeZoneInfo.ConvertTimeToUtc(dateTimeFrom, zoneInfo).Add(ts).TimeOfDay;
* doctorTiming.to = TimeZoneInfo.ConvertTimeToUtc(dateTimeTo, zoneInfo).Add(ts).TimeOfDay;
* }
* else
* {
* doctorTiming.from = TimeZoneInfo.ConvertTimeToUtc(dateTimeFrom, zoneInfo).TimeOfDay;
* doctorTiming.to = TimeZoneInfo.ConvertTimeToUtc(dateTimeTo, zoneInfo).TimeOfDay;
* }*/
DateTime from = TimeZoneInfo.ConvertTimeToUtc(dateTimeFrom, zoneInfo);
DateTime to = TimeZoneInfo.ConvertTimeToUtc(dateTimeTo, zoneInfo);
doctorTiming.from = from.TimeOfDay;
doctorTiming.to = to.TimeOfDay;
if (from.Date > dateTimeFrom.Date)
{
doctorTiming.utcDay = nextDay;
}
else if (from.Date < dateTimeFrom.Date)
{
doctorTiming.utcDay = prevDay;
}
else
{
doctorTiming.utcDay = doctorTimingModel.day;
}
doctorTiming.active = true;
doctorTiming.cd = DateTime.Now;
doctorTiming.md = DateTime.Now;
doctorTiming.cb = doctorTimingModel.username;
db.DoctorTimings.Add(doctorTiming);
db.SaveChanges();
}
catch (Exception ex)
{
//return BadRequest(ex.Message);
response = Request.CreateResponse(HttpStatusCode.BadRequest, new ApiResultModel {
ID = 0, message = ex.Message
});
response.ReasonPhrase = ex.Message;
return(response);
}
//return CreatedAtRoute("DefaultApi", new { id = doctorTiming.doctorTimingsID }, doctorTiming);
response = Request.CreateResponse(HttpStatusCode.OK, new { id = doctorTiming.doctorTimingsID, doctorTiming });
return(response);
}
public async System.Threading.Tasks.Task <ActionResult> Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
var id = "";
var userid = "";
var firstName = "";
var lastName = "";
var email = "";
var password = "";
bool isAllValid = true;
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
firstName = Request.Form["firstName"].ToString();
lastName = Request.Form["lastName"].ToString();
email = Request.Form["email"].ToString();
password = Request.Form["password"].ToString();
if (!Regex.IsMatch(firstName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid First Name";
var _existingdList = db.SP_SelectDoctor();
return(View(_existingdList));
}
if (!Regex.IsMatch(lastName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Last Name";
var _existingdList = db.SP_SelectDoctor();
return(View(_existingdList));
}
Utility util = new Utility();
if (!(util.IsValid(email)))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Email Address";
var _existingdList = db.SP_SelectDoctor();
return(View(_existingdList));
}
//db.SP_AddDoctor(firstName, lastName, email, password, Session["LogedUserID"].ToString());
//db.SaveChanges();
var user = new ApplicationUser
{
UserName = email,
Email = email,
FirstName = firstName,
LastName = lastName,
};
var result = await UserManager.CreateAsync(user, password);
if (result.Succeeded)
{
var doctor = new DataAccess.Doctor();
doctor.userId = user.Id;
doctor.lastName = user.LastName;
doctor.firstName = user.FirstName;
doctor.email = user.Email;
doctor.cb = Session["LogedUserID"].ToString();
doctor.active = true;
doctor.status = false;
db.Doctors.Add(doctor);
db.SaveChanges();
var userAssignRole = new UserAssignRoleModel();
userAssignRole.UserId = user.Id;//"8466ba63-b903-4d0a-8633-ce399ed1b542";//
userAssignRole.Role = "Doctor";
var strContent = JsonConvert.SerializeObject(userAssignRole);
var response = ApiConsumerHelper.PostData("api/Roles/AssignRole", strContent);
dynamic resultAdd = JsonConvert.DeserializeObject(response);
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.successMessage = "";
foreach (var error in result.Errors)
{
ViewBag.errorMessage = error;
}
var _existingdList = db.SP_SelectDoctor();
return(View(_existingdList));
}
}
if (action == "edit")
{
id = Request.Form["id"].ToString();
userid = Request.Form["userid"].ToString();
password = Request.Form["password"].ToString();
string token = await UserManager.GeneratePasswordResetTokenAsync(userid);
//var firstName = Request.Form["firstName"].ToString();
//var lastName = Request.Form["lastName"].ToString();
//var email = Request.Form["email"].ToString();
//db.sp_ResetDoctorPassword(Convert.ToInt64(id), password, Session["LogedUserID"].ToString(), System.DateTime.Now);
//db.SaveChanges();
var result = await UserManager.ResetPasswordAsync(userid, token, password);
if (result.Succeeded)
{
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.successMessage = "";
foreach (var error in result.Errors)
{
ViewBag.errorMessage = error;
}
var _existingdList = db.SP_SelectDoctor();
return(View(_existingdList));
}
}
if (action == "delete")
{
id = Request.Form["id"].ToString();
userid = Request.Form["userid"].ToString();
Doctor doc = db.Doctors.Where(a => a.userId == userid).FirstOrDefault();
if (doc != null)
{
doc.active = false;
doc.mb = Session["LogedUserID"].ToString();
doc.md = DateTime.Now;
db.Entry(doc).State = EntityState.Modified;
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Doctor not found.";
}
}
var _existingdoctorsList = db.SP_SelectDoctor();
return(View(_existingdoctorsList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
return(View());
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public ActionResult Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
var specialityid = "";
var doctorid = "";
var docspecialityid = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
specialityid = Request.Form["sltspeciality"].ToString();
doctorid = Request.Form["sltdoctor"].ToString();
db.SP_AddDoctorSpeciality(Convert.ToInt64(doctorid), Convert.ToInt64(specialityid), Session["LogedUserID"].ToString());
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
if (action == "edit")
{
docspecialityid = Request.Form["id"].ToString();
specialityid = Request.Form["sltspeciality"].ToString();
doctorid = Request.Form["sltdoctor"].ToString();
db.sp_UpdateDoctorSpeciality(Convert.ToInt64(docspecialityid), Convert.ToInt64(doctorid), Convert.ToInt64(specialityid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
//}
}
if (action == "delete")
{
docspecialityid = Request.Form["id"].ToString();
db.sp_DeleteDoctorSpeciality(Convert.ToInt64(docspecialityid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existingdocspeList = db.SP_SelectDoctorSpeciality();
var doctors = db.Doctors
.Where(a => a.active == true).ToList();
ViewBag.Doctors = doctors;
var speciality = db.Speciallities
.Where(a => a.active == true).ToList();
ViewBag.Speciality = speciality;
return(View(__existingdocspeList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var __existingdocspeList = db.SP_SelectDoctorSpeciality();
var doctors = db.Doctors
.Where(a => a.active == true).ToList();
ViewBag.Doctors = doctors;
var speciality = db.Speciallities
.Where(a => a.active == true).ToList();
ViewBag.Speciality = speciality;
return(View(__existingdocspeList));
}
}
else
{
return(RedirectToAction("../Login/Index"));
}
}
public HttpResponseMessage GetPatientDoseSpotUrl(long patientId)
{
try
{
//Search if patient contains doseSpot Id
var oPatientInfo = db.Patients.FirstOrDefault(x => x.patientID == patientId);
int?DoseSpotPatientId = null;
if (oPatientInfo != null)
{
var oDoseSpotPatientEntry = new DoseSpotPatientEntry
{
PatientId = DoseSpotPatientId,
FirstName = oPatientInfo.firstName,
LastName = oPatientInfo.lastName,
MiddleName = "",
Address1 = oPatientInfo.address1,
Address2 = oPatientInfo.address2,
City = oPatientInfo.city,
State = oPatientInfo.state,
ZipCode = oPatientInfo.zip,
Gender = oPatientInfo.gender,
Phone = oPatientInfo.cellPhone,
DateOfBirth = oPatientInfo.dob.Value,
PharmacyId = oPatientInfo.pharmacyid
};
if (string.IsNullOrEmpty(oPatientInfo.DoseSpotPatientId))
{
var oRet = DoseSpotHelper.RegisterPatientWithDoseSpot(oDoseSpotPatientEntry);
int DoseSpotPatId;
int.TryParse(oRet, out DoseSpotPatId);
if (DoseSpotPatId != 0)
{
oPatientInfo.DoseSpotPatientId = oRet;
db.Entry(oPatientInfo).State = EntityState.Modified;
db.SaveChanges();
}
oDoseSpotPatientEntry.PatientId = DoseSpotPatId;
}
else
{
oDoseSpotPatientEntry.PatientId = Convert.ToInt32(oPatientInfo.DoseSpotPatientId);
}
//Register Patient
var cFinalUrl = DoseSpotHelper.GetEPrescriptionUrl(oDoseSpotPatientEntry);
return(Request.CreateResponse(HttpStatusCode.OK, cFinalUrl));
}
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "This patient does not exists"));
}
catch (Exception ex)
{
//return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex);
return(ThrowError(ex, "GetPatientDoseSpotUrl in DoseSpotController"));
}
}
public ActionResult Create(FormCollection collection)
{
var rovname = "";
long rovid;
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
rovname = Request.Form["rovname"].ToString();
var obj_rov = (
from p in db.ROVs
where (p.name == rovname && p.active == true)
select p
).FirstOrDefault();
if (obj_rov != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Reason of Visit already exists";
}
if (obj_rov == null)
{
ROV dbrov = new ROV();
dbrov.name = rovname;
dbrov.cd = DateTime.Now;
dbrov.cb = SessionHandler.UserId;
dbrov.active = true;
db.ROVs.Add(dbrov);
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
}
if (action == "edit")
{
rovid = Convert.ToInt32(Request.Form["id"].ToString());
rovname = Request.Form["rovname"].ToString();
ROV dbrov = new ROV();
dbrov = db.ROVs.Where(r => r.rovID == rovid).FirstOrDefault();
dbrov.name = rovname;
dbrov.md = DateTime.Now;
dbrov.mb = SessionHandler.UserId;
db.Entry(dbrov).State = EntityState.Modified;
db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
if (action == "delete")
{
rovid = Convert.ToInt32(Request.Form["id"].ToString());
ROV dbrov = new ROV();
dbrov = db.ROVs.Where(r => r.rovID == rovid).FirstOrDefault();
dbrov.active = false;
db.Entry(dbrov).State = EntityState.Modified;
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var rov = db.ROVs.Where(r => r.active == true).ToList();
return(View(rov));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _rov = db.ROVs.Where(r => r.active == true).ToList();
return(View(_rov));
}
}
public ActionResult Create(FormCollection collection)
{
var newsid = "";
var newstitle = "";
var newsdetail = "";
byte[] thumbBytes = null;
byte[] detailBytes = null;
string thumbBase64 = "";
string detailBase64 = "";
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
if (Session["LogedUserID"] != null)
{
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
HttpPostedFileBase thumbnail = Request.Files["thumbnailimage"];
HttpPostedFileBase detailimage = Request.Files["detailimage"];
newstitle = Request.Form["newstitle"].ToString();
newsdetail = Request.Form["newsdetail"].ToString();
thumbBytes = util.ConvertToBytes(thumbnail);
detailBytes = util.ConvertToBytes(detailimage);
thumbBase64 = "data:image/png;base64," + Convert.ToBase64String(thumbBytes);
detailBase64 = "data:image/png;base64," + Convert.ToBase64String(detailBytes);
var news = (
from p in db.News
where (p.newsTitle == newstitle || p.newsDetail == newsdetail && p.active == true)
select p
).FirstOrDefault();
if (news != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "News already exists";
}
if (news == null)
{
News newsObj = new News();
newsObj.active = true;
newsObj.newsTitle = newstitle;
newsObj.newsDetail = newsdetail;
newsObj.newsThumbnailBase64 = thumbBase64;
newsObj.newsImageBase64 = detailBase64;
newsObj.cb = Session["LogedUserID"].ToString();
newsObj.cd = System.DateTime.UtcNow;
db.News.Add(newsObj);
db.SaveChanges();
//db.SP_AddNewss(newstitle, newsdetail, thumbBytes, detailBytes,Session["LogedUserID"].ToString());
//db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
}
if (action == "edit")
{
//HttpPostedFileBase thumbnail = Request.Files["tthumbnailimage"];
// HttpPostedFileBase detailimage = Request.Files["ddetailimage"];
if (Request.Files.Count == 2)
{
thumbBytes = util.ConvertToBytes(Request.Files[0]);
detailBytes = util.ConvertToBytes(Request.Files[1]);
thumbBase64 = "data:image/png;base64," + Convert.ToBase64String(thumbBytes);
detailBase64 = "data:image/png;base64," + Convert.ToBase64String(detailBytes);
}
newsid = Request.Form["newsid"].ToString();
newstitle = Request.Form["newstitle"].ToString();
newsdetail = Request.Form["newsdetail"].ToString();
long nid = Convert.ToInt64(newsid);
News newsObj = new News();
newsObj = db.News.Where(n => n.newsID == nid && n.active == true).FirstOrDefault();
if (newsObj != null)
{
newsObj.active = true;
newsObj.newsTitle = newstitle;
newsObj.newsDetail = newsdetail;
newsObj.newsThumbnailBase64 = thumbBase64;
newsObj.newsImageBase64 = detailBase64;
newsObj.mb = Session["LogedUserID"].ToString();
newsObj.md = System.DateTime.UtcNow;
db.Entry(newsObj).State = EntityState.Modified;
db.SaveChanges();
}
//db.sp_UpdateNews(Convert.ToInt64(newsid), newstitle, newsdetail, thumbBytes, detailBytes, Session["LogedUserID"].ToString(), System.DateTime.Now);
//db.SaveChanges();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
if (action == "delete")
{
newsid = Request.Form["newsid"].ToString();
db.sp_DeleteNews(Convert.ToInt64(newsid), Session["LogedUserID"].ToString(), System.DateTime.Now);
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
var __existingnewsList = db.SP_SelectNewss();
return(View(__existingnewsList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existingnewsList = db.SP_SelectNewss();
return(View(_existingnewsList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}
public async System.Threading.Tasks.Task <ActionResult> Create(FormCollection collection)
{
if (Session["LogedUserID"] != null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "";
var id = "";
var firstName = "";
var lastName = "";
var email = "";
var password = "";
var roleID = "";
try
{
var action = Request.Form["action"].ToString();
if (action == "create")
{
firstName = Request.Form["firstname"].ToString();
lastName = Request.Form["lastname"].ToString();
email = Request.Form["email"].ToString();
password = Request.Form["password"].ToString();
//roleID = Request.Form["sltRole"].ToString();
var roles = db.AspNetRoles.ToList();
//if (roleID == "")
//{
// ViewBag.successMessage = "";
// ViewBag.errorMessage = "Select valid Role";
// var _existingadminList = db.SP_SelectAdmin();
// //var roles = db.Roles
// // .Where(a => a.active == true).ToList();
// ViewBag.Roles = roles;
// return View(_existingadminList);
//}
if (!Regex.IsMatch(firstName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid First Name";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = roles;
return(View(_existingadminList));
}
if (!Regex.IsMatch(lastName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Last Name";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = roles;
return(View(_existingadminList));
}
Utility util = new Utility();
if (!(util.IsValid(email)))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Email Address";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = roles;
return(View(_existingadminList));
}
var checkemail = (
from p in db.AdminUsers
where (p.email == email && p.active == true)
select p
).FirstOrDefault();
if (checkemail == null)
{
var user = new ApplicationUser
{
UserName = email,
Email = email,
FirstName = firstName,
LastName = lastName,
};
var result = await UserManager.CreateAsync(user, password);
if (result.Succeeded)
{
db.SP_AddAdmin(firstName, lastName, email, user.Id, Session["LogedUserID"].ToString());
db.SaveChanges();
var userAssignRole = new UserAssignRoleModel();
userAssignRole.UserId = user.Id;//"8466ba63-b903-4d0a-8633-ce399ed1b542";//
userAssignRole.Role = "Admin";
var strContent = JsonConvert.SerializeObject(userAssignRole);
var response = ApiConsumerHelper.PostData("api/Roles/AssignRole", strContent);
dynamic resultAdd = JsonConvert.DeserializeObject(response);
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.successMessage = "";
foreach (var error in result.Errors)
{
ViewBag.errorMessage = error;
}
var _existingadminList = db.SP_SelectAdmin();
return(View(_existingadminList));
}
}
else
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "User with this Email Address already exists";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = roles;
return(View(_existingadminList));
}
}
if (action == "edit")
{
id = Request.Form["id"].ToString();
firstName = Request.Form["firstName"].ToString();
lastName = Request.Form["lastName"].ToString();
email = Request.Form["email"].ToString();
password = Request.Form["password"].ToString();
//roleID = Request.Form["sltRole"].ToString();
var rroles = db.AspNetRoles.ToList();
//if (roleID == "")
//{
// ViewBag.successMessage = "";
// ViewBag.errorMessage = "Select valid Role";
// var _existingadminList = db.SP_SelectAdmin();
// //var roles = db.Roles
// // .Where(a => a.active == true).ToList();
// ViewBag.Roles = rroles;
// return View(_existingadminList);
//}
if (!Regex.IsMatch(firstName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid First Name";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
// .Where(a => a.active == true).ToList();
ViewBag.Roles = rroles;
return(View(_existingadminList));
}
if (!Regex.IsMatch(lastName, @"^[a-zA-Z\s]+$"))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Last Name";
var _existingadminList = db.SP_SelectAdmin();
// var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = rroles;
return(View(_existingadminList));
}
Utility util = new Utility();
if (!(util.IsValid(email)))
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Provide valid Email Address";
var _existingadminList = db.SP_SelectAdmin();
// var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = rroles;
return(View(_existingadminList));
}
var checkemail = (
from p in db.AspNetUsers
where (p.Email == email && p.Id != id)
select p
).FirstOrDefault();
if (checkemail == null)
{
string token = await UserManager.GeneratePasswordResetTokenAsync(id);
var result = await UserManager.ResetPasswordAsync(id, token, password);
if (result.Succeeded)
{
AdminUser adminUser = db.AdminUsers.Where(a => a.userId == id).FirstOrDefault();
if (adminUser != null)
{
//Update AdminUsers table
adminUser.lastName = lastName;
adminUser.FirstName = firstName;
adminUser.email = email;
adminUser.mb = Session["LogedUserID"].ToString();
adminUser.md = DateTime.Now;
db.AdminUsers.Add(adminUser);
db.Entry(adminUser).State = EntityState.Modified;
}
//Update AspNetUsers table
AspNetUser aspnetUser = await db.AspNetUsers.FindAsync(id);
if (aspnetUser == null)
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Admin user not found.";
return(View());
}
aspnetUser.LastName = lastName;
aspnetUser.FirstName = firstName;
aspnetUser.Email = email;
db.AspNetUsers.Add(aspnetUser);
db.Entry(aspnetUser).State = EntityState.Modified;
await db.SaveChangesAsync();
ViewBag.successMessage = "Record has been saved successfully";
ViewBag.errorMessage = "";
}
else
{
ViewBag.successMessage = "";
foreach (var error in result.Errors)
{
ViewBag.errorMessage = error;
}
var _existingadminList = db.SP_SelectAdmin();
return(View(_existingadminList));
}
}
else
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "User with this Email Address already exists";
var _existingadminList = db.SP_SelectAdmin();
//var roles = db.Roles
//.Where(a => a.active == true).ToList();
ViewBag.Roles = rroles;
return(View(_existingadminList));
}
}
if (action == "delete")
{
id = Request.Form["id"].ToString();
var userid = Request.Form["userid"].ToString();
AdminUser adminUser = db.AdminUsers.Where(a => a.userId == userid).FirstOrDefault();
if (adminUser != null)
{
//Update AdminUsers table
adminUser.active = false;
adminUser.mb = Session["LogedUserID"].ToString();
adminUser.md = DateTime.Now;
db.Entry(adminUser).State = EntityState.Modified;
db.SaveChanges();
ViewBag.successMessage = "Record has been deleted successfully";
ViewBag.errorMessage = "";
}
//db.sp_DeleteAdmin(Convert.ToInt64(id), Session["LogedUserID"].ToString(), System.DateTime.Now);
//AspNetUser admin = db.AspNetUsers.Find(userid);
//db.AspNetUsers.Remove(admin);
//db.AspNetUsers.Remove(admin);
//db.SaveChanges();
else
{
ViewBag.successMessage = "";
ViewBag.errorMessage = "Admin user not found.";
}
}
//Send Email//
//Send Email//
var __existingadminList = db.SP_SelectAdmin();
// var _roles = db.Roles
//.Where(a => a.active == true).ToList();
var _roles = db.AspNetRoles.ToList();
ViewBag.Roles = _roles;
return(View(__existingadminList));
}
catch (Exception ex)
{
ViewBag.errorMessage = "Error occurred while processing your request.";
var _existingadminList = db.SP_SelectAdmin();
var roles = db.AspNetRoles.ToList();
ViewBag.Roles = roles;
return(View(_existingadminList));
}
}
else
{
return(RedirectToAction("AdminLogin", "Account"));
}
}