public object UpdateHcPackagedetailsInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcPackagedetailsEntity hcPackagedetailsEntity = (HcPackagedetailsEntity)param;
HcPackagedetailsDAL hcPackagedetailsDAL = new HcPackagedetailsDAL();
retObj = (object)hcPackagedetailsDAL.UpdateHcPackagedetailsInfo(hcPackagedetailsEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public bool UpdateHcPackagedetailsInfo(HcPackagedetailsEntity hcPackagedetailsEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_PackageDetails SET refid= @Refid, PackageCovers= @Packagecovers, PackageIncludes= @Packageincludes, PackageProcess= @Packageprocess, LabPartner= @Labpartner, Packagebenifits= @Packagebenifits, createdby= @Createdby, createdDate= @Createddate, updateby= @Updateby, updateDate= @Updatedate, isactive= @Isactive WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcPackagedetailsEntity.Id);
db.AddInParameter(dbCommand, "Refid", DbType.String, hcPackagedetailsEntity.Refid);
db.AddInParameter(dbCommand, "Packagecovers", DbType.String, hcPackagedetailsEntity.Packagecovers);
db.AddInParameter(dbCommand, "Packageincludes", DbType.String, hcPackagedetailsEntity.Packageincludes);
db.AddInParameter(dbCommand, "Packageprocess", DbType.String, hcPackagedetailsEntity.Packageprocess);
db.AddInParameter(dbCommand, "Labpartner", DbType.String, hcPackagedetailsEntity.Labpartner);
db.AddInParameter(dbCommand, "Packagebenifits", DbType.String, hcPackagedetailsEntity.Packagebenifits);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcPackagedetailsEntity.Createdby);
db.AddInParameter(dbCommand, "Createddate", DbType.String, hcPackagedetailsEntity.Createddate);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcPackagedetailsEntity.Updateby);
db.AddInParameter(dbCommand, "Updatedate", DbType.String, hcPackagedetailsEntity.Updatedate);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcPackagedetailsEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public bool SaveHcPackagedetailsInfo(HcPackagedetailsEntity hcPackagedetailsEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_PackageDetails ( Id, refid, PackageCovers, PackageIncludes, PackageProcess, LabPartner, Packagebenifits, createdby, createdDate, updateby, updateDate, isactive) VALUES ( @Id, @Refid, @Packagecovers, @Packageincludes, @Packageprocess, @Labpartner, @Packagebenifits, @Createdby, @Createddate, @Updateby, @Updatedate, @Isactive )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcPackagedetailsEntity.Id);
db.AddInParameter(dbCommand, "Refid", DbType.String, hcPackagedetailsEntity.Refid);
db.AddInParameter(dbCommand, "Packagecovers", DbType.String, hcPackagedetailsEntity.Packagecovers);
db.AddInParameter(dbCommand, "Packageincludes", DbType.String, hcPackagedetailsEntity.Packageincludes);
db.AddInParameter(dbCommand, "Packageprocess", DbType.String, hcPackagedetailsEntity.Packageprocess);
db.AddInParameter(dbCommand, "Labpartner", DbType.String, hcPackagedetailsEntity.Labpartner);
db.AddInParameter(dbCommand, "Packagebenifits", DbType.String, hcPackagedetailsEntity.Packagebenifits);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcPackagedetailsEntity.Createdby);
db.AddInParameter(dbCommand, "Createddate", DbType.String, hcPackagedetailsEntity.Createddate);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcPackagedetailsEntity.Updateby);
db.AddInParameter(dbCommand, "Updatedate", DbType.String, hcPackagedetailsEntity.Updatedate);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcPackagedetailsEntity.Isactive);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
string getAllPackages()
{
string packageData = "";
HcPackagemasterEntity pmObj = new HcPackagemasterEntity();
HcPackagedetailsEntity pdObj = new HcPackagedetailsEntity();
pmObj.Isactive = "1";
DataTable dt = (DataTable)ExecuteDB(HCareTaks.AG_GetAllHcPackagemasterRecord, pmObj);
if (dt.Rows.Count > 0)
{
foreach (DataRow dpm in dt.Rows)
{
packageData += @"<div class='card custome-card' style='background-image: url(" + dpm["packageImage"] + ") no-repeat; background-color: #ffffff' >" +
"<a href = '/Home/Packages/" + dpm["ID"] + "'>" +
"<img class='card-img-top' src=" + dpm["packageImage"] + " alt='Packeage iamge'>" +
"<div class='card-body'>" +
"<div class='row'>" +
"<div class='col-md-8 col-lg-8 '>" +
"<h4 class='card-title'>" + dpm["PackageName"] + "</h4>" +
"<p class='card-text'>" + dpm["PackageShorDesc"] + "</p>" +
"</div>" +
"<div class='col-md-4 col-lg-4'>" +
"<h3 class='card-title text-center'>" + dpm["PackagePrice"] + " </h3>" +
"</div>" +
"</div>" +
"</div> </a> </div>";
}
}
return(packageData);
}
public HcPackagedetailsEntity GetSingleHcPackagedetailsRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT Id, refid, PackageCovers, PackageIncludes, PackageProcess, LabPartner, Packagebenifits, createdby, createdDate, updateby, updateDate, isactive FROM HC_PackageDetails WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcPackagedetailsEntity hcPackagedetailsEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcPackagedetailsEntity = new HcPackagedetailsEntity();
if (dataReader["Id"] != DBNull.Value)
{
hcPackagedetailsEntity.Id = dataReader["Id"].ToString();
}
if (dataReader["refid"] != DBNull.Value)
{
hcPackagedetailsEntity.Refid = dataReader["refid"].ToString();
}
if (dataReader["PackageCovers"] != DBNull.Value)
{
hcPackagedetailsEntity.Packagecovers = dataReader["PackageCovers"].ToString();
}
if (dataReader["PackageIncludes"] != DBNull.Value)
{
hcPackagedetailsEntity.Packageincludes = dataReader["PackageIncludes"].ToString();
}
if (dataReader["PackageProcess"] != DBNull.Value)
{
hcPackagedetailsEntity.Packageprocess = dataReader["PackageProcess"].ToString();
}
if (dataReader["LabPartner"] != DBNull.Value)
{
hcPackagedetailsEntity.Labpartner = dataReader["LabPartner"].ToString();
}
if (dataReader["Packagebenifits"] != DBNull.Value)
{
hcPackagedetailsEntity.Packagebenifits = dataReader["Packagebenifits"].ToString();
}
if (dataReader["createdby"] != DBNull.Value)
{
hcPackagedetailsEntity.Createdby = dataReader["createdby"].ToString();
}
if (dataReader["createdDate"] != DBNull.Value)
{
hcPackagedetailsEntity.Createddate = dataReader["createdDate"].ToString();
}
if (dataReader["updateby"] != DBNull.Value)
{
hcPackagedetailsEntity.Updateby = dataReader["updateby"].ToString();
}
if (dataReader["updateDate"] != DBNull.Value)
{
hcPackagedetailsEntity.Updatedate = dataReader["updateDate"].ToString();
}
if (dataReader["isactive"] != DBNull.Value)
{
hcPackagedetailsEntity.Isactive = dataReader["isactive"].ToString();
}
}
}
return(hcPackagedetailsEntity);
}
