public object UpdateHcDiseasesInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcDiseasesEntity hcDiseasesEntity = (HcDiseasesEntity)param;
HcDiseasesDAL hcDiseasesDAL = new HcDiseasesDAL();
retObj = (object)hcDiseasesDAL.UpdateHcDiseasesInfo(hcDiseasesEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public bool SaveHcDiseasesInfo(HcDiseasesEntity hcDiseasesEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_Diseases ( DiseaseName, DiseaseDesc, Sypmtoms, ShortName, isActive) VALUES ( @Diseasename, @Diseasedesc, @Sypmtoms, @Shortname, @Isactive )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Diseasename", DbType.String, hcDiseasesEntity.Diseasename);
db.AddInParameter(dbCommand, "Diseasedesc", DbType.String, hcDiseasesEntity.Diseasedesc);
db.AddInParameter(dbCommand, "Sypmtoms", DbType.String, hcDiseasesEntity.Sypmtoms);
db.AddInParameter(dbCommand, "Shortname", DbType.String, hcDiseasesEntity.Shortname);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcDiseasesEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public bool UpdateHcDiseasesInfo(HcDiseasesEntity hcDiseasesEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_Diseases SET DiseaseName= @Diseasename, DiseaseDesc= @Diseasedesc, Sypmtoms= @Sypmtoms, ShortName= @Shortname, isActive= @Isactive WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcDiseasesEntity.Id);
db.AddInParameter(dbCommand, "Diseasename", DbType.String, hcDiseasesEntity.Diseasename);
db.AddInParameter(dbCommand, "Diseasedesc", DbType.String, hcDiseasesEntity.Diseasedesc);
db.AddInParameter(dbCommand, "Sypmtoms", DbType.String, hcDiseasesEntity.Sypmtoms);
db.AddInParameter(dbCommand, "Shortname", DbType.String, hcDiseasesEntity.Shortname);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcDiseasesEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public HcDiseasesEntity GetSingleHcDiseasesRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, DiseaseName, DiseaseDesc, Sypmtoms, ShortName, isActive FROM HC_Diseases WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcDiseasesEntity hcDiseasesEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcDiseasesEntity = new HcDiseasesEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcDiseasesEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["DiseaseName"] != DBNull.Value)
{
hcDiseasesEntity.Diseasename = dataReader["DiseaseName"].ToString();
}
if (dataReader["DiseaseDesc"] != DBNull.Value)
{
hcDiseasesEntity.Diseasedesc = dataReader["DiseaseDesc"].ToString();
}
if (dataReader["Sypmtoms"] != DBNull.Value)
{
hcDiseasesEntity.Sypmtoms = dataReader["Sypmtoms"].ToString();
}
if (dataReader["ShortName"] != DBNull.Value)
{
hcDiseasesEntity.Shortname = dataReader["ShortName"].ToString();
}
if (dataReader["isActive"] != DBNull.Value)
{
hcDiseasesEntity.Isactive = dataReader["isActive"].ToString();
}
}
}
return(hcDiseasesEntity);
}
