public void DeleteCommodityType(CommodityType commodityType) { using (ISession session = HibernateProvider.Factory.OpenSession()) { session.Delete(commodityType); session.Flush(); } }
public void InsertCommodityType(CommodityType commodityType) { using (ISession session = HibernateProvider.Factory.OpenSession()) { session.SaveOrUpdate(commodityType); session.Flush(); } }
public int DeleteCommodityType(CommodityType comm) { int result = 0; /* TODO:this string sqlQuery = "DELETE FROM Commodities WHERE InventoryID = " + comm.InventoryID; try { OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection); result = sqlCommand.ExecuteNonQuery(); } catch (Exception e) { //TODO: how to handle this? } */ return result; }
public int UpdateCommodityType(CommodityType comm) { int result = 0; /* TODO:THIS string sqlQuery = "UPDATE Commodities SET "; StringBuilder sbColValues = new StringBuilder(); StringBuilder sbWhereClause = new StringBuilder(); foreach (KeyValuePair<int, object> columnValue in comm.GetColumnValues()) { ColumnDefinition columnDef = null; foreach (ColumnDefinition colDef in comm.ColumnDefs()) { if (colDef.ColumnIndex == columnValue.Key) { columnDef = colDef; break; } } if (columnDef == null) { //TODO: LOG THIS! return result; } if (!columnDef.ColumnName.Equals("InventoryID")) { if (sbColValues.Length > 0) { sbColValues.Append(", "); } sbColValues.Append(columnDef.ColumnName + " = " + comm.GetInsertableValue(columnDef)); } else { sbWhereClause.Append(" WHERE " + columnDef.ColumnName + " = " + comm.GetInsertableValue(columnDef)); } } if (sbColValues.Length > 0 && sbWhereClause.Length > 0) { try { sqlQuery += sbColValues.ToString() + sbWhereClause.ToString(); OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection); result = sqlCommand.ExecuteNonQuery(); } catch (Exception e) { //TODO: how to handle this? } } */ return result; }
public List<CommodityType> LoadCommodityTypes(string whereClause) { List<CommodityType> commodityTypeList = new List<CommodityType>(); string sqlQuery = "SELECT * FROM " + CommodityType._tableName; sqlQuery += ((whereClause != null && whereClause.Length > 0) ? " WHERE " + whereClause : ""); try { OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection); OleDbDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { CommodityType newComm = new CommodityType(); newComm.Load(reader); commodityTypeList.Add(newComm); } } catch (Exception e) { } return commodityTypeList; }
public bool InsertCommodityType(ref CommodityType comm) { bool retVal = false; /* TODO:THIS string sqlQuery = "INSERT INTO Commodities ("; StringBuilder sbColDefs = new StringBuilder(); StringBuilder sbColValues = new StringBuilder(); foreach (ColumnDefinition columnDef in comm.ColumnDefs()) { if (!columnDef.ColumnName.Equals("InventoryID")) { if (sbColDefs.Length > 0) { sbColDefs.Append(", "); sbColValues.Append(", "); } sbColDefs.Append(columnDef.ColumnName); sbColValues.Append(comm.GetInsertableValue(columnDef)); } } sqlQuery += sbColDefs.ToString() + ") VALUES (" + sbColValues.ToString() + ")"; try { OleDbCommand sqlCommand = new OleDbCommand(sqlQuery, _accessConnection); int result = sqlCommand.ExecuteNonQuery(); if (result == 1) { OleDbCommand identityCommand = new OleDbCommand("SELECT @@IDENTITY", _accessConnection); int newMaxNumKey = (int)identityCommand.ExecuteScalar(); comm.InventoryID = newMaxNumKey; retVal = true; } } catch (Exception e) { //TODO: how to handle this? } */ return retVal; }
/// <summary> /// Create a new CommodityType object. /// </summary> /// <param name="typeID">Initial value of the TypeID property.</param> /// <param name="typeCode">Initial value of the TypeCode property.</param> /// <param name="description">Initial value of the Description property.</param> public static CommodityType CreateCommodityType(global::System.Int32 typeID, global::System.String typeCode, global::System.String description) { CommodityType commodityType = new CommodityType(); commodityType.TypeID = typeID; commodityType.TypeCode = typeCode; commodityType.Description = description; return commodityType; }
/// <summary> /// Deprecated Method for adding a new object to the CommodityTypes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToCommodityTypes(CommodityType commodityType) { base.AddObject("CommodityTypes", commodityType); }