private SyncToDepartmentObject GetSyncData(SyncToDepartmentObject syncToDept)
{
PosDatabase database = PosDatabase.Instance;
syncToDept.StockDefinitionStatus = database.ExecuteQueryAll("CRL_STK_DEF_STAT");
string paramMark = "";
IDbParameters dbParameters = database.AdoTemplate.CreateDbParameters();
dbParameters.Add("CREATE_DATE", MySqlDbType.DateTime).Value = DateTime.MinValue;
if (syncToDept.DepartmentInfo)
{
IDbParametersBuilder builder = new DbParametersBuilder(database.DbProvider);
//builder.Create().Name("update_date").Type(DbType.DateTime).Value(syncToDept.LastSyncTime);
syncToDept.DepartmentList = database.ExecuteQueryAll("CRL_DEPT");
}
if (syncToDept.ProductMasterInfo)
{
syncToDept.ProductType = database.ExecuteQueryAll("CRL_PRD_TYP");
syncToDept.Category = database.ExecuteQueryAll("CRL_CAT");
syncToDept.ProductMaster = database.ExecuteQueryAll("CRL_PRD_MST");
syncToDept.ProductColor = database.ExecuteQueryAll("CRL_EX_PRD_COLOR");
syncToDept.ProductSize = database.ExecuteQueryAll("CRL_EX_PRD_SIZE");
syncToDept.Product = database.ExecuteQueryAll("CRL_PRD");
syncToDept.Prices = database.ExecuteQueryAll("CRL_MN_PRICE");
}
else
{
if (syncToDept.PriceInfo)
{
syncToDept.Prices = database.ExecuteQueryAll("CRL_MN_PRICE");
}
}
string whereQuery = " CREATE_DATE>@CREATE_DATE";
syncToDept.StockOut = database.ExecuteQueryAll("CRL_STK_OUT", whereQuery, dbParameters);
syncToDept.StockOutDetail = database.ExecuteQueryAll("CRL_STK_OUT_DET", whereQuery,dbParameters);
#region Useless
/*if (syncToDept.DepartmentInfo)
{
ObjectCriteria<Department> deptCrit = new ObjectCriteria<Department>();
deptCrit.Add(dpm => dpm.DepartmentId == syncToDept.Department.DepartmentId);
syncToDept.Department = (Department)DepartmentDao.FindFirst(deptCrit);
}
if (syncToDept.ProductMasterInfo)
{
ProductDao.Execute(delegate(ISession session)
{
string hql = "from ProductMaster fetch all properties";
IQuery query = session.CreateQuery(hql);
syncToDept.ProductMasterList = query.List<ProductMaster>();
return null;
})
;
syncToDept.ProductMasterList = ProductMasterDao.FindAll(new LinqCriteria<ProductMaster>());
foreach (ProductMaster product in syncToDept.ProductMasterList)
{
ProductMasterDao.Fetch(product);
}
syncToDept.PriceList = MainPriceDao.FindAll(new LinqCriteria<MainPrice>());
foreach (MainPrice mainPrice in syncToDept.PriceList)
{
MainPriceDao.Fetch(mainPrice);
}
}
else
{
if (syncToDept.PriceInfo)
{
syncToDept.PriceList = MainPriceDao.FindAll(new LinqCriteria<MainPrice>());
}
}
LinqCriteria<StockOut> stockOutCrit = new LinqCriteria<StockOut>();
stockOutCrit.AddCriteria(so => so.CreateDate > DateTime.Now.Subtract(new TimeSpan(3, 0, 0, 0)));
stockOutCrit.AddCriteria(so => so.Department.DepartmentId == syncToDept.Department.DepartmentId);
stockOutCrit.Fetch(so => so.StockOutDetails);
IList<StockOut> stockOuts = StockOutDao.FindAll(stockOutCrit);
foreach (StockOut stockOut in stockOuts)
{
StockOutDao.Fetch(stockOut);
}
syncToDept.StockOutList = stockOuts; */
#endregion
return syncToDept;
}
public void UpdateDataTable(DataTable dataTable)
{
IDbParametersBuilder builder = new DbParametersBuilder(DbProvider);
foreach (DataRow dataRow in dataTable.Rows)
{
Console.WriteLine(dataRow.ItemArray.ToString());
Console.WriteLine(dataRow.RowState.ToString());
}
AdoTemplate.DataTableUpdateWithCommandBuilder(dataTable, CommandType.Text, "SELECT * FROM " + dataTable.TableName,
builder.GetParameters(), dataTable.TableName);
}
public void FastUpdateDataTable(DataTable dataTable,string tableName)
{
DataTable current = ExecuteQueryAll(tableName);
current.TableName = tableName;
ReflectUpdateTable(current, dataTable);
IDbParametersBuilder builder = new DbParametersBuilder(DbProvider);
AdoTemplate.DataTableUpdateWithCommandBuilder(current.GetChanges(), CommandType.Text, "SELECT * FROM " + current.TableName,
builder.GetParameters(), current.TableName);
// submit changes
//Flush the session to execute sql in the db.
SessionFactoryUtils.GetSession(SessionFactory, true).Flush();
}
public void UpdateDataTable(DataTable source,DataTable changes)
{
IDbParametersBuilder builder = new DbParametersBuilder(DbProvider);
source.Merge(changes);
AdoTemplate.DataTableUpdateWithCommandBuilder(source, CommandType.Text, "SELECT * FROM " + source.TableName,
builder.GetParameters(), source.TableName);
}
public FlightCollection GetFlights(Airport origin, Airport destination, DateTime departureDate)
{
#region Sanity Checks
AssertUtils.ArgumentNotNull(origin, "origin");
AssertUtils.ArgumentNotNull(destination, "destination");
#endregion
FlightCollection flights = new FlightCollection();
IDbParametersBuilder builder = new DbParametersBuilder(DbProvider);
builder.Create().Name("departureDate").Type(DbType.Date).Value(departureDate);
builder.Create().Name("departureAirport").Type(DbType.Int32).Value(origin.Id);
builder.Create().Name("destinationAirport").Type(DbType.Int32).Value(destination.Id);
#if NET_2_0
AdoTemplate.QueryWithRowCallbackDelegate(CommandType.Text, FlightsQuery,
delegate(IDataReader dataReader)
{
int flightId = dataReader.GetInt32(0);
string flightNumber = dataReader.GetString(1);
Aircraft aircraft = aircraftDao.GetAircraft(dataReader.GetInt32(2));
//TODO: Load cabins from the database
Cabin[] cabins = aircraft.Cabins;
Flight flight = new Flight(flightId, flightNumber, origin, destination, aircraft, departureDate, cabins);
flights.Add(flight);
},
builder.GetParameters());
#else
AdoTemplate.QueryWithRowCallback(CommandType.Text, FlightsQuery,
new FlightRowCallback(flights, aircraftDao, origin,destination,departureDate ),
builder.GetParameters());
#endif
/*
IDbCommand command = GetCommand(FlightsQuery);
using(new ConnectionManager(command.Connection))
{
SetFlightQueryParameters(command, departureDate, origin.Id, destination.Id);
using (SqlDataReader reader = (SqlDataReader) command.ExecuteReader())
{
while(reader.Read())
{
int flightId = reader.GetInt32(0);
string flightNumber = reader.GetString(1);
Aircraft aircraft = aircraftDao.GetAircraft(reader.GetInt32(2));
//TODO: Load cabins from the database
Cabin[] cabins = aircraft.Cabins;
Flight flight = new Flight(flightId, flightNumber, origin, destination, aircraft, departureDate, cabins);
flights.Add(flight);
}
}
}
*/
return flights;
}