public ActionResult Registration(DoctorMaster obj, string SubmitBtn)
{
obj.CMD = SubmitBtn == "Save" ? "Save" : SubmitBtn == "Update" ? "Update" : "Delete";
obj.hid = Convert.ToInt32(Session["hospital"].ToString());
switch (obj.CMD)
{
case "Save":
string[] str = obj.PerformAction();
ViewBag.msg = str[1];
return(View("Registration", obj));
case "Update":
string[] str1 = obj.PerformAction();
ViewBag.msg = str1[2];
return(View("Registration", obj));
case "Delete":
string[] str2 = obj.PerformAction();
ViewBag.msg = str2[3];
return(View("Registration", obj));
default:
return(View(obj));
}
}
private void updateList(Common.DataBaseOperation DBAction, DoctorMaster objData)
{
DoctorMaster data;
switch ((int)DBAction)
{
case 0:
ListDoctorMaster.Add(objData);
break;
case 1:
data = getDataByCode(objData.DoctorCode);
if (data != null)
{
ListDoctorMaster.Remove(data);
ListDoctorMaster.Add(objData);
}
break;
case 2:
data = getDataByCode(objData.DoctorCode);
if (data != null)
{
ListDoctorMaster.Remove(data);
}
break;
}
}
public DataBaseResultSet SaveDoctorMaster <T>(T objData) where T : class, IModel, new()
{
DoctorMaster obj = objData as DoctorMaster;
string sQuery = "sprocDoctorMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.DoctorCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("DoctorName", "DoctorName", 50, GenericDataType.String, ParameterDirection.Input, obj.DoctorName));
list.Add(SqlConnManager.GetConnParameters("Add1", "Add1", 50, GenericDataType.String, ParameterDirection.Input, obj.Add1));
list.Add(SqlConnManager.GetConnParameters("Phone1", "Phone1", 50, GenericDataType.String, ParameterDirection.Input, obj.Phone1));
list.Add(SqlConnManager.GetConnParameters("Email", "Email", 50, GenericDataType.String, ParameterDirection.Input, obj.Email));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public void GetListDoctorMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListDoctorMaster";
DoctorMaster objData = objFilter as DoctorMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("DoctorCode", "DoctorCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.DoctorCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillDoctorMasterDataFromReader, ref listData);
}
public ActionResult Update(DoctorMaster obj, string SubmitBtn)
{
Registration(obj, SubmitBtn);
if (SubmitBtn == "Delete")
{
return(Redirect("~/Doctor/DoctorDetails"));
}
return(View("Registration", obj));
}
public void SearchData()
{
DoctorMaster data = getDataByCode(this.SearchDoctorCode);
if (data != null)
{
this.Clone <DoctorMaster>(data);
this.IsModifyData = true;
}
}
private void FillDoctorMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
DoctorMaster objData = obj as DoctorMaster;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public JsonResponse <int> SubmitDoctor(DoctorMaster doc)
{
JsonResponse <int> response = new JsonResponse <int>();
if (!ModelState.IsValid)
{
response.IsSuccess = false;
response.Message = "Model validation failed.";
return(response);
}
try
{
var docs = _context.DoctorMasters.Where(x => x.ID == doc.ID).FirstOrDefault();
if (docs == null)
{
if (!isDuplicateDocName(doc.FirstName, doc.LastName))
{
_context.DoctorMasters.Add(doc);
response.IsSuccess = _context.SaveChanges() > 0 ? true : false;
response.Message = "Your appointment with Dr. " + doc.FirstName + " is fixed.";
}
}
else
{
docs.FirstName = doc.FirstName;
docs.LastName = doc.LastName;
docs.ImageUrl = doc.ImageUrl;
docs.Email = doc.Email;
docs.Mobile = doc.Mobile;
docs.Designation = doc.Designation;
docs.Experience = doc.Experience;
docs.Specialist = doc.Specialist;
docs.Hospital = doc.Hospital;
docs.LogoUrl = doc.LogoUrl;
docs.RegistrationNo = doc.RegistrationNo;
docs.IsDeleted = doc.IsDeleted;
docs.UpdatedDate = DateTime.Now;
_context.Entry(docs).State = EntityState.Modified;
response.StatusCode = "200";
response.IsSuccess = _context.SaveChanges() > 0 ? true : false;
response.Message = "Your appointment with Dr. " + doc.FirstName + " is updated.";
}
}
catch (Exception ex)
{
response.StatusCode = "500";
response.IsSuccess = _context.SaveChanges() > 0 ? true : false;
response.Message = ex.Message;
}
return(response);
}
public ActionResult DoctorDetails()
{
DoctorMaster obj = new DoctorMaster();
DBConnection cn = new DBConnection();
obj.CMD = "View";
obj.hid = Convert.ToInt32(Session["hospital"].ToString());
string xml = Common.ToXML(obj);
DataSet dataset = cn.ExecuteProcedure("SP_DoctorRegistration", xml);
return(View(dataset));
}
public ViewResult Update(int doctorid)
{
DoctorMaster obj = new DoctorMaster();
if (doctorid > 0)
{
obj.CMD = "Update";
//obj = obj.GetSingleDoctor(doctorid);
obj = obj.GetSingleDoctor(doctorid, Convert.ToInt32(Session["hospital"].ToString()));
}
return(View("Registration", obj));
}
public AppoinmentModel GetAppoinmentData(string doctorId, string patientUserName)
{
AspNetUser user = _dbContext.AspNetUsers.SingleOrDefault(x => x.UserName == patientUserName);
PatientMaster patientMaster = _dbContext.PatientMasters.SingleOrDefault(x => x.UserLoginDetailsId == user.Id);
DoctorMaster doctorMaster = _dbContext.DoctorMasters.SingleOrDefault(x => x.Id == Convert.ToInt32(doctorId));
AppoinmentModel data = new AppoinmentModel
{
drname = doctorMaster.FirstName + " " + doctorMaster.LastName,
patientname = patientMaster.FirstName + " " + patientMaster.LastName,
drid = doctorMaster.Id.ToString(),
patientid = patientMaster.Id.ToString(),
speciality = doctorMaster.Speciality
};
return(data);
}
private string dataBaseAction(Common.DataBaseOperation DBAction)
{
string sMsg = string.Empty;
DoctorMaster objData = this.Copy <DoctorMaster>();
objData.OperationFlag = DBAction;
DataBaseResultSet DBRS = BLL.BllClient.objBllClient.Save <DoctorMaster>(Common.DataSourceTypes.DoctorMasterSave, objData);
sMsg = CommonModel.GetOperationMessage <DoctorMaster>(DBRS, objData);
if (DBRS.ErrorCode == 0)
{
updateList(DBAction, objData);
this.ResetData();
}
return(sMsg);
}
private void DoctorMasterMenuItem_Click(object sender, RoutedEventArgs e)
{
DoctorMaster MstCompanyDetail = new DoctorMaster();
MstCompanyDetail.ShowDialog();
}
public void AddDoctor(UsersModel model)
{
if (!(string.IsNullOrEmpty(model.loginId) && model.Id != 0))
{
if (model.Id == 0)
{
DoctorMaster doctor = new DoctorMaster
{
EmailId = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
Dob = model.DOB,
IsActive = true, //by Default
UserLoginDetailsId = model.loginId,
CreatedBy = model.CreatedBy,
ModifiedBy = model.UpdatedBy,
CreatedOn = DateTime.Now,
ModifiedOn = DateTime.Now,
Gender = model.Gender,
Age = AgeCalculator(model.DOB),
DoctorDisplayId = GetDoctorId(),
Title = model.Title,
Address = model.Address,
City = model.City,
PhoneNo = model.ContactNo,
Speciality = model.Speciality,
};
ctx.DoctorMasters.Add(doctor);
}
else
{
var doctor = ctx.DoctorMasters.Where(x => x.Id == model.Id).FirstOrDefault();
if (doctor != null)
{
doctor.FirstName = model.FirstName;
doctor.LastName = model.LastName;
doctor.Address = model.Address;
doctor.City = model.City;
doctor.PhoneNo = model.ContactNo;
}
}
ctx.SaveChanges();
}
else
{
if (model.Id != 0)
{
var doctor = ctx.DoctorMasters.Where(x => x.Id == model.Id).FirstOrDefault();
if (doctor != null)
{
doctor.FirstName = model.FirstName;
doctor.LastName = model.LastName;
doctor.Address = model.Address;
doctor.City = model.City;
doctor.PhoneNo = model.ContactNo;
doctor.Speciality = model.Speciality;
doctor.Dob = model.DOB;
doctor.Age = AgeCalculator(model.DOB);
doctor.Gender = model.Gender;
doctor.Title = model.Title;
ctx.SaveChanges();
}
}
else
{
throw new Exception("User not registered.");
}
}
}
public ViewResult Registration()
{
DoctorMaster obj = new DoctorMaster();
return(View(obj));
}
