public static string GetUserOffice(int UserID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var office = mbprosEntities.Users.SingleOrDefault(u => u.UserId == UserID);
return(office == null ? "" : office.OfficeName);
}
public static log4net.ILog logger = log4net.LogManager.GetLogger(typeof(CommonFunctions)); //Declaring Log4Net
public static IEnumerable GetAllDropdownList(string tableName)
{
MbprosEntities mbprosEntities = new MbprosEntities();
switch (tableName)
{
case "STATES":
var states = (from d in mbprosEntities.States
select new { ID = d.StateCode, NAME = d.StateName }).OrderBy(d => d.NAME).ToList();
//if (states.Count > 0)
//{
// states.Insert(0, new { ID = "", NAME = "" });
//}
return((IEnumerable)states);
case "ArchiveOptions":
List <Options> options = new List <Options>();
options.Add(new Options()
{
ID = 0, Name = "All"
});
options.Add(new Options()
{
ID = 1, Name = "Archive"
});
options.Add(new Options()
{
ID = 2, Name = "Un-Archive"
});
return(options);
}
return(Enumerable.Empty <string>());
}
public List <User> GetUserSearch(UserModels userModel)
{
MbprosEntities mbprosEntities = new MbprosEntities();
if (userModel == null)
{
userModel = new UserModels();
}
userModel.UserList = mbprosEntities.Users.Where(o => o.Status == true).OrderByDescending(s => s.UserId).ToList();
if (!string.IsNullOrEmpty(userModel.UserName))
{
userModel.UserList = userModel.UserList.Where(x => x.UserName.ToLower().Contains(userModel.UserName.Trim().ToLower())).ToList();
}
if (!string.IsNullOrEmpty(userModel.OfficeName))
{
userModel.UserList = userModel.UserList.Where(x => x.OfficeName.ToLower().Contains(userModel.OfficeName.Trim().ToLower())).ToList();
}
if (!string.IsNullOrEmpty(userModel.EmailID))
{
userModel.UserList = userModel.UserList.Where(x => x.EmailID.ToLower().Contains(userModel.EmailID.Trim().ToLower())).ToList();
}
return(userModel.UserList);
}
public static string GetUserEmailID(int UserID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var userEmail = mbprosEntities.Users.SingleOrDefault(u => u.UserId == UserID);
return(userEmail == null ? "" : userEmail.EmailID);
}
public static User GetAdminUserDetails()
{
MbprosEntities mbprosEntities = new MbprosEntities();
var adminUsers = mbprosEntities.Users.Where(u => u.IsAdmin == true).OrderBy(u => u.UserId).ToList();
if (adminUsers.Count > 0)
{
return(adminUsers[0]);
}
return(new User());
}
public static List <string> UserMenuAccess(int userid)
{
MbprosEntities en = new MbprosEntities();
var lstFeatures = (from u in en.Feature_User
join m in en.FeatureMasters on u.FeatureID equals m.FeatureID
where u.UserID == userid && u.CanView == true
select m.FeatureName).ToList();
return(lstFeatures);
}
private bool IsUserExist(string userName)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var user = mbprosEntities.Users.Where(model => model.UserName == userName).ToList();
if (user.Count > 0)
{
return(true);
}
return(false);
}
public static int GetNextPatientBillingID()
{
MbprosEntities mbprosEntities = new MbprosEntities();
int nextPatientID = 1;
var patientBilling = mbprosEntities.PatientBillings.OrderByDescending(u => u.PatientBillingID).FirstOrDefault();
if (patientBilling != null)
{
nextPatientID = patientBilling.PatientBillingID + 1;
}
return(nextPatientID);
}
//Other Functions
public JsonResult DeleteBillingRecord(int patientBillingID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var patientBillings = mbprosEntities.PatientBillings.Where(aa => aa.PatientBillingID == patientBillingID).ToList();
foreach (var patBill in patientBillings)
{
mbprosEntities.PatientBillings.Remove(patBill);
mbprosEntities.SaveChanges();
}
TempData["EditMessage"] = "Y";
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult ArchiveBillingRecord(int patientBillingID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var patientBillings = mbprosEntities.PatientBillings.Where(aa => aa.PatientBillingID == patientBillingID).ToList();
foreach (var patBill in patientBillings)
{
patBill.IsArchived = true;
mbprosEntities.Entry(patBill).State = System.Data.Entity.EntityState.Modified;
mbprosEntities.SaveChanges();
}
TempData["EditMessage"] = "Y";
return(Json("", JsonRequestBehavior.AllowGet));
}
public JsonResult UnarchivePatientRecord(int patientID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var patients = mbprosEntities.PatientMasters.Where(aa => aa.PatientID == patientID).ToList();
foreach (var pat in patients)
{
pat.IsArchived = false;
mbprosEntities.Entry(pat).State = System.Data.Entity.EntityState.Modified;
mbprosEntities.SaveChanges();
}
TempData["EditMessage"] = "Y";
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult PDFForPatient(int patientID)
{
MbprosEntities en = new MbprosEntities();
//get the patient data with matching patient id
PatientMaster objPatient = en.PatientMasters.Where(x => x.PatientID == patientID).FirstOrDefault();
if (objPatient != null)
{
//Generates pdf for the patient data using PDFForPatient view.
//return new Rotativa.ViewAsPdf("PDFForPatient", objPatient) { FileName = "PatientInformation.pdf" };
return(new Rotativa.ViewAsPdf("PDFForPatient", objPatient));
// return View(objPatient);
}
return(View(objPatient));
}
/// <summary>
/// Generate PDF for patient billing form
/// </summary>
/// <param name="billingID">Billing Id</param>
/// <returns>PDF File</returns> ///
public ActionResult PDFForPatientBilling(int billingID)
{
MbprosEntities en = new MbprosEntities();
//get the patient billing data with matching billing form id
List <PatientBilling> objPatientBilling = en.PatientBillings.Where(x => x.PatientBillingID == billingID).ToList();
if (objPatientBilling != null)
{
//Generates pdf for the patient billing data using PDFForPatientBilling view.
return(new Rotativa.ViewAsPdf("PDFForPatientBilling", objPatientBilling)
{
PageOrientation = Orientation.Landscape
});
}
return(View(objPatientBilling));
}
/// <summary>
/// Verifies that the specified user name and password exist in the data source.
/// </summary>
/// <returns>
/// true if the specified username and password are valid; otherwise, false.
/// </returns>
/// <param name="username">The name of the user to validate. </param><param name="password">The password for the specified user. </param>
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(false);
}
using (var context = new MbprosEntities())
{
var user = (from u in context.Users
where String.Compare(u.UserName, username, StringComparison.OrdinalIgnoreCase) == 0 &&
String.Compare(u.Password, password, StringComparison.OrdinalIgnoreCase) == 0 &&
u.Status == true
select u).FirstOrDefault();
return(user != null);
}
}
/// <summary>
/// Gets a list of the roles that a specified user is in for the configured applicationName.
/// </summary>
/// <returns>
/// A string array containing the names of all the roles that the specified user is in for the configured applicationName.
/// </returns>
/// <param name="username">The user to return a list of roles for.</param>
public override string[] GetRolesForUser(string username)
{
//Return if the user is not authenticated
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
return(null);
}
//Return if present in Cache
var cacheKey = string.Format("UserRoles_{0}", username);
if (HttpRuntime.Cache[cacheKey] != null)
{
return((string[])HttpRuntime.Cache[cacheKey]);
}
//Get the roles from DB
var userRoles = new string[] { };
using (var context = new MbprosEntities())
{
var user = (from u in context.Users//.Include(usr => usr.UserRole)
where String.Compare(u.UserName, username, StringComparison.OrdinalIgnoreCase) == 0
select u).FirstOrDefault();
if (user != null)
{
if (user.IsAdmin)
{
userRoles[0] = "ADMIN";
}
else
{
userRoles[0] = "USER";
}
}
}
//Store in cache
HttpRuntime.Cache.Insert(cacheKey, userRoles, null, DateTime.Now.AddMinutes(_cacheTimeoutInMinutes), Cache.NoSlidingExpiration);
// Return
return(userRoles.ToArray());
}
public ActionResult AddUser(int userID = 0, string message = "")
{
UserModels userModel = new UserModels();
if (userID > 0)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var userDetails = mbprosEntities.Users.Find(userID);
if (userDetails != null)
{
userModel.UserId = userID;
userModel.UserName = userDetails.UserName;
userModel.Password = userDetails.Password;
userModel.OfficeName = userDetails.OfficeName;
userModel.EmailID = userDetails.EmailID;
userModel.IsAdmin = userDetails.IsAdmin;
}
}
ViewBag.UserMessage = message;
return(View(userModel));
}
public JsonResult DeleteUser(int userID)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var user = mbprosEntities.Users.Find(userID);
if (user != null)
{
mbprosEntities.Users.Attach(user);
mbprosEntities.Users.Remove(user);
mbprosEntities.SaveChanges();
//Delete from membership
((SimpleMembershipProvider)Membership.Provider).DeleteAccount(user.UserName);
string[] allRoles = { "USER" };
Roles.RemoveUserFromRoles(user.UserName, allRoles);
Membership.Provider.DeleteUser(user.UserName, true);
Membership.DeleteUser(user.UserName, true);
}
TempData["UserMessage"] = "Y";
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult AddUser(UserModels userModel)
{
if (ModelState.IsValid)
{
var UserId = Convert.ToString(Session["USERID"]) == "" ? 0 : Convert.ToInt32(Session["USERID"]);
if (userModel.UserId == 0)//ADD mode
{
if (!IsUserExist(userModel.UserName))
{
using (MbprosEntities mbprosEntities = new MbprosEntities())
{
User user = new User();
user.UserName = userModel.UserName;
user.OfficeName = userModel.OfficeName;
user.Password = userModel.Password;
user.Status = true;
user.IsAdmin = true;
user.EmailID = userModel.EmailID;
user.IsAdmin = false;
//if (userModel.IsAdmin == null)
// user.IsAdmin = false;
//else
// user.IsAdmin = userModel.IsAdmin == true ? true : false;
user.CreatedDate = DateTime.Now.Date;
user.CreatedBy = UserId;
mbprosEntities.Users.Add(user);
//Save user in membership
WebSecurity.CreateUserAndAccount(userModel.UserName, userModel.Password);
if (!Roles.RoleExists("USER"))
{
Roles.CreateRole("USER");
}
Roles.AddUserToRole(userModel.UserName, "USER");
mbprosEntities.SaveChanges();
//Add entries in FeatuereUser table for Normal user
var idParam = new SqlParameter
{
ParameterName = "UserID",
Value = user.UserId
};
var idParamB = new SqlParameter
{
ParameterName = "IsAdminUser",
Value = 0
};
mbprosEntities.Database.ExecuteSqlCommand("usp_AddFeatureUser @UserID, @IsAdminUser", idParam, idParamB);
//
}
ViewBag.IsUserExist = "";
TempData["UserMessage"] = "Y";
//return RedirectToAction("AddUser", new { userID = 0, message = "User saved successfully." });
return(RedirectToAction("SearchUser", new { message = "User added successfully.", IsBack = true }));
}
else
{
ViewBag.IsUserExist = "YES";
}
}
else//EDIT mode
{
using (MbprosEntities mbprosEntities = new MbprosEntities())
{
User user = mbprosEntities.Users.Find(userModel.UserId);
if (user != null)
{
WebSecurity.ChangePassword(userModel.UserName, user.Password, userModel.Password);
//user.UserName = userModel.UserName; //NEVER
user.OfficeName = userModel.OfficeName;
user.Password = userModel.Password;
user.EmailID = userModel.EmailID;
user.UpdatedDate = DateTime.Now;
user.UpdatedBy = UserId;
user.IsAdmin = userModel.IsAdmin;
mbprosEntities.Entry(user).State = System.Data.Entity.EntityState.Modified;
mbprosEntities.SaveChanges();
}
}
TempData["UserMessage"] = "Y";
return(RedirectToAction("SearchUser", new { message = "User updated successfully.", IsBack = true }));
}
}
return(View(userModel));
}
public ActionResult BillingLog(BillingModel billingModel)
{
if (ModelState.IsValid)
{
var UserId = Convert.ToString(Session["USERID"]) == "" ? 0 : Convert.ToInt32(Session["USERID"]);
// check captcha code is valid or not
bool isCaptchaCodeValid = false;
string ReCaptchaMessage = "";
if (billingModel.BillingID == 0)// Code for Add Billing details
{
if (UserId > 0)
{
isCaptchaCodeValid = true;
}
else
{
isCaptchaCodeValid = CommonFunctions.GetCaptchaResponse(Request.Form["recaptcha_challenge_field"], Request.Form["recaptcha_response_field"], billingModel.CaptchaSecretkey.ToString(), out ReCaptchaMessage);
}
if (isCaptchaCodeValid)
{
int patientBillingID = 0;
using (MbprosEntities mbprosEntities = new MbprosEntities())
{
patientBillingID = Common.CommonFunctions.GetNextPatientBillingID();
for (int i = 1; i <= 15; i++)
{
if (!string.IsNullOrEmpty(Request.Form["PatientName" + i]))
{
PatientBilling patientBilling = new PatientBilling();
patientBilling.PatientBillingID = patientBillingID;
patientBilling.OfficeName = billingModel.OfficeName;
patientBilling.PatientName = Request.Form["PatientName" + i];
if (!string.IsNullOrEmpty(Request.Form["ServiceDate" + i]))
{
patientBilling.ServiceDate = DateTime.ParseExact(Request.Form["ServiceDate" + i], "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientBilling.CoPayType = Request.Form["CopayType" + i];
if (!string.IsNullOrEmpty(patientBilling.CoPayType))
{
patientBilling.ChequeNo = Request.Form["ChequeNo" + i];
patientBilling.CopayPaid = Convert.ToDecimal(Request.Form["CopayPaid" + i]);
}
patientBilling.ProcedureCodes = Request.Form["ProcedureCodes" + i];
patientBilling.DXCode = Request.Form["NewDXCodes" + i];
patientBilling.SrNo = i;
patientBilling.CreatedDate = DateTime.Now.Date;
patientBilling.CreatedBy = UserId;
patientBilling.Active = true;
patientBilling.IsArchived = false;
patientBilling.Note = billingModel.AdditionalComments;
mbprosEntities.PatientBillings.Add(patientBilling);
}
}
mbprosEntities.SaveChanges();
}
ViewBag.ReCaptchaMessage = "";
return(RedirectToAction("Confirmation", "Billing", new { billingFormID = patientBillingID, officeName = billingModel.OfficeName }));
}
else
{
ViewBag.ReCaptchaMessage = ReCaptchaMessage;
}
}
else// Code for edit Billing details
{
// here we will have to add 3 codes first for edit existing , other for add new if not exist in DB and one for for deleting if user deletes exisitng record.
MbprosEntities mbprosEntities = new MbprosEntities();
var billDetails = mbprosEntities.PatientBillings.Where(x => x.PatientBillingID == billingModel.BillingID);
int patientBillingID = 0;
for (int i = 1; i <= 15; i++)
{
PatientBilling objBilling = billDetails.Where(x => x.SrNo == i).FirstOrDefault();
if (!string.IsNullOrEmpty(Request.Form["PatientName" + i]))
{
if (objBilling != null) // it means update the record.
{
if (i == 1)
{
patientBillingID = objBilling.PatientBillingID;
}
objBilling.OfficeName = billingModel.OfficeName;
objBilling.PatientName = Request.Form["PatientName" + i];
if (!string.IsNullOrEmpty(Request.Form["ServiceDate" + i]))
{
objBilling.ServiceDate = DateTime.ParseExact(Request.Form["ServiceDate" + i], "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
objBilling.CoPayType = Request.Form["CopayType" + i];
if (!string.IsNullOrEmpty(objBilling.CoPayType))
{
objBilling.ChequeNo = Request.Form["ChequeNo" + i];
objBilling.CopayPaid = Convert.ToDecimal(Request.Form["CopayPaid" + i]);
}
objBilling.ProcedureCodes = Request.Form["ProcedureCodes" + i];
objBilling.DXCode = Request.Form["NewDXCodes" + i];
objBilling.SrNo = i;
objBilling.Active = true;
objBilling.Note = billingModel.AdditionalComments;
objBilling.BillingFormID = objBilling.BillingFormID;
objBilling.UpdatedDate = DateTime.Now;
objBilling.UpdatedBy = UserId;
mbprosEntities.Entry(objBilling).State = System.Data.Entity.EntityState.Modified;
mbprosEntities.SaveChanges();
}
else
{ // 2 conditions add
PatientBilling patientBilling = new PatientBilling();
patientBilling.PatientBillingID = patientBillingID;
patientBilling.OfficeName = billingModel.OfficeName;
patientBilling.PatientName = Request.Form["PatientName" + i];
if (!string.IsNullOrEmpty(Request.Form["ServiceDate" + i]))
{
patientBilling.ServiceDate = DateTime.ParseExact(Request.Form["ServiceDate" + i], "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientBilling.CoPayType = Request.Form["CopayType" + i];
if (!string.IsNullOrEmpty(patientBilling.CoPayType))
{
patientBilling.ChequeNo = Request.Form["ChequeNo" + i];
patientBilling.CopayPaid = Convert.ToDecimal(Request.Form["CopayPaid" + i]);
}
patientBilling.ProcedureCodes = Request.Form["ProcedureCodes" + i];
patientBilling.DXCode = Request.Form["NewDXCodes" + i];
patientBilling.SrNo = i;
patientBilling.Active = true;
patientBilling.Note = billingModel.AdditionalComments;
patientBilling.CreatedDate = DateTime.Now.Date;
patientBilling.CreatedBy = UserId;
patientBilling.IsArchived = false;
mbprosEntities.PatientBillings.Add(patientBilling);
mbprosEntities.SaveChanges();
}
}
else
{
if (objBilling != null) // it means delete the record.
{
mbprosEntities.PatientBillings.Attach(objBilling);
mbprosEntities.PatientBillings.Remove(objBilling);
mbprosEntities.SaveChanges();
}
}
}
TempData["EditMessage"] = "Y";
return(RedirectToAction(billingModel.CallFrom, "Search", new { editMessage = "Patient billing details updated successfully", IsBack = true }));
}
}
return(View(billingModel));
}
public ActionResult AddPatient(PatientModel patientModel)
{
patientModel.Sex = Request.Form["hdnSex"];
patientModel.IsPatInsured = Request.Form["hdnIsInsured"];
patientModel.IsConditionRelatedTo = Request.Form["hdnIsConditionRelatedTo"];
patientModel.IsSecondaryInsurance = Request.Form["hdnIsSecInsurance"];
patientModel.IsVerifyEligibility = Request.Form["hdnIsVerify"];
// var errors = ModelState
//.Where(x => x.Value.Errors.Count > 0)
//.Select(x => new { x.Key, x.Value.Errors })
//.ToArray();
if (ModelState.IsValid)
{
var UserId = Convert.ToString(Session["USERID"]) == "" ? 0 : Convert.ToInt32(Session["USERID"]);
// check captcha code is valid or not
bool isCaptchaCodeValid = false;
string CaptchaMessage = "";
if (UserId > 0)
{
isCaptchaCodeValid = true;
}
else
{
isCaptchaCodeValid = CommonFunctions.GetCaptchaResponse(Request.Form["recaptcha_challenge_field"], Request.Form["recaptcha_response_field"], patientModel.CaptchaSecretkey.ToString(), out CaptchaMessage);
}
if (isCaptchaCodeValid)
{
int patientID = 0;
using (MbprosEntities mbprosEntities = new MbprosEntities())
{
PatientMaster patientMaster = new PatientMaster();
if (patientModel.PatientID != 0)
{
patientMaster = mbprosEntities.PatientMasters.Find(patientModel.PatientID);
patientModel.Sex = Request.Form["hdnSex"];
patientModel.IsPatInsured = Request.Form["hdnIsInsured"];
patientModel.IsConditionRelatedTo = Request.Form["hdnIsConditionRelatedTo"];
patientModel.IsSecondaryInsurance = Request.Form["hdnIsSecInsurance"];
patientModel.IsVerifyEligibility = Request.Form["hdnIsVerify"];
}
patientMaster.OfficeName = patientModel.OfficeName;
patientMaster.PatientName = patientModel.PatientName;
patientMaster.StreetAddress = patientModel.StreetAddress;
patientMaster.City = patientModel.City;
patientMaster.StateCode = patientModel.StateCode;
patientMaster.ZipCode = patientModel.ZipCode;
if (!string.IsNullOrEmpty(patientModel.DateofBirth))
{
patientMaster.DateofBirth = DateTime.ParseExact(patientModel.DateofBirth, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.SSN = patientModel.SSN;
patientMaster.Sex = patientModel.Sex == "" ? "M" : patientModel.Sex;
patientMaster.InsuranceCompanyName = patientModel.InsuranceCompanyName;
patientMaster.InsuranceCompanyAddress = patientModel.InsuranceCompanyAddress;
patientMaster.InsuranceCompanyPhone = patientModel.InsuranceCompanyPhone;
patientMaster.EDIPayerNumber = patientModel.EDIPayerNumber;
patientMaster.PolicyID = patientModel.PolicyID;
patientMaster.GroupNumber = patientModel.GroupNumber;
if (patientModel.IsPatInsured == "NO")
{
patientMaster.PrimaryInsuredName = patientModel.PrimaryInsuredName;
if (!string.IsNullOrEmpty(patientModel.PrimaryInsuredDOB))
{
patientMaster.PrimaryInsuredDOB = DateTime.ParseExact(patientModel.PrimaryInsuredDOB, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.IsInsured = false;
}
else if (patientModel.IsPatInsured == "YES")
{
patientMaster.IsInsured = true;
}
patientMaster.ConditionRelatedTo = patientModel.IsConditionRelatedTo;
if (!string.IsNullOrEmpty(patientModel.DateofAccident))
{
patientMaster.DateofAccident = DateTime.ParseExact(patientModel.DateofAccident, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.InsuranceFax = patientModel.InsuranceFax;
patientMaster.AdjusterName = patientModel.AdjusterName;
if (patientModel.IsSecondaryInsurance == "True")// "Y")// IsSecInsurance == "YES")
{
patientMaster.SecondaryInsuranceCompanyName = patientModel.SecondaryInsuranceCompanyName;
patientMaster.SecondaryInsuranceCompanyAddr = patientModel.SecondaryCompanyAddr;
patientMaster.SecondaryInsuranceCompanyPhone = patientModel.SecondaryInsuranceCompanyPhone;
patientMaster.SecondaryInsuranceID = patientModel.SecondaryInsuranceID;
patientMaster.SecondaryInsuranceGroupID = patientModel.SecondaryInsuranceGroupID;
patientMaster.SecondaryInsuredName = patientModel.SecondaryInsuredName;
if (!string.IsNullOrEmpty(patientModel.SecondaryInsuredDOB))
{
patientMaster.SecondaryInsuredDOB = DateTime.ParseExact(patientModel.SecondaryInsuredDOB, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.IsSecondaryInsurance = true;
}
else
{
patientMaster.IsSecondaryInsurance = false;
}
patientMaster.IsVerifyEligibility = patientModel.IsVerifyEligibility == "True" ? true : false;
patientMaster.FacilityName = patientModel.FacilityName;
if (!string.IsNullOrEmpty(patientModel.AdmissionDate))
{
patientMaster.AdmissionDate = DateTime.ParseExact(patientModel.AdmissionDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
if (!string.IsNullOrEmpty(patientModel.LastSeenByRefProvider))
{
patientMaster.LastSeenByRefProvider = DateTime.ParseExact(patientModel.LastSeenByRefProvider, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.ReferringProviderName = patientModel.ReferringProviderName;
patientMaster.ReferringProviderNPI = patientModel.ReferringProviderNPI;
if (!string.IsNullOrEmpty(patientModel.InitialTreatmentDate))
{
patientMaster.InitialTreatmentDate = DateTime.ParseExact(patientModel.InitialTreatmentDate, "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
patientMaster.LastXRayDateORPARTCodes = patientModel.LastXRayDateORPARTCodes;
patientMaster.DiagnosisCodes = patientModel.DiagnosisCodes;
patientMaster.AdditionalInfo = patientModel.AdditionalInfo;
//patientMaster.InsuranceVerification = patientModel.InsVerification;
patientMaster.Active = true;
//patientMaster.UserEmailID = patientModel.UserEmailID;
if (patientModel.PatientID == 0)
{
patientMaster.CreatedDate = DateTime.Now.Date;
patientMaster.CreatedBy = UserId;
mbprosEntities.PatientMasters.Add(patientMaster);
mbprosEntities.SaveChanges();
patientID = patientMaster.PatientID;
}
else
{
patientID = patientMaster.PatientID;
patientMaster.UpdatedDate = DateTime.Now;
patientMaster.UpdatedBy = UserId;
mbprosEntities.Entry(patientMaster).State = System.Data.Entity.EntityState.Modified;
mbprosEntities.SaveChanges();
}
}
ViewBag.CaptchaMessage = "";
if (patientModel.PatientID == 0)
{
return(RedirectToAction("Confirmation", new { patientID = patientID, officeName = patientModel.OfficeName }));
}
else
{
TempData["EditMessage"] = "Y";
return(RedirectToAction(patientModel.CallFrom, "Search", new { editMessage = "Patient details updated successfully", IsBack = true }));
}
}
else
{
ViewBag.CaptchaMessage = CaptchaMessage;
}
}
patientModel.StateList = new SelectList(CommonFunctions.GetAllDropdownList("STATES"), "ID", "NAME", 0);
return(View(patientModel));
}
public ActionResult AddPatient(int patientID = 0, string callFrom = "")
{
MbprosEntities en = new MbprosEntities();
var lstconfigkeys = en.Configs.ToList();
PatientModel patientModel = new PatientModel();
patientModel.CaptchaSitekeychallenge = "https://www.google.com/recaptcha/api/challenge?k=" + lstconfigkeys.Where(x => x.key == "CaptchaSitekey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSitekey"].ToString().Trim();
patientModel.CaptchaSitekeynoscript = "https://www.google.com/recaptcha/api/noscript?k=" + lstconfigkeys.Where(x => x.key == "CaptchaSitekey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSitekey"].ToString().Trim();
patientModel.CaptchaSecretkey = lstconfigkeys.Where(x => x.key == "CaptchaSecretkey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSecretkey"].ToString().Trim();
patientModel.CallFrom = callFrom;
patientModel.StateList = new SelectList(CommonFunctions.GetAllDropdownList("STATES"), "ID", "NAME", 0);
int UserID = Session["USERID"] == null ? 0 : Convert.ToInt32(Session["USERID"]);
if (patientID > 0)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var patientDetails = mbprosEntities.PatientMasters.Find(patientID);
if (patientDetails != null)
{
patientModel.PatientID = patientID;
if (patientDetails.CreatedDate != null)
{
patientModel.CreatedDate = Convert.ToDateTime(patientDetails.CreatedDate).ToString("MM/dd/yyyy");
}
patientModel.OfficeName = patientDetails.OfficeName;
patientModel.Active = patientDetails.Active;
patientModel.AdditionalInfo = patientDetails.AdditionalInfo;
patientModel.AdjusterName = patientDetails.AdjusterName;
if (patientDetails.AdmissionDate != null)
{
patientModel.AdmissionDate = Convert.ToDateTime(patientDetails.AdmissionDate).ToString("MM/dd/yyyy");
}
patientModel.City = patientDetails.City;
if (patientDetails.DateofAccident != null)
{
patientModel.DateofAccident = Convert.ToDateTime(patientDetails.DateofAccident).ToString("MM/dd/yyyy");
}
if (patientDetails.DateofBirth != null)
{
patientModel.DateofBirth = Convert.ToDateTime(patientDetails.DateofBirth).ToString("MM/dd/yyyy");
}
patientModel.DiagnosisCodes = patientDetails.DiagnosisCodes;
patientModel.EDIPayerNumber = patientDetails.EDIPayerNumber;
patientModel.FacilityName = patientDetails.FacilityName;
patientModel.GroupNumber = patientDetails.GroupNumber;
if (patientDetails.InitialTreatmentDate != null)
{
patientModel.InitialTreatmentDate = Convert.ToDateTime(patientDetails.InitialTreatmentDate).ToString("MM/dd/yyyy");
}
patientModel.InsuranceCompanyAddress = patientDetails.InsuranceCompanyAddress;
patientModel.InsuranceCompanyName = patientDetails.InsuranceCompanyName;
patientModel.InsuranceCompanyPhone = patientDetails.InsuranceCompanyPhone;
patientModel.InsuranceFax = patientDetails.InsuranceFax;
patientModel.IsConditionRelatedTo = patientDetails.ConditionRelatedTo;
patientModel.IsInsured = patientDetails.IsInsured ?? false;
//patientModel.IsPatInsured= patientDetails.ins;
if (patientModel.IsInsured == false)
{
patientModel.IsPatInsured = "NO";
}
else if (patientModel.IsInsured == true)
{
patientModel.IsPatInsured = "YES";
}
patientModel.IsSecondaryInsurance = patientDetails.IsSecondaryInsurance.ToString();
patientModel.IsVerifyEligibility = patientDetails.IsVerifyEligibility.ToString();
if (patientDetails.LastSeenByRefProvider != null)
{
patientModel.LastSeenByRefProvider = Convert.ToDateTime(patientDetails.LastSeenByRefProvider).ToString("MM/dd/yyyy");
}
patientModel.LastXRayDateORPARTCodes = patientDetails.LastXRayDateORPARTCodes;
patientModel.PatientName = patientDetails.PatientName;
patientModel.PolicyID = patientDetails.PolicyID;
if (patientDetails.PrimaryInsuredDOB != null)
{
patientModel.PrimaryInsuredDOB = Convert.ToDateTime(patientDetails.PrimaryInsuredDOB).ToString("MM/dd/yyyy");
}
patientModel.PrimaryInsuredName = patientDetails.PrimaryInsuredName;
patientModel.ReferringProviderName = patientDetails.ReferringProviderName;
patientModel.ReferringProviderNPI = patientDetails.ReferringProviderNPI;
patientModel.SecondaryCompanyAddr = patientDetails.SecondaryInsuranceCompanyAddr;
patientModel.SecondaryInsuranceCompanyName = patientDetails.SecondaryInsuranceCompanyName;
patientModel.SecondaryInsuranceCompanyPhone = patientDetails.SecondaryInsuranceCompanyPhone;
patientModel.SecondaryInsuranceGroupID = patientDetails.SecondaryInsuranceGroupID;
patientModel.SecondaryInsuranceID = patientDetails.SecondaryInsuranceID;
if (patientDetails.SecondaryInsuredDOB != null)
{
patientModel.SecondaryInsuredDOB = Convert.ToDateTime(patientDetails.SecondaryInsuredDOB).ToString("MM/dd/yyyy");
}
patientModel.SecondaryInsuredName = patientDetails.SecondaryInsuredName;
patientModel.Sex = patientDetails.Sex;
patientModel.SSN = patientDetails.SSN;
patientModel.StateCode = patientDetails.StateCode;
patientModel.StreetAddress = patientDetails.StreetAddress;
patientModel.ZipCode = patientDetails.ZipCode;
//patientModel.InsVerification = patientDetails.InsuranceVerification;
var statecode = mbprosEntities.States.Where(x => x.StateCode == patientDetails.StateCode).FirstOrDefault();
if (statecode != null)
{
patientModel.StateList = new SelectList(CommonFunctions.GetAllDropdownList("STATES"), "ID", "NAME", statecode.StateID);
}
}
}
else
{
if (UserID > 0)
{
patientModel.OfficeName = CommonFunctions.GetUserOffice(UserID);
}
}
patientModel.UserID = UserID;
return(View(patientModel));
}
public static void SendEmail(string officeName, string callFrom)
{
MbprosEntities en = new MbprosEntities();
var lstconfigkeys = en.Configs.ToList();
string emailFrom = "", emailFromName = "", subject = "", password = "";
string smtpAddress = lstconfigkeys.Where(x => x.key == "SmtpAddress").FirstOrDefault().value; //ConfigurationManager.AppSettings["SmtpAddress"].ToString().Trim();
int portNumber = Convert.ToInt32(lstconfigkeys.Where(x => x.key == "PortNumber").FirstOrDefault().value); //ConfigurationManager.AppSettings["PortNumber"].ToString().Trim() == "" ? 0 : Convert.ToInt32(ConfigurationManager.AppSettings["PortNumber"].ToString().Trim());
if (callFrom == "PATIENT_FORM")
{
emailFrom = lstconfigkeys.Where(x => x.key == "EmailSenderForPatientForm").FirstOrDefault().value; //ConfigurationManager.AppSettings["EmailSenderForPatientForm"].ToString().Trim();
emailFromName = lstconfigkeys.Where(x => x.key == "EmailSenderNameForPatientForm").FirstOrDefault().value; // ConfigurationManager.AppSettings["EmailSenderNameForPatientForm"].ToString().Trim();
subject = officeName + " has submitted a patient form";
password = lstconfigkeys.Where(x => x.key == "PasswordForPatientSender").FirstOrDefault().value; //ConfigurationManager.AppSettings["PasswordForPatientSender"].ToString().Trim();
}
else if (callFrom == "BILLING_FORM")
{
emailFrom = lstconfigkeys.Where(x => x.key == "EmailSenderForBillingLog").FirstOrDefault().value; //ConfigurationManager.AppSettings["EmailSenderForBillingLog"].ToString().Trim();
emailFromName = lstconfigkeys.Where(x => x.key == "EmailSenderNameForBillingLog").FirstOrDefault().value; // ConfigurationManager.AppSettings["EmailSenderNameForBillingLog"].ToString().Trim();
subject = officeName + " has submitted a billing form";
password = lstconfigkeys.Where(x => x.key == "PasswordForBillingSender").FirstOrDefault().value; //ConfigurationManager.AppSettings["PasswordForBillingSender"].ToString().Trim();
}
string pathToFiles = HttpContext.Current.Request.ServerVariables["SERVER_NAME"].ToLower();
string body = "Dear Medical Billing Professionals," +
"<br/><br/>" +
subject +
"<br/>" +
"Click here to go to Form Management Center: <a href='" + pathToFiles + "/Account/Login'>https://www.mbpros.com/Account/Login</a>" +
"<br/><br/>" +
"Regards," +
"<br/>" +
"Notification Mailer";
try
{
using (MailMessage mail = new MailMessage())
{
mail.From = new MailAddress(emailFrom, emailFromName);
User user = CommonFunctions.GetAdminUserDetails();
if (user != null)
{
mail.To.Add(new MailAddress(user.EmailID, user.UserName));
mail.Subject = subject;
mail.Body = body;
mail.IsBodyHtml = true;
using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber))
{
smtp.Credentials = new NetworkCredential(emailFrom, password);
smtp.EnableSsl = false;
smtp.Send(mail);
}
}
}
}
catch (Exception ex) {
logger.Error(ex.ToString());
logger.Info("Action send mail has been fired.");
}
}
log4net.ILog logger = log4net.LogManager.GetLogger(typeof(BillingController)); //Declaring Log4Net
public ActionResult BillingLog(int billingID = 0, string callFrom = "")
{
MbprosEntities en = new MbprosEntities();
var lstconfigkeys = en.Configs.ToList();
BillingModel billingModel = new BillingModel();
billingModel.CaptchaSitekeychallenge = "https://www.google.com/recaptcha/api/challenge?k=" + lstconfigkeys.Where(x => x.key == "CaptchaSitekey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSitekey"].ToString().Trim();
billingModel.CaptchaSitekeynoscript = "https://www.google.com/recaptcha/api/noscript?k=" + lstconfigkeys.Where(x => x.key == "CaptchaSitekey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSitekey"].ToString().Trim();
billingModel.CaptchaSecretkey = lstconfigkeys.Where(x => x.key == "CaptchaSecretkey").FirstOrDefault().value; //ConfigurationManager.AppSettings["CaptchaSecretkey"].ToString().Trim();
billingModel.CallFrom = callFrom;
if (billingID > 0)
{
MbprosEntities mbprosEntities = new MbprosEntities();
var billDetails = mbprosEntities.PatientBillings.Where(x => x.PatientBillingID == billingID);
if (billDetails != null)
{
billingModel.OfficeName = billDetails.FirstOrDefault().OfficeName;
billingModel.AdditionalComments = billDetails.FirstOrDefault().Note;
billingModel.BillingID = billingID;
if (billDetails.FirstOrDefault().CreatedDate != null)
{
billingModel.CreatedDate = Convert.ToDateTime(billDetails.FirstOrDefault().CreatedDate).ToString("MM/dd/yyyy");
}
foreach (var a in billDetails)
{
if (a.SrNo == 1)
{
billingModel.ChequeNo1 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid1 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes1 = a.DXCode;
billingModel.PatientName1 = a.PatientName;
billingModel.ProcedureCodes1 = a.ProcedureCodes;
billingModel.CopayType1 = a.CoPayType;
billingModel.ServiceDate1 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo1 = a.SrNo;
}
else if (a.SrNo == 2)
{
billingModel.ChequeNo2 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid2 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes2 = a.DXCode;
billingModel.PatientName2 = a.PatientName;
billingModel.ProcedureCodes2 = a.ProcedureCodes;
billingModel.ServiceDate2 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo2 = a.SrNo;
billingModel.CopayType2 = a.CoPayType;
}
else if (a.SrNo == 3)
{
billingModel.ChequeNo3 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid3 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes3 = a.DXCode;
billingModel.PatientName3 = a.PatientName;
billingModel.ProcedureCodes3 = a.ProcedureCodes;
billingModel.ServiceDate3 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo3 = a.SrNo;
billingModel.CopayType3 = a.CoPayType;
}
else if (a.SrNo == 4)
{
billingModel.ChequeNo4 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid4 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes4 = a.DXCode;
billingModel.PatientName4 = a.PatientName;
billingModel.ProcedureCodes4 = a.ProcedureCodes;
billingModel.ServiceDate4 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo4 = a.SrNo;
billingModel.CopayType4 = a.CoPayType;
}
else if (a.SrNo == 5)
{
billingModel.ChequeNo5 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid5 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes5 = a.DXCode;
billingModel.PatientName5 = a.PatientName;
billingModel.ProcedureCodes5 = a.ProcedureCodes;
billingModel.ServiceDate5 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo5 = a.SrNo;
billingModel.CopayType5 = a.CoPayType;
}
else if (a.SrNo == 6)
{
billingModel.ChequeNo6 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid6 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes6 = a.DXCode;
billingModel.PatientName6 = a.PatientName;
billingModel.ProcedureCodes6 = a.ProcedureCodes;
billingModel.ServiceDate6 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo6 = a.SrNo;
billingModel.CopayType6 = a.CoPayType;
}
else if (a.SrNo == 7)
{
billingModel.ChequeNo7 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid7 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes7 = a.DXCode;
billingModel.PatientName7 = a.PatientName;
billingModel.ProcedureCodes7 = a.ProcedureCodes;
billingModel.ServiceDate7 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo7 = a.SrNo;
billingModel.CopayType7 = a.CoPayType;
}
else if (a.SrNo == 8)
{
billingModel.ChequeNo8 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid8 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes8 = a.DXCode;
billingModel.PatientName8 = a.PatientName;
billingModel.ProcedureCodes8 = a.ProcedureCodes;
billingModel.ServiceDate8 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo8 = a.SrNo;
billingModel.CopayType8 = a.CoPayType;
}
else if (a.SrNo == 9)
{
billingModel.ChequeNo9 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid9 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes9 = a.DXCode;
billingModel.PatientName9 = a.PatientName;
billingModel.ProcedureCodes9 = a.ProcedureCodes;
billingModel.ServiceDate9 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo9 = a.SrNo;
billingModel.CopayType9 = a.CoPayType;
}
else if (a.SrNo == 10)
{
billingModel.ChequeNo10 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid10 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes10 = a.DXCode;
billingModel.PatientName10 = a.PatientName;
billingModel.ProcedureCodes10 = a.ProcedureCodes;
billingModel.ServiceDate10 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo10 = a.SrNo;
billingModel.CopayType10 = a.CoPayType;
}
else if (a.SrNo == 11)
{
billingModel.ChequeNo11 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid11 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes11 = a.DXCode;
billingModel.PatientName11 = a.PatientName;
billingModel.ProcedureCodes11 = a.ProcedureCodes;
billingModel.ServiceDate11 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo11 = a.SrNo;
billingModel.CopayType11 = a.CoPayType;
}
else if (a.SrNo == 12)
{
billingModel.ChequeNo12 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid12 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes12 = a.DXCode;
billingModel.PatientName12 = a.PatientName;
billingModel.ProcedureCodes12 = a.ProcedureCodes;
billingModel.ServiceDate12 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo12 = a.SrNo;
billingModel.CopayType12 = a.CoPayType;
}
else if (a.SrNo == 13)
{
billingModel.ChequeNo13 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid13 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes13 = a.DXCode;
billingModel.PatientName13 = a.PatientName;
billingModel.ProcedureCodes13 = a.ProcedureCodes;
billingModel.ServiceDate13 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo13 = a.SrNo;
billingModel.CopayType13 = a.CoPayType;
}
else if (a.SrNo == 14)
{
billingModel.ChequeNo14 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid14 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes14 = a.DXCode;
billingModel.PatientName14 = a.PatientName;
billingModel.ProcedureCodes14 = a.ProcedureCodes;
billingModel.ServiceDate14 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo14 = a.SrNo;
billingModel.CopayType14 = a.CoPayType;
}
else if (a.SrNo == 15)
{
billingModel.ChequeNo15 = a.ChequeNo;
if (a.CopayPaid != null)
{
billingModel.CopayPaid15 = Convert.ToDouble(a.CopayPaid);
}
billingModel.NewDXCodes15 = a.DXCode;
billingModel.PatientName15 = a.PatientName;
billingModel.ProcedureCodes15 = a.ProcedureCodes;
billingModel.ServiceDate15 = Convert.ToDateTime(a.ServiceDate).ToString("MM/dd/yyyy");
billingModel.SrNo15 = a.SrNo;
billingModel.CopayType15 = a.CoPayType;
}
}
}
}
else
{
int UserID = Session["USERID"] == null ? 0 : Convert.ToInt32(Session["USERID"]);
if (UserID > 0)
{
billingModel.OfficeName = CommonFunctions.GetUserOffice(UserID);
}
}
return(View(billingModel));
}
log4net.ILog logger = log4net.LogManager.GetLogger(typeof(AccountController)); //Declaring Log4Net
public ActionResult Login()
{
Session["NONLOGIN"] = "******";
////
try
{
var lstUsers = mbprosEntities.Users.ToList();
if (lstUsers.Count() == 0)
{
MbprosEntities en = new MbprosEntities();
var lstconfigkeys = en.Configs.ToList();
string FirstAdminUserName = lstconfigkeys.Where(x => x.key == "FirstAdminUserName").FirstOrDefault().value; //ConfigurationManager.AppSettings["FirstAdminUserName"].ToString().Trim();
string FirstAdminUserPswd = lstconfigkeys.Where(x => x.key == "FirstAdminUserPswd").FirstOrDefault().value; //ConfigurationManager.AppSettings["FirstAdminUserPswd"].ToString().Trim();
string FirstAdminUserOffice = lstconfigkeys.Where(x => x.key == "FirstAdminUserOffice").FirstOrDefault().value; // ConfigurationManager.AppSettings["FirstAdminUserOffice"].ToString().Trim();
string FirstAdminUserEmailID = lstconfigkeys.Where(x => x.key == "FirstAdminUserEmailID").FirstOrDefault().value; //ConfigurationManager.AppSettings["FirstAdminUserEmailID"].ToString().Trim();
//create a admin user with websecurity
WebSecurity.CreateUserAndAccount(FirstAdminUserName, FirstAdminUserPswd);
//Create ADMIN role if not exist in the system.
if (!Roles.RoleExists("ADMIN"))
{
Roles.CreateRole("ADMIN");
}
Roles.AddUserToRole(FirstAdminUserName, "ADMIN");
//Add entries in Users table
User user = new User();
user.UserName = FirstAdminUserName;
user.OfficeName = FirstAdminUserOffice;
user.Password = FirstAdminUserPswd;
user.Status = true;
user.IsAdmin = true;
user.EmailID = FirstAdminUserEmailID;
user.IsAdmin = true;
user.CreatedDate = DateTime.Now.Date;
user.CreatedBy = 1;
mbprosEntities.Users.Add(user);
mbprosEntities.SaveChanges();
//Add entries in FeatuereUser table for Admin user
var idParam = new SqlParameter
{
ParameterName = "UserID",
Value = user.UserId
};
var idParamB = new SqlParameter
{
ParameterName = "IsAdminUser",
Value = 1
};
mbprosEntities.Database.ExecuteSqlCommand("usp_AddFeatureUser @UserID, @IsAdminUser", idParam, idParamB);
}
}
catch (Exception ex)
{
// log.WriteLog("Page= addeditevent.aspx" + DateTime.Now + "\n" + ex.Message + "\n" + ex.StackTrace);
logger.Error(ex.ToString());
logger.Info("Action Index has been fired.");
return(RedirectToAction("Login", "Account"));
}
////
if (Session["USERNAME"] != null)
{
return(RedirectToAction("AddPatient", "Patient"));
}
return(View());
}