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