/// <summary> /// Updating existing record into Disease details /// </summary> public void Update() { try { string Q_UpdateDiseaseDetail = "Update diseasedetails set DocId = {0}, Age = {1}, Gender = '{2}', AreaId = {3}, PatientAddDate = '{4}', DiseaseId = {5} where Id = {6}"; Logger.Debug("DiseaseDetailModel", "Update", "Assigning values to query."); string cmdText = string.Format(Q_UpdateDiseaseDetail, this.DocId, this.Age, ParameterFormater.FormatParameter(this.Gender), this.AreaId, this.PatientAddDate.ToString("yyyy/MM/dd HH:mm:ss.fff"), this.DiseaseId); Logger.Debug("DiseaseMasterModel", "Update", "Formatting the special character."); Database db = new Database(); Logger.Debug("DiseaseMasterModel", "Update", "Database object created."); Logger.Debug("DiseaseMasterModel", "Update", "Before Update value in database."); db.Update(cmdText); Logger.Debug("DiseaseMasterModel", "Update", "Updated value in database."); } catch (Exception ex) { Logger.Error("DiseaseMasterModel", "Update", "Error occured while updating area master detail", ex); throw ex; } finally { Logger.Debug("DiseaseMasterModel", "Update", "Killing sleep connection."); Database.KillConnections(); } }
/// <summary> /// Updating existing record in database /// </summary> public void Update() { try { string Q_UpdateAreaMasterDetail = "Update areamaster set AreaName = '{0}', ShortAreaName = '{1}' where Id = {2}"; Logger.Debug("AreaMasterModel", "Update", "Assigning values to query."); string cmdText = string.Format(Q_UpdateAreaMasterDetail, ParameterFormater.FormatParameter(this.AreaName), ParameterFormater.FormatParameter(this.ShortAreaName), this.AreaId); Logger.Debug("AreaMasterModel", "Update", "Formatting the special character."); Database db = new Database(); Logger.Debug("AreaMasterModel", "Update", "Database object created."); Logger.Debug("AreaMasterModel", "Update", "Before Update value in database."); db.Update(cmdText); Logger.Debug("AreaMasterModel", "Update", "Updated value in database."); } catch (Exception ex) { Logger.Error("AreaMasterModel", "Update", "Error occured while updating area master detail", ex); throw ex; } finally { Logger.Debug("AreaMasterModel", "Update", "Killing sleep connection."); Database.KillConnections(); } }
/// <summary> /// Updating existing record into Disease details /// </summary> public void Update() { try { string Q_UpdateDoctorDetail = "Update doctordetails set DoctorName = '{0}', Department = '{1}', MobileNumber = '{2}', Adderess = '{3}', AreaId = {4}, Username = '******', Password = '******', CreatedDate = '{7}' where Id = {8}"; Logger.Debug("DoctorDetailsModel", "Update", "Assigning values to query."); string cmdText = string.Format(Q_UpdateDoctorDetail, ParameterFormater.FormatParameter(this.DoctorName), ParameterFormater.FormatParameter(this.Department), this.MobileNumber, ParameterFormater.FormatParameter(this.Address), this.AreaId, ParameterFormater.FormatParameter(this.UserName), ParameterFormater.FormatParameter(this.Password), this.CreateDate.ToString("yyyy/MM/dd HH:mm:ss.fff"), this.Id); Logger.Debug("DoctorDetailsModel", "Update", "Formatting the special character."); Database db = new Database(); Logger.Debug("DoctorDetailsModel", "Update", "Database object created."); Logger.Debug("DoctorDetailsModel", "Update", "Before Update value in database."); db.Update(cmdText); Logger.Debug("DoctorDetailsModel", "Update", "Updated value in database."); } catch (Exception ex) { Logger.Error("DoctorDetailsModel", "Update", "Error occured while updating area master detail", ex); throw ex; } finally { Logger.Debug("DoctorDetailsModel", "Update", "Killing sleep connection."); Database.KillConnections(); } }