/// <summary> /// Gets the purchaseorder list. /// </summary> /// <param name="response">The response.</param> /// <returns>PurchaseorderList.</returns> internal static PurchaseorderList getPurchaseorderList(HttpResponseMessage response) { var purchaseorderList = new PurchaseorderList(); var jsonObject = JsonConvert.DeserializeObject <Dictionary <string, object> >(response.Content.ReadAsStringAsync().Result); if (jsonObject.ContainsKey("purchaseorders")) { var purchaseordersArray = JsonConvert.DeserializeObject <List <object> >(jsonObject["purchaseorders"].ToString()); foreach (var purchaseorderObj in purchaseordersArray) { var purchaseorder = new Purchaseorder(); purchaseorder = JsonConvert.DeserializeObject <Purchaseorder>(purchaseorderObj.ToString()); purchaseorderList.Add(purchaseorder); } } if (jsonObject.ContainsKey("page_context")) { var pageContext = new PageContext(); pageContext = JsonConvert.DeserializeObject <PageContext>(jsonObject["page_context"].ToString()); purchaseorderList.page_context = pageContext; } return(purchaseorderList); }
public ActionResult EmployeMobPDF(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Purchaseorder purchaseorder = db.Purchaseorders.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } var allCustomer = db.Purchaseorders.ToList(); var datos = db.Purchaseorders.Include(a => a.Contract).Include(b => b.Contract.Rversion).Include(c => c.Contract.Rversion.Rfq).Include(e => e.Contract.Rversion.Rfq.Farm).Include(f => f.Contract.Rversion.Rfq.Farm.Client).ToList(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(Server.MapPath("~/Reports"), "EmployeeMob3.rpt")); rd.SetDataSource(datos); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/pdf", "Employee Mobilization.pdf")); }
public ActionResult DeleteConfirmed(int id, int contractid) { Purchaseorder purchaseorder = db.Purchaseorders.Find(id); db.Purchaseorders.Remove(purchaseorder); db.SaveChanges(); return(RedirectToAction("Details", "Contracts", new { id = contractid })); }
// GET: Purchaseorders/Create public ActionResult PartialCreate(int contractId) { var model = new Purchaseorder { ContractId = contractId }; ViewBag.ContractId = contractId; return(PartialView()); }
public ActionResult Edit([Bind(Include = "PurchaseOrderId,PO,Commentary,Date,File,ContractId")] Purchaseorder purchaseorder) { if (ModelState.IsValid) { db.Entry(purchaseorder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ContractId = new SelectList(db.Contracts, "ContractId", "OcClient", purchaseorder.ContractId); return(View(purchaseorder)); }
/// <summary> /// Gets the purchaseorder. /// </summary> /// <param name="response">The response.</param> /// <returns>Purchaseorder.</returns> internal static Purchaseorder getPurchaseorder(HttpResponseMessage response) { var purchaseorder = new Purchaseorder(); var jsonObject = JsonConvert.DeserializeObject <Dictionary <string, object> >(response.Content.ReadAsStringAsync().Result); if (jsonObject.ContainsKey("purchaseorder")) { purchaseorder = JsonConvert.DeserializeObject <Purchaseorder>(jsonObject["purchaseorder"].ToString()); } return(purchaseorder); }
// GET: Purchaseorders/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Purchaseorder purchaseorder = db.Purchaseorders.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } return(View(purchaseorder)); }
// GET: Purchaseorders/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Purchaseorder purchaseorder = db.Purchaseorders.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } ViewBag.ContractId = new SelectList(db.Contracts, "ContractId", "OcClient", purchaseorder.ContractId); return(View(purchaseorder)); }
public ActionResult EmployeMob(int?id) { ViewBag.Poid = id; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Purchaseorder purchaseorder = db.Purchaseorders.Find(id); if (purchaseorder == null) { return(HttpNotFound()); } return(View(purchaseorder)); }
/// <summary> /// Updates the specified purchseorder_id. /// </summary> /// <param name="purchseorder_id">The purchseorder_id.</param> /// <param name="update_info">The update_info.</param> /// <param name="parameters">The parameters.</param> /// <returns>Purchaseorder.</returns> public Purchaseorder Update(string purchseorder_id, Purchaseorder update_info, Dictionary <object, object> parameters, string attachment_path) { var url = baseAddress + "/" + purchseorder_id; var json = JsonConvert.SerializeObject(update_info); if (parameters == null) { parameters = new Dictionary <object, object>(); } parameters.Add("JSONString", json); var file = new KeyValuePair <string, string>("attachment", attachment_path); var response = ZohoHttpClient.put(url, getQueryParameters(), parameters, file); return(PurchaseorderParser.getPurchaseorder(response)); }
public ActionResult Create([Bind(Include = "PurchaseOrderId,PO,Commentary,ContractId")] Purchaseorder purchaseorder, HttpPostedFileBase file) { if (ModelState.IsValid && file != null) { var dir = Server.MapPath("~/Documents/PO/" + purchaseorder.ContractId); if (!Directory.Exists(dir)) { Directory.CreateDirectory(dir); } string _FileName = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(dir, _FileName); file.SaveAs(path); purchaseorder.Status = "OPEN"; purchaseorder.Date = DateTime.Now; purchaseorder.File = _FileName; db.Purchaseorders.Add(purchaseorder); AssignmentOfTool ATool = new AssignmentOfTool(); Truck Truck = new Truck(); Shipping Shipping = new Shipping(); ATool.PurchaseOrderId = purchaseorder.PurchaseOrderId; ATool.Cost = 0; Truck.PurchaseOrderId = purchaseorder.PurchaseOrderId; Truck.Status = "PENDING ASSIGNMENT"; Shipping.PurchaseOrderId = purchaseorder.PurchaseOrderId; db.AssignmentOfTools.Add(ATool); db.Trucks.Add(Truck); db.Shippings.Add(Shipping); db.SaveChanges(); return(RedirectToAction("Details", "Contracts", new { id = purchaseorder.ContractId })); } return(RedirectToAction("Details", "Contracts", new { id = purchaseorder.ContractId })); }
/// <summary> /// Creates the specified new_purchaseorder_info. /// </summary> /// <param name="new_purchaseorder_info">The new_purchaseorder_info.</param> /// <param name="parameters">The parameters.</param> /// <returns>Purchaseorder.</returns> public Purchaseorder Create(Purchaseorder new_purchaseorder_info, Dictionary <object, object> parameters, string attachment_Path) { var url = baseAddress; var json = JsonConvert.SerializeObject(new_purchaseorder_info); if (parameters == null) { parameters = new Dictionary <object, object>(); } parameters.Add("JSONString", json); var attachment = new string[] { attachment_Path }; var file = new KeyValuePair <string, string[]>("attachment", attachment); var response = ZohoHttpClient.post(url, getQueryParameters(), parameters, file); return(PurchaseorderParser.getPurchaseorder(response)); }
public async Task <ActionResult <Object> > PostPurchaseorder(Purchaseorder purchaseorder) { var cmd = _context.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "PURCHASE_STOCK"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("PPRODID", purchaseorder.Productid)); cmd.Parameters.Add(new SqlParameter("PLOCID", purchaseorder.Locationid)); cmd.Parameters.Add(new SqlParameter("PQTY", purchaseorder.Quantity)); await cmd.Connection.OpenAsync(); await cmd.ExecuteNonQueryAsync(); await cmd.Connection.CloseAsync(); return(Ok()); }
public ActionResult EmployeMob([Bind(Include = "PurchaseOrderId,Tooling,SpecialtyItems,AirportDestination,DepartureDate,TravelPlans,AirportCargoAddress,AirportCargoContact,LodgingInArea,Notes,ContractId,Commentary")] Purchaseorder POrder) { if (ModelState.IsValid) { Purchaseorder purchaseorder = db.Purchaseorders.Find(POrder.PurchaseOrderId); purchaseorder.Tooling = POrder.Tooling; purchaseorder.SpecialtyItems = POrder.SpecialtyItems; purchaseorder.AirportDestination = POrder.AirportDestination; purchaseorder.DepartureDate = POrder.DepartureDate; purchaseorder.TravelPlans = POrder.TravelPlans; purchaseorder.AirportCargoAddress = POrder.AirportCargoAddress; purchaseorder.AirportCargoContact = POrder.AirportCargoContact; purchaseorder.LodgingInArea = POrder.LodgingInArea; purchaseorder.Notes = POrder.Notes; db.Entry(purchaseorder).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("EmployeMob", "Mobilization", new { id = POrder.PurchaseOrderId })); } return(View(POrder)); }
static void Main(string[] args) { try { var service = new ZohoBooks(); service.initialize("{authtoken}", "{organization id}"); var purchaseordersApi = service.GetPurchaseordersApi(); Console.WriteLine("------------------------All Orders-----------"); var purchaseorders = purchaseordersApi.GetPurchaseorders(null); foreach (var tempOrder in purchaseorders) { Console.WriteLine("order id:{0},vendor name:{1},status:{2}", tempOrder.purchaseorder_id, tempOrder.vendor_name, tempOrder.status); } Console.WriteLine("-------------Specified order-------------------"); var purchaseorder = purchaseordersApi.Get(purchaseorders[0].purchaseorder_id, null); Console.WriteLine("order id:{0},vendor name:{1},status:{2}", purchaseorder.purchaseorder_id, purchaseorder.vendor_name, purchaseorder.status); Console.WriteLine("line items"); var lineitems = purchaseorder.line_items; foreach (var tempitem in lineitems) { Console.WriteLine("item id:{0},description:{1},rate:{2}", tempitem.item_id, tempitem.description, tempitem.rate); } Console.WriteLine("-------------New Purchaseorder--------------------"); var newOrderInfo = new Purchaseorder() { vendor_id = purchaseorder.vendor_id, line_items = new List <LineItem>() { new LineItem() { item_id = lineitems[0].item_id, rate = 250, }, } }; var newPurchaseOrder = purchaseordersApi.Create(newOrderInfo, null, @"C:\Users\hari-2197\Desktop\h.jpg"); Console.WriteLine("order id:{0},vendor name:{1},status:{2},total:{3}", newPurchaseOrder.purchaseorder_id, newPurchaseOrder.vendor_name, newPurchaseOrder.status, newPurchaseOrder.total); Console.WriteLine("line items"); var newOredrlineitems = newPurchaseOrder.line_items; foreach (var tempitem in newOredrlineitems) { Console.WriteLine("item id:{0},description:{1},rate:{2}", tempitem.item_id, tempitem.description, tempitem.rate); } Console.WriteLine("--------------------update order--------------"); var updateInfo = new Purchaseorder() { line_items = new List <LineItem>() { new LineItem() { item_id = lineitems[0].item_id, rate = 300, }, } }; var updatedOrder = purchaseordersApi.Update(newPurchaseOrder.purchaseorder_id, updateInfo, null, null); Console.WriteLine("order id:{0},vendor name:{1},status:{2},total:{3}", updatedOrder.purchaseorder_id, updatedOrder.vendor_name, updatedOrder.status, updatedOrder.total); Console.WriteLine("---------------Delete Order------------------"); var deleteOrder = purchaseordersApi.Delete(updatedOrder.purchaseorder_id); Console.WriteLine(deleteOrder); Console.WriteLine("---------------Mark Order as open------------------"); var markAsOpen = purchaseordersApi.MarkAsOpen(purchaseorders[0].purchaseorder_id); Console.WriteLine(markAsOpen); Console.WriteLine("---------------Mark Order as billed------------------"); var markAsBilled = purchaseordersApi.MarkAsBilled(purchaseorders[0].purchaseorder_id); Console.WriteLine(markAsBilled); Console.WriteLine("---------------Cancel purchaseOrder ------------------"); var cancelOrder = purchaseordersApi.CancelPurchaseorder(purchaseorders[0].purchaseorder_id); Console.WriteLine(cancelOrder); Console.WriteLine("---------------Email Purchase Order------------------"); var emailDetails = new EmailNotification() { to_mail_ids = new List <string>() { "*****@*****.**" }, subject = "test-sub", body = "test-body" }; var emailOrder = purchaseordersApi.SendEmail(purchaseorders[1].purchaseorder_id, emailDetails, null); Console.WriteLine(emailOrder); Console.WriteLine("---------------Email content of Purchase Order------------------"); var emailContent = purchaseordersApi.GetEmailContent(purchaseorders[1].purchaseorder_id, null); Console.WriteLine("Subject:{0},\n Body:{1}", emailContent.subject, emailContent.body); Console.WriteLine("---------------Update Billing Address------------------"); var updateAddressInfo = new Address() { city = "test-city", state = "test-state", }; var updatedAddress = purchaseordersApi.UpdateBillingAddress(purchaseorders[1].purchaseorder_id, updateAddressInfo); Console.WriteLine("city:{0},state:{1}", updatedAddress.city, updatedAddress.state); Console.WriteLine("---------------List and update template------------------"); var templates = purchaseordersApi.GetTemplates(); foreach (var template in templates) { Console.WriteLine("name:{0},type:{1}", template.template_name, template.template_type); } var updateTemplate = purchaseordersApi.UpdateTemplate(purchaseorders[1].purchaseorder_id, templates[0].template_id); Console.WriteLine(updateTemplate); Console.WriteLine("-------------------Attachments----------------"); var getAttachment = purchaseordersApi.GetAttachment(purchaseorders[0].purchaseorder_id, null); Console.WriteLine(getAttachment); var addAttachment = purchaseordersApi.AddAttachment(purchaseorders[2].purchaseorder_id, @"C:\Users\hari-2197\Desktop\h.jpg"); Console.WriteLine(addAttachment); var attachPreferences = new Dictionary <object, object>(); attachPreferences.Add("can_send_in_mail", true); var updateAttachPreference = purchaseordersApi.UpdateAttachmentPreference(purchaseorders[2].purchaseorder_id, attachPreferences); Console.WriteLine(updateAttachPreference); var deleteAttachment = purchaseordersApi.DeleteAnAttachment(purchaseorders[2].purchaseorder_id); Console.WriteLine(deleteAttachment); Console.WriteLine("--------------------------Comments -----------------------"); var comments = purchaseordersApi.GetComments(purchaseorders[0].purchaseorder_id); foreach (var comment in comments) { Console.WriteLine("comment id:{0},description:{1},commented by:{2}", comment.comment_id, comment.description, comment.commented_by); } var newCommentInfo = new Comment() { description = "test comment", }; var newComment = purchaseordersApi.AddComment(purchaseorders[0].purchaseorder_id, newCommentInfo); Console.WriteLine("comment id:{0},description:{1},commented by:{2}", newComment.comment_id, newComment.description, newComment.commented_by); var commentUpdateInfo = new Comment() { description = "updated for test", }; var updatedComment = purchaseordersApi.UpdateComment(purchaseorders[0].purchaseorder_id, newComment.comment_id, commentUpdateInfo); Console.WriteLine("comment id:{0},description:{1},commented by:{2}", updatedComment.comment_id, updatedComment.description, updatedComment.commented_by); var deleteComment = purchaseordersApi.DeleteComment(purchaseorders[0].purchaseorder_id, updatedComment.comment_id); Console.WriteLine(deleteComment); } catch (Exception e) { Console.WriteLine(e.Message); } Console.ReadKey(); }