public object UpdateHcProductcategoryInfo(object param)
{
Database db = DatabaseFactory.CreateDatabase();
object retObj = null;
using (DbConnection connection = db.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
HcProductcategoryEntity hcProductcategoryEntity = (HcProductcategoryEntity)param;
HcProductcategoryDAL hcProductcategoryDAL = new HcProductcategoryDAL();
retObj = (object)hcProductcategoryDAL.UpdateHcProductcategoryInfo(hcProductcategoryEntity, db, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
finally
{
connection.Close();
}
}
return(retObj);
}
public HcProductcategoryEntity GetSingleHcProductcategoryRecordById(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = "SELECT ID, categoryName, status FROM HC_ProductCategory WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, param);
HcProductcategoryEntity hcProductcategoryEntity = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
hcProductcategoryEntity = new HcProductcategoryEntity();
if (dataReader["ID"] != DBNull.Value)
{
hcProductcategoryEntity.Id = dataReader["ID"].ToString();
}
if (dataReader["categoryName"] != DBNull.Value)
{
hcProductcategoryEntity.Categoryname = dataReader["categoryName"].ToString();
}
if (dataReader["status"] != DBNull.Value)
{
hcProductcategoryEntity.Status = dataReader["status"].ToString();
}
}
}
return(hcProductcategoryEntity);
}
public DataTable GetAllHcProductcategoryRecord(object param)
{
Database db = DatabaseFactory.CreateDatabase();
string sql = @"SELECT ID, categoryName, status FROM HC_ProductCategory where 1=1";
HcProductcategoryEntity obj = new HcProductcategoryEntity();
if (param != null)
{
obj = (HcProductcategoryEntity)param;
}
if (!string.IsNullOrEmpty(obj.QueryFlag) && obj.QueryFlag == "All")
{
sql += " Order by categoryName Asc";
}
if (!string.IsNullOrEmpty(obj.Id))
{
sql += " And ID = '" + obj.Id + "'";
}
DbCommand dbCommand = db.GetSqlStringCommand(sql);
DataSet ds = db.ExecuteDataSet(dbCommand);
return(ds.Tables[0]);
}
public bool SaveHcProductcategoryInfo(HcProductcategoryEntity hcProductcategoryEntity, Database db, DbTransaction transaction)
{
string sql = "INSERT INTO HC_ProductCategory ( categoryName, status) VALUES ( @Categoryname, @Status )";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Categoryname", DbType.String, hcProductcategoryEntity.Categoryname);
db.AddInParameter(dbCommand, "Status", DbType.String, hcProductcategoryEntity.Status);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}
public bool UpdateHcProductcategoryInfo(HcProductcategoryEntity hcProductcategoryEntity, Database db, DbTransaction transaction)
{
string sql = "UPDATE HC_ProductCategory SET categoryName= @Categoryname, status= @Status WHERE Id=@Id";
DbCommand dbCommand = db.GetSqlStringCommand(sql);
db.AddInParameter(dbCommand, "Id", DbType.String, hcProductcategoryEntity.Id);
db.AddInParameter(dbCommand, "Categoryname", DbType.String, hcProductcategoryEntity.Categoryname);
db.AddInParameter(dbCommand, "Status", DbType.String, hcProductcategoryEntity.Status);
db.ExecuteNonQuery(dbCommand, transaction);
return(true);
}