// POST api/inventory //public HttpResponseMessage Post(List<order> ords) public events Post(events evt) { //DetailsRepository.saveAll(ords); DetailsRepository.saveAll(evt); var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (session.BeginTransaction()) { evt = session.Load<events>(evt.id); IList<order> ord = evt.orderList.ToList(); foreach (order o in ord) { o.orderEvent = null; } } } return evt; //string msg = "Items updated"; //var response = Request.CreateResponse(HttpStatusCode.Created, evt); //string url = Url.Link("DefaultApi", new { evt.id }); //response.Headers.Location = new Uri(url); //return response; }
public static string loadlistEvent(events evt) { System.Text.StringBuilder SB = new System.Text.StringBuilder(); SB.Append("select "); SB.Append(" [order].truck, events.eventName, events.eventDate, [order].checkOut, [order].available As Avl "); SB.Append(" , bom.component, sum(bom.qty * [order].orderQty) As LoadQty "); SB.Append(" from events "); SB.Append(" inner join [order] on [order].orderEvent_id = events.id "); SB.Append(" inner join bom on bom.item = [order].item "); //SB.Append(string.Format(" where truck = '{0}' ", Truck)); SB.Append(string.Format(" where events.id = {0} ", evt.id)); SB.Append(" group by [order].truck, events.eventName, events.eventDate, [order].checkout, [order].available "); SB.Append(" , bom.component"); return(SB.ToString()); }
public static string loadlistEvent(events evt) { System.Text.StringBuilder SB = new System.Text.StringBuilder(); SB.Append("select "); SB.Append(" [order].truck, events.eventName, events.eventDate, [order].checkOut, [order].available As Avl "); SB.Append(" , bom.component, sum(bom.qty * [order].orderQty) As LoadQty "); SB.Append(" from events "); SB.Append(" inner join [order] on [order].orderEvent_id = events.id "); SB.Append(" inner join bom on bom.item = [order].item "); //SB.Append(string.Format(" where truck = '{0}' ", Truck)); SB.Append(string.Format(" where events.id = {0} ", evt.id)); SB.Append(" group by [order].truck, events.eventName, events.eventDate, [order].checkout, [order].available "); SB.Append(" , bom.component"); return SB.ToString(); }
public static IList<loadlist> GetLoadList(events evt) { SQLiteCommand cmd = new SQLiteCommand(new SQLiteConnection()); cmd.Connection.ConnectionString = string.Format("data source={0}", FluentNHibernate.DbFile); cmd.CommandText = sql.loadlistEvent(evt); cmd.Connection.Open(); SQLiteDataReader rdr = cmd.ExecuteReader(); IList<loadlist> loadList = new List<loadlist>(); while (rdr.Read()) { loadList.Add( new loadlist { Avl = Convert.ToInt64(rdr["Avl"].ToString()) , component = rdr["component"].ToString() , checkOut = Convert.ToDateTime(rdr["checkOut"].ToString()) , eventDate = Convert.ToDateTime(rdr["eventDate"].ToString()) , eventName = rdr["eventName"].ToString() , LoadQty = Convert.ToInt64(rdr["LoadQty"].ToString()) , truck = rdr["truck"].ToString() }); } return loadList; }
public IList<loadlist> Post(events evt) { return LoadListRepository.GetLoadList(evt); }
internal static void Save(events eventOrder) { // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(eventOrder); transaction.Commit(); } } }
internal static void InsertEvent(ref events Event) { // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (var transaction = session.BeginTransaction()) { session.SaveOrUpdate(Event); transaction.Commit(); //Event.id = myEvent.id; } } }
public static void saveAll(events evt) { // create our NHibernate session factory var sessionFactory = FluentNHibernate.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { // retreive all stores and display them using (session.BeginTransaction()) { foreach (order o in evt.orderList) { o.checkin = evt.checkIn; o.checkout = evt.checkOut; o.orderEvent = evt; } session.SaveOrUpdate(evt); /* foreach (order ord in ords) { session.Update(ord); } */ session.Transaction.Commit(); InventoryAvailability.Set(evt.id); } } }
// POST api/student public HttpResponseMessage Post(events Event) { string msg = ""; if (Event.eventDate > Event.checkIn) { msg = "Check In: " + Event.checkIn.ToShortDateString() + " before event Date: " + Event.eventDate.ToShortDateString() + "?"; } else if (Event.checkOut > Event.eventDate) { msg = "Check Out: " + Event.checkOut.ToShortDateString() + " after event Date: " + Event.eventDate.ToShortDateString() + "?"; } if (msg.Length > 0) { var response = Request.CreateResponse(HttpStatusCode.InternalServerError, msg); string url = Url.Link("DefaultApi", new { msg }); response.Headers.Location = new Uri(url); return response; } else { EventsRepository.InsertEvent(ref Event); var response = Request.CreateResponse(HttpStatusCode.Created, Event); string url = Url.Link("DefaultApi", new { Event.id }); response.Headers.Location = new Uri(url); return response; } }