public ActionResult MedicalRegister(MedicalAccount aMedicalAccount) { string verifying = null; if (ModelState.IsValid) { if (aMedicalAccount.MedicalContactNo2 == null) { aMedicalAccount.MedicalContactNo2 = ""; } if (aMedicalAccount.AmbulanceContact == null) { aMedicalAccount.AmbulanceContact = ""; } aMedicalAccount.Role = "Medical"; aMedicalAccount.Password = Crypto.Hash(aMedicalAccount.Password); aMedicalAccount.ActivationCode = Guid.NewGuid(); aMedicalAccount.IsEmailVerified = true; aMedicalAccount.Status = "Active"; aMedicalAccount.AccountCreatedDate = DateTime.Now.ToLongDateString(); verifying = aMedicalManager.Save(aMedicalAccount); } if (verifying == "Success") { //SendEmailVerificationLink(aMedicalAccount.MedicalEmail, aMedicalAccount.ActivationCode.ToString()); ViewBag.Message = "Account request successfully completed. An activation link has been sent to your email. Please check your email to verified the account"; ViewBag.Status = true; } else { ViewBag.Message = verifying; ViewBag.Status = false; } return(View()); }
public List <MedicalAccount> GetAllMedicals() { Query = "SELECT * FROM MedicalAccounts ORDER BY Status DESC"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <MedicalAccount> medicalAccounts = new List <MedicalAccount>(); while (Reader.Read()) { MedicalAccount medicalAccount = new MedicalAccount(); medicalAccount.MedicalId = Convert.ToInt32(Reader["MedicalId"]); medicalAccount.MedicalType = Reader["MedicalType"].ToString(); medicalAccount.MedicalName = Reader["MedicalName"].ToString(); medicalAccount.ContactPersonName = Reader["ContactPersonName"].ToString(); medicalAccount.ContactPersonPhoneNo = Reader["ContactPersonPhoneNo"].ToString(); medicalAccount.MedicalEmail = Reader["MedicalEmail"].ToString(); medicalAccount.Address = Reader["Address"].ToString(); medicalAccount.City = Reader["City"].ToString(); medicalAccount.Status = Reader["Status"].ToString(); medicalAccount.AccountCreatedDate = Reader["AccountCreatedDate"].ToString(); DateTime newDate = Convert.ToDateTime(medicalAccount.AccountCreatedDate); medicalAccount.AccountCreatedDate = newDate.ToString("dd/MM/yyyy"); medicalAccounts.Add(medicalAccount); } Reader.Close(); Connection.Close(); return(medicalAccounts); }
public int Save(MedicalAccount aMedicalAccount) { Query = "INSERT INTO MedicalAccounts VALUES(@role, @medicalType, @medicalName, @contactPersonName, @contactPersonPosition, @contactPersonPhoneNo, @medicalEmail, @medicalContactNo1, @medicalContactNo2, @address, @area, @city, @ambulanceService, @ambulanceContact, @password, @isEmailVerified, @activationCode, @status, @accountCreatedDate)"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("role", aMedicalAccount.Role); Command.Parameters.AddWithValue("medicalType", aMedicalAccount.MedicalType); Command.Parameters.AddWithValue("medicalName", aMedicalAccount.MedicalName); Command.Parameters.AddWithValue("contactPersonName", aMedicalAccount.ContactPersonName); Command.Parameters.AddWithValue("contactPersonPosition", aMedicalAccount.ContactPersonPosition); Command.Parameters.AddWithValue("contactPersonPhoneNo", aMedicalAccount.ContactPersonPhoneNo); Command.Parameters.AddWithValue("medicalEmail", aMedicalAccount.MedicalEmail); Command.Parameters.AddWithValue("medicalContactNo1", aMedicalAccount.MedicalContactNo1); Command.Parameters.AddWithValue("medicalContactNo2", aMedicalAccount.MedicalContactNo2); Command.Parameters.AddWithValue("address", aMedicalAccount.Address); Command.Parameters.AddWithValue("area", aMedicalAccount.Area); Command.Parameters.AddWithValue("city", aMedicalAccount.City); Command.Parameters.AddWithValue("ambulanceService", aMedicalAccount.AmbulanceService); Command.Parameters.AddWithValue("ambulanceContact", aMedicalAccount.AmbulanceContact); Command.Parameters.AddWithValue("password", aMedicalAccount.Password); Command.Parameters.AddWithValue("isEmailVerified", aMedicalAccount.IsEmailVerified); Command.Parameters.AddWithValue("activationCode", aMedicalAccount.ActivationCode); Command.Parameters.AddWithValue("status", aMedicalAccount.Status); Command.Parameters.AddWithValue("accountCreatedDate", aMedicalAccount.AccountCreatedDate); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public MedicalAccount GetMedicalSearchViewInfo(int medicalId) { Query = "SELECT * FROM MedicalAccounts WHERE MedicalId = @medicalId"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("medicalId", medicalId); Command.Connection.Open(); Reader = Command.ExecuteReader(); MedicalAccount aMedicalAccount = null; if (Reader.HasRows) { Reader.Read(); aMedicalAccount = new MedicalAccount(); aMedicalAccount.MedicalId = Convert.ToInt32(Reader["MedicalId"]); aMedicalAccount.MedicalType = Reader["MedicalType"].ToString(); aMedicalAccount.MedicalName = Reader["MedicalName"].ToString(); aMedicalAccount.ContactPersonName = Reader["ContactPersonName"].ToString(); aMedicalAccount.ContactPersonPosition = Reader["ContactPersonPosition"].ToString(); aMedicalAccount.ContactPersonPhoneNo = Reader["ContactPersonPhoneNo"].ToString(); aMedicalAccount.MedicalEmail = Reader["MedicalEmail"].ToString(); aMedicalAccount.MedicalContactNo1 = Reader["MedicalContact1"].ToString(); aMedicalAccount.MedicalContactNo2 = Reader["MedicalContact2"].ToString(); aMedicalAccount.Address = Reader["Address"].ToString(); aMedicalAccount.Area = Reader["Area"].ToString(); aMedicalAccount.City = Reader["City"].ToString(); aMedicalAccount.AmbulanceService = Reader["AmbulanceService"].ToString(); aMedicalAccount.AmbulanceContact = Reader["AmbulanceContact"].ToString(); } Reader.Close(); Command.Connection.Close(); return(aMedicalAccount); }
public string Save(MedicalAccount aMedicalAccount) { if (aMedicalGateway.IsEmailExists(aMedicalAccount.MedicalEmail) == false) { if (aMedicalGateway.IsMobileNoExists(aMedicalAccount.MedicalContactNo1) == false) { int rowAffected = aMedicalGateway.Save(aMedicalAccount); if (rowAffected > 0) { return("Success"); } else { return("Medical registration is not successful!"); } } else { return("Medical contact number is already used. Try another!"); } } else { return("The email is already exists. Please, Try to give another Email."); } }
public ActionResult MedicalProfile() { if (User.IsInRole("Medical")) { MedicalAccount aMedicalAccount = aMedicalManager.GetMedicalData(MedicalUsername); ViewBag.GetMedical = aMedicalAccount; } ViewBag.GetName = GetMedicalData().MedicalName; return(View()); }
// private MedicalAccount GetMedicalData() { MedicalAccount aMedicalAccount = new MedicalAccount(); if (User.IsInRole("Medical")) { aMedicalAccount = aMedicalManager.GetMedicalData(MedicalUsername); } return(aMedicalAccount); }
public MedicalAccount GetMedicalSearchViewInfo(int medicalId) { MedicalAccount aMedicalAccount = aHomeGateway.GetMedicalSearchViewInfo(medicalId); aMedicalAccount.ViewDoctors = aMedicalGateway.GetAllDoctors(medicalId); aMedicalAccount.HospitalSerives = aMedicalGateway.GetHospitalServices(medicalId); aMedicalAccount.DiagnosticServices = aMedicalGateway.GetDiagnosticServices(medicalId); aMedicalAccount.OtherServices = aMedicalGateway.GetOtherServices(medicalId); aMedicalAccount.MedicalFacilities = aMedicalGateway.GetMedicalFacilities(medicalId); aMedicalAccount.Consultants = aMedicalGateway.GetMedicalConsultants(medicalId); aMedicalAccount.MedicalService = aMedicalGateway.GetEmergencyDetails(medicalId); return(aMedicalAccount); }
public string UpdateMedicalProfile(MedicalAccount aMedicalAccount) { int rowAffected = aMedicalGateway.UpdateMedicalProfile(aMedicalAccount); if (rowAffected > 0) { return("Medical profile updated successfully."); } else { return("Medical profile updating failed."); } }
public List <MedicalAccount> GetMedicalSearchResult(SearchModel aSearchModel, string keyword) { List <MedicalAccount> medicalAccounts = new List <MedicalAccount>(); if (keyword == "Medical") { Query = "SELECT * FROM MedicalAccounts WHERE Address LIKE '%'+@address+'%' OR Area LIKE '%'+@area+'%' OR City LIKE '%'+@city+'%' AND Role = 'Medical'"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("address", aSearchModel.Location); Command.Parameters.AddWithValue("area", aSearchModel.Location); Command.Parameters.AddWithValue("city", aSearchModel.Location); Command.Parameters.AddWithValue("searchKeyword", keyword); } else { Query = "SELECT * FROM MedicalAccounts WHERE (Address LIKE '%'+@address+'%' OR Area LIKE '%'+@area+'%' OR City LIKE '%'+@city+'%') AND (MedicalName LIKE '%' + @searchKeyword2 + '%' OR MedicalType LIKE '%'+@searchKeyword3+'%')"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("address", aSearchModel.Location); Command.Parameters.AddWithValue("area", aSearchModel.Location); Command.Parameters.AddWithValue("city", aSearchModel.Location); Command.Parameters.AddWithValue("searchKeyword2", aSearchModel.SearchString); Command.Parameters.AddWithValue("searchKeyword3", aSearchModel.SearchString); } Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { MedicalAccount aMedicalAccount = new MedicalAccount(); aMedicalAccount.MedicalId = Convert.ToInt32(Reader["MedicalId"]); aMedicalAccount.MedicalName = Reader["MedicalName"].ToString(); aMedicalAccount.MedicalEmail = Reader["MedicalEmail"].ToString(); aMedicalAccount.MedicalContactNo1 = Reader["MedicalContact1"].ToString(); aMedicalAccount.MedicalContactNo2 = Reader["MedicalContact2"].ToString(); aMedicalAccount.Address = Reader["Address"].ToString(); aMedicalAccount.Area = Reader["Area"].ToString(); aMedicalAccount.City = Reader["City"].ToString(); aMedicalAccount.AmbulanceService = Reader["AmbulanceService"].ToString(); aMedicalAccount.AmbulanceContact = Reader["AmbulanceContact"].ToString(); medicalAccounts.Add(aMedicalAccount); } Reader.Close(); Connection.Close(); return(medicalAccounts); }
public ActionResult MedicalProfile(MedicalAccount aMedicalAccount) { if (aMedicalAccount.MedicalContactNo2 == null) { aMedicalAccount.MedicalContactNo2 = ""; } if (aMedicalAccount.AmbulanceContact == null) { aMedicalAccount.AmbulanceContact = ""; } if (User.IsInRole("Medical")) { ViewBag.Message = aMedicalManager.UpdateMedicalProfile(aMedicalAccount); aMedicalAccount = aMedicalManager.GetMedicalData(MedicalUsername); ViewBag.GetMedical = aMedicalAccount; } ViewBag.GetName = GetMedicalData().MedicalName; return(View()); }
public MedicalAccount IsMedicalLoginVerified(string aLoginEmail) { Query = "SELECT IsEmailVerified, Status FROM MedicalAccounts WHERE MedicalEmail = @aLoginEmail"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("aLoginEmail", aLoginEmail); Connection.Open(); Reader = Command.ExecuteReader(); MedicalAccount medicalAccount = null; while (Reader.Read()) { medicalAccount = new MedicalAccount(); medicalAccount.IsEmailVerified = Convert.ToBoolean(Reader["IsEmailVerified"]); medicalAccount.Status = Reader["Status"].ToString(); } Reader.Close(); Connection.Close(); return(medicalAccount); }
public string GetMedicalRole(string username) { Query = "SELECT Role FROM MedicalAccounts WHERE MedicalEmail = @username"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("username", username); Connection.Open(); Reader = Command.ExecuteReader(); MedicalAccount aMedicalAccount = null; string role = ""; if (Reader.Read()) { aMedicalAccount = new MedicalAccount(); aMedicalAccount.Role = Reader["Role"].ToString(); role = aMedicalAccount.Role; } Reader.Close(); Connection.Close(); return(role); }
public int UpdateMedicalProfile(MedicalAccount aMedicalAccount) { Query = "UPDATE MedicalAccounts SET MedicalType = @medicalType, MedicalName = @medicalName, ContactPersonName = @contactPersonName, ContactPersonPosition = @contactPersonPosition, ContactPersonPhoneNo = @contactPersonPhoneNo, MedicalContact1 = @medicalContactNo1, MedicalContact2 = @medicalContactNo2, Address = @address, Area = @area, City = @city, AmbulanceService = @ambulanceService, AmbulanceContact= @ambulanceContact WHERE MedicalEmail = @medicalEmail"; Command = new SqlCommand(Query, Connection); Command.Parameters.AddWithValue("medicalType", aMedicalAccount.MedicalType); Command.Parameters.AddWithValue("medicalName", aMedicalAccount.MedicalName); Command.Parameters.AddWithValue("contactPersonName", aMedicalAccount.ContactPersonName); Command.Parameters.AddWithValue("contactPersonPosition", aMedicalAccount.ContactPersonPosition); Command.Parameters.AddWithValue("contactPersonPhoneNo", aMedicalAccount.ContactPersonPhoneNo); Command.Parameters.AddWithValue("medicalContactNo1", aMedicalAccount.MedicalContactNo1); Command.Parameters.AddWithValue("medicalContactNo2", aMedicalAccount.MedicalContactNo2); Command.Parameters.AddWithValue("address", aMedicalAccount.Address); Command.Parameters.AddWithValue("area", aMedicalAccount.Area); Command.Parameters.AddWithValue("city", aMedicalAccount.City); Command.Parameters.AddWithValue("ambulanceService", aMedicalAccount.AmbulanceService); Command.Parameters.AddWithValue("ambulanceContact", aMedicalAccount.AmbulanceContact); Command.Parameters.AddWithValue("medicalEmail", aMedicalAccount.MedicalEmail); Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult AjaxMethod(string City) { KeystoneProject.Buisness_Logic.PharmacyMaster.BL_MedicalAccount BL_obj = new BL_MedicalAccount(); KeystoneProject.Models.PharmacyMaster.MedicalAccount obj = new MedicalAccount(); List <string> searchList = new List <string>(); DataTable td = new DataTable(); DataSet ds = M_account.GetCity(City, "%"); td = M_account.GetCountryStateID(Convert.ToInt16(ds.Tables[0].Rows[0]["CityID"].ToString())); obj.state = td.Rows[0]["StateName"].ToString(); obj.country = td.Rows[0]["CountryName"].ToString(); obj.StateID = td.Rows[0]["StateID"].ToString(); obj.CountryID = td.Rows[0]["CountryID"].ToString(); searchList.Add(obj.state); searchList.Add(obj.country); searchList.Add(obj.StateID); searchList.Add(obj.CountryID); return(Json(searchList)); }
public ActionResult MedicalAccount(MedicalAccount obj, FormCollection fc) { try { BL_MedicalAccount med_save = new BL_MedicalAccount(); if (med_save.CheckAccounts(obj.AccountID, obj.AccountName)) { if (med_save.Save(obj)) { if (obj.AccountID > 0) { ModelState.Clear(); TempData["Msg"] = " Medical Account Updated Successfully"; return(RedirectToAction("MedicalAccount", "MedicalAccount")); } else { ModelState.Clear(); TempData["Msg"] = " Medical Account Saved Successfully"; return(RedirectToAction("MedicalAccount", "MedicalAccount")); } } } else { ViewData["flag"] = "Error"; TempData["Msg"] = "Medical Accounts Already Exist "; //TempData["msg"] = "Accounts Not Save"; } return(RedirectToAction("MedicalAccount", "MedicalAccount")); } catch (Exception) { return(RedirectToAction("MedicalAccount", "MedicalAccount")); } }
public bool Save(MedicalAccount obj) { try { Connect(); SqlCommand cmd = new SqlCommand("IUMedicalAccounts", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationId); if (obj.AccountID == 0) { cmd.Parameters.AddWithValue("@AccountsID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@AccountsID", obj.AccountID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@AccountName", obj.AccountName); cmd.Parameters.AddWithValue("@ReferenceCode", 0); cmd.Parameters.AddWithValue("@ScheduleID", obj.ScheduleID); cmd.Parameters.AddWithValue("@OPBalance", obj.OBType); if (obj.OBType == "Credit") { cmd.Parameters.AddWithValue("@CrAmount", obj.OPBalance); } else { cmd.Parameters.AddWithValue("@CrAmount", 0.00); } if (obj.OBType == "Debit") { cmd.Parameters.AddWithValue("@DrAmount", obj.OPBalance); } else { cmd.Parameters.AddWithValue("@DrAmount", 0.00); } cmd.Parameters.AddWithValue("@CrLimit", obj.CrLimit); cmd.Parameters.AddWithValue("@PrintName", obj.PrintName); cmd.Parameters.AddWithValue("@CreditDays", obj.CreditDays); cmd.Parameters.AddWithValue("@AccountType", obj.AccountType); cmd.Parameters.AddWithValue("@Address", obj.Address); cmd.Parameters.AddWithValue("@CityID", obj.CityID); cmd.Parameters.AddWithValue("@PinCode", obj.PinCode); cmd.Parameters.AddWithValue("@StateID", obj.StateID); cmd.Parameters.AddWithValue("@CountryID", obj.CountryID); cmd.Parameters.AddWithValue("@PhoneNo", obj.PhoneNo); cmd.Parameters.AddWithValue("@MobileNo", obj.MobileNo); cmd.Parameters.AddWithValue("@EmailID", obj.EmailID); cmd.Parameters.AddWithValue("@Remark", obj.Remark); cmd.Parameters.AddWithValue("@FAX", obj.FAX); cmd.Parameters.AddWithValue("@TinNo", obj.TinNo); cmd.Parameters.AddWithValue("@Pan", obj.Pan); cmd.Parameters.AddWithValue("@TinDate", obj.TinDate); cmd.Parameters.AddWithValue("@CSTNO", obj.CSTNO); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(RedirectToAction("Error", new { message = ex.Message })); } }
public ActionResult Login(Login aLogin, string returnUrl = "") { if (ModelState.IsValid) { aLogin.Password = Crypto.Hash(aLogin.Password); //Check User Login if (aUserManager.IsValid(aLogin.LoginId, aLogin.Password)) { int timeout = aLogin.RememberMe ? 525600 : 60; // 525600 min = 1year var ticket = new FormsAuthenticationTicket(aLogin.LoginId, aLogin.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); if (Url.IsLocalUrl(returnUrl)) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index", "User")); } } //Check Doctor Login else if (aDoctorManager.IsValid(aLogin.LoginId, aLogin.Password)) { Doctors doctor = aDoctorManager.IsLoginVerified(aLogin.LoginId); if (doctor.PasswordVerified) { if (doctor.Status == "Active") { int timeout = aLogin.RememberMe ? 525600 : 60; // 525600 min = 1year var ticket = new FormsAuthenticationTicket(aLogin.LoginId, aLogin.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); if (Url.IsLocalUrl(returnUrl)) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index", "Doctor")); } } else { ViewBag.AccountWarningMessage = "Your account has been suspended. Please contact us to activate your account."; } } else { TempData["WarningMessage"] = "Please change your temporary password"; ChangePassword aChangePassword = new ChangePassword(); aChangePassword.DoctorLoginId = aLogin.LoginId; aChangePassword.OldPassword = aLogin.Password; Session["UserLoginId"] = aChangePassword; return(RedirectToAction("ChangeTemporaryPassword", "Register")); } } //Check Medical Login else if (aMedicalManager.IsValid(aLogin.LoginId, aLogin.Password)) { MedicalAccount medicalAccount = aMedicalManager.IsMedicalLoginVerified(aLogin.LoginId); if (medicalAccount.IsEmailVerified) { if (medicalAccount.Status == "Active") { int timeout = aLogin.RememberMe ? 525600 : 60; // 525600 min = 1year var ticket = new FormsAuthenticationTicket(aLogin.LoginId, aLogin.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); if (Url.IsLocalUrl(returnUrl)) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index", "Medical")); } } else if (medicalAccount.Status == "Pending") { ViewBag.AccountWarningMessage = "This account request is pending. Please contact us if you want to activate."; } else { ViewBag.AccountWarningMessage = "This account has been suspended. Please contact us to activate the account."; } } else { ViewBag.ErrorMessage = "Your email has not verified yet. Please check your email and verified your account"; } } else { ViewBag.ErrorMessage = "Your Email or Password is incorrect!"; } } return(View()); }