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