/// <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();
}
}
