public HcCountryEntity GetSingleHcCountryRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, Countryname, flag, IsActive FROM HC_Country WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcCountryEntity hcCountryEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcCountryEntity = new HcCountryEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcCountryEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["Countryname"] != DBNull.Value)
{
hcCountryEntity.Countryname = dataReader["Countryname"].ToString();
}
if (dataReader["flag"] != DBNull.Value)
{
hcCountryEntity.Flag = dataReader["flag"].ToString();
}
if (dataReader["IsActive"] != DBNull.Value)
{
hcCountryEntity.Isactive = dataReader["IsActive"].ToString();
}
}
}
return(hcCountryEntity);
}
public object UpdateHcCountryInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcCountryEntity hcCountryEntity = (HcCountryEntity)param;
HcCountryDAL hcCountryDAL = new HcCountryDAL();
retObj = (object)hcCountryDAL.UpdateHcCountryInfo(hcCountryEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public bool SaveHcCountryInfo(HcCountryEntity hcCountryEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_Country ( Countryname, flag, IsActive) VALUES ( @Countryname, @Flag, @Isactive )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Countryname", DbType.String, hcCountryEntity.Countryname);
db.AddInParameter(dbCommand, "Flag", DbType.String, hcCountryEntity.Flag);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcCountryEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public bool UpdateHcCountryInfo(HcCountryEntity hcCountryEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_Country SET Countryname= @Countryname, flag= @Flag, IsActive= @Isactive WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcCountryEntity.Id);
db.AddInParameter(dbCommand, "Countryname", DbType.String, hcCountryEntity.Countryname);
db.AddInParameter(dbCommand, "Flag", DbType.String, hcCountryEntity.Flag);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcCountryEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public List <SelectListItem> List_Country()
{
List <SelectListItem> Items = new List <SelectListItem>();
HcCountryEntity obj = new HcCountryEntity();
obj.Isactive = "1";
DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllHcCountryRecord, obj);
foreach (DataRow dr in dt.Rows)
{
Items.Add(new SelectListItem {
Text = dr["Countryname"].ToString(), Value = dr["ID"].ToString()
});
}
return(Items);
}
