/// <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();
}
