/// <summary> /// Get one row from CustomClearanceView /// </summary> /// <param name="id">Custom Clearance Id</param> /// <returns>CustomClearanceView object</returns> internal static CustomClearanceView GetOneCustClearView(int ccId) { OperationsEntities db = new OperationsEntities(); CustomClearanceView custClearObj = db.CustomClearanceViews.Where(x => x.CCId == ccId).FirstOrDefault(); return(custClearObj); }
/// <summary> /// Get all custom clearance orders for grid /// </summary> /// <param name="form"></param> /// <returns></returns> internal static JObject GetCCAllOrders(FormCollection form) { OperationsEntities db = new OperationsEntities(); List <CustomClearanceView> operationList = new List <CustomClearanceView>(); CustomClearanceView oprObj = new CustomClearanceView(); if (form.Count > 0) { string where = CommonHelper.AdvancedSearch <CustomClearanceView>(form, oprObj); operationList = db.CustomClearanceViews.Where(where.ToString()).ToList(); } else { operationList = db.CustomClearanceViews .Where(x => x.StatusId == 1 || x.StatusId == 2) .OrderByDescending(x => x.CreateDate).ToList(); } operationList = operationList.OrderByDescending(x => x.CreateDate).ToList(); JTokenWriter pJTokenWriter = new JTokenWriter(); JObject ordersJson = new JObject(); pJTokenWriter.WriteStartObject(); pJTokenWriter.WritePropertyName("data"); pJTokenWriter.WriteStartArray(); foreach (var item in operationList) { pJTokenWriter.WriteStartObject(); pJTokenWriter.WritePropertyName("CCId"); pJTokenWriter.WriteValue(item.CCId); pJTokenWriter.WritePropertyName("OperationId"); pJTokenWriter.WriteValue(item.OperationId); pJTokenWriter.WritePropertyName("CarrierTypeImg"); switch (item.CarrierType) { case 1: pJTokenWriter.WriteValue("<i class='fa fa-ship'></i>"); break; case 2: pJTokenWriter.WriteValue("<i class='fa fa-plane'></i>"); break; } switch (item.OrderFrom) { case 1: pJTokenWriter.WritePropertyName("OrderFromImg"); pJTokenWriter.WriteValue("<i class='fa fa-level-up'></i>"); pJTokenWriter.WritePropertyName("Client"); pJTokenWriter.WriteValue(item.ShipperNameEn); pJTokenWriter.WritePropertyName("Port"); pJTokenWriter.WriteValue(item.FromPort); break; case 2: pJTokenWriter.WritePropertyName("OrderFromImg"); pJTokenWriter.WriteValue("<i class='fa fa-level-down'></i>"); pJTokenWriter.WritePropertyName("Client"); pJTokenWriter.WriteValue(item.ConsigneeNameEn); pJTokenWriter.WritePropertyName("Port"); pJTokenWriter.WriteValue(item.ToPort); break; } pJTokenWriter.WritePropertyName("CarrierType"); pJTokenWriter.WriteValue(item.CarrierType); pJTokenWriter.WritePropertyName("MBL"); pJTokenWriter.WriteValue(item.MBL); pJTokenWriter.WritePropertyName("OperationCode"); pJTokenWriter.WriteValue(item.OperationCode); pJTokenWriter.WritePropertyName("BookingNumber"); pJTokenWriter.WriteValue(item.BookingNumber); pJTokenWriter.WritePropertyName("NeedArrive"); pJTokenWriter.WriteValue(item.NeedArriveDate.ToString("dd/MM/yyyy") + " " + item.NeedArriveTime.ToString(@"h\:mm")); pJTokenWriter.WritePropertyName("StatusName"); pJTokenWriter.WriteValue(item.StatusName); pJTokenWriter.WriteEndObject(); } pJTokenWriter.WriteEndArray(); pJTokenWriter.WriteEndObject(); ordersJson = (JObject)pJTokenWriter.Token; return(ordersJson); }