public object UpdateHcOffersInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcOffersEntity hcOffersEntity = (HcOffersEntity)param;
HcOffersDAL hcOffersDAL = new HcOffersDAL();
retObj = (object)hcOffersDAL.UpdateHcOffersInfo(hcOffersEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public HcOffersEntity GetSingleHcOffersRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT Id, OfferTitle, OfferOn, OfferProduct, isActive, CreatedBy, CreatedDate, UpdateBy, UpdateDate FROM HC_Offers WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcOffersEntity hcOffersEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcOffersEntity = new HcOffersEntity();
if (dataReader["Id"] != DBNull.Value)
{
hcOffersEntity.Id = dataReader["Id"].ToString();
}
if (dataReader["OfferTitle"] != DBNull.Value)
{
hcOffersEntity.Offertitle = dataReader["OfferTitle"].ToString();
}
if (dataReader["OfferOn"] != DBNull.Value)
{
hcOffersEntity.Offeron = dataReader["OfferOn"].ToString();
}
if (dataReader["OfferProduct"] != DBNull.Value)
{
hcOffersEntity.Offerproduct = dataReader["OfferProduct"].ToString();
}
if (dataReader["isActive"] != DBNull.Value)
{
hcOffersEntity.Isactive = dataReader["isActive"].ToString();
}
if (dataReader["CreatedBy"] != DBNull.Value)
{
hcOffersEntity.Createdby = dataReader["CreatedBy"].ToString();
}
if (dataReader["CreatedDate"] != DBNull.Value)
{
hcOffersEntity.Createddate = dataReader["CreatedDate"].ToString();
}
if (dataReader["UpdateBy"] != DBNull.Value)
{
hcOffersEntity.Updateby = dataReader["UpdateBy"].ToString();
}
if (dataReader["UpdateDate"] != DBNull.Value)
{
hcOffersEntity.Updatedate = dataReader["UpdateDate"].ToString();
}
}
}
return(hcOffersEntity);
}
public bool UpdateHcOffersInfo(HcOffersEntity hcOffersEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_Offers SET OfferTitle= @Offertitle, OfferOn= @Offeron, OfferProduct= @Offerproduct, isActive= @Isactive, CreatedBy= @Createdby, CreatedDate= @Createddate, UpdateBy= @Updateby, UpdateDate= @Updatedate WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcOffersEntity.Id);
db.AddInParameter(dbCommand, "Offertitle", DbType.String, hcOffersEntity.Offertitle);
db.AddInParameter(dbCommand, "Offeron", DbType.String, hcOffersEntity.Offeron);
db.AddInParameter(dbCommand, "Offerproduct", DbType.String, hcOffersEntity.Offerproduct);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcOffersEntity.Isactive);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcOffersEntity.Createdby);
db.AddInParameter(dbCommand, "Createddate", DbType.String, hcOffersEntity.Createddate);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcOffersEntity.Updateby);
db.AddInParameter(dbCommand, "Updatedate", DbType.String, hcOffersEntity.Updatedate);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public bool SaveHcOffersInfo(HcOffersEntity hcOffersEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_Offers ( Id, OfferTitle, OfferOn, OfferProduct, isActive, CreatedBy, CreatedDate, UpdateBy, UpdateDate) VALUES ( @Id, @Offertitle, @Offeron, @Offerproduct, @Isactive, @Createdby, @Createddate, @Updateby, @Updatedate )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcOffersEntity.Id);
db.AddInParameter(dbCommand, "Offertitle", DbType.String, hcOffersEntity.Offertitle);
db.AddInParameter(dbCommand, "Offeron", DbType.String, hcOffersEntity.Offeron);
db.AddInParameter(dbCommand, "Offerproduct", DbType.String, hcOffersEntity.Offerproduct);
db.AddInParameter(dbCommand, "Isactive", DbType.String, hcOffersEntity.Isactive);
db.AddInParameter(dbCommand, "Createdby", DbType.String, hcOffersEntity.Createdby);
db.AddInParameter(dbCommand, "Createddate", DbType.String, hcOffersEntity.Createddate);
db.AddInParameter(dbCommand, "Updateby", DbType.String, hcOffersEntity.Updateby);
db.AddInParameter(dbCommand, "Updatedate", DbType.String, hcOffersEntity.Updatedate);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
