public ActionResult AddSave(DictObject dict) { try { db.Add(dict); return RedirectToAction("Index"); } catch { return View(); } }
public ActionResult DeleteSave(DictObject dict) { try { db.Delete(dict.Id); return RedirectToAction("Index"); } catch { return View(); } }
public ActionResult UpdateSave(DictObject dict) { try { db.Update(dict); return(RedirectToAction("Index")); } catch { return(View()); } }
public void SaveKnowledge(SantoriniQLearn ql) { System.Xml.Serialization.XmlSerializer writer = new System.Xml.Serialization.XmlSerializer(typeof(SaveItem)); List <DictObject> dd = new List <DictObject>(); foreach (var item in ql.Policies) { DictObject d = new DictObject(item.Key, item.Value); dd.Add(d); } SaveItem s = new SaveItem(dd); var path = "../../save" + ".xml"; System.IO.FileStream file = System.IO.File.Create(path); writer.Serialize(file, s); file.Close(); }
// POST: api/TS public void Post([FromBody] DictObject value) { value.Id = context.GetAll().Last().Id + 1; context.Add(value); }
public bool GenerateReport(DictObject dictObject) { try { string wordValue; if (Session["_wordString"] == null) { wordValue = "N/A"; } wordValue = (string)Session["_wordString"]; if (string.IsNullOrEmpty(wordValue)) { wordValue = "N/A"; } var dataTable = new DataTable("TransactionPayment"); dataTable.Columns.Add(new DataColumn("TransactionTitle", typeof(string))); dataTable.Columns.Add(new DataColumn("PaidBy", typeof(string))); dataTable.Columns.Add(new DataColumn("RequestedBy", typeof(string))); dataTable.Columns.Add(new DataColumn("ChequeNo", typeof(string))); dataTable.Columns.Add(new DataColumn("ReceivedBy", typeof(string))); dataTable.Columns.Add(new DataColumn("AmountPaid", typeof(string))); dataTable.Columns.Add(new DataColumn("TotalApprovedAmount", typeof(string))); dataTable.Columns.Add(new DataColumn("Approver", typeof(string))); dataTable.Columns.Add(new DataColumn("DatePaid", typeof(string))); dataTable.Columns.Add(new DataColumn("PaymentMode", typeof(string))); dataTable.Columns.Add(new DataColumn("PcvNo", typeof(string))); dataTable.Columns.Add(new DataColumn("AmountInWords", typeof(string))); DataRow dr = dataTable.NewRow(); dr["TransactionTitle"] = dictObject.TransactionTitle; dr["PaidBy"] = dictObject.PaidBy; dr["RequestedBy"] = dictObject.RequestedBy; dr["ChequeNo"] = dictObject.ChequeNo; dr["ReceivedBy"] = dictObject.ReceivedBy; dr["AmountPaid"] = string.Format("{0}{1}", "N", NumberMap.GroupToDigits(dictObject.AmmountPaid.ToString(CultureInfo.InvariantCulture))); dr["TotalApprovedAmount"] = string.Format("{0}{1}", "N", NumberMap.GroupToDigits(dictObject.TotalApprovedAmmount.ToString(CultureInfo.InvariantCulture))); dr["Approver"] = dictObject.Approver; dr["DatePaid"] = dictObject.DatePaid; dr["PcvNo"] = dictObject.PcvNo; dr["AmountInWords"] = wordValue; dataTable.Rows.Add(dr); //NumbersToWord(double s, string naira, string kobo) var dataTable2 = new DataTable("TransactionItem"); dataTable2.Columns.Add(new DataColumn("ItemCode", typeof(string))); dataTable2.Columns.Add(new DataColumn("ItemName", typeof(string))); dataTable2.Columns.Add(new DataColumn("DetailDesription", typeof(string))); dataTable2.Columns.Add(new DataColumn("ApprovedQuantity", typeof(string))); dataTable2.Columns.Add(new DataColumn("ApprovedUnitPrice", typeof(string))); dataTable2.Columns.Add(new DataColumn("ApprovedTotalPrice", typeof(string))); foreach (var transactionItem in dictObject.TransactionItems) { var dr2 = dataTable2.NewRow(); dr2["ItemCode"] = transactionItem.ExpenseItem.Code; dr2["ItemName"] = transactionItem.ExpenseItem.Title; dr2["DetailDesription"] = transactionItem.Description; dr2["ApprovedQuantity"] = transactionItem.ApprovedQuantity; dr2["ApprovedUnitPrice"] = NumberMap.GroupToDigits(transactionItem.ApprovedUnitPrice.ToString(CultureInfo.InvariantCulture)); dr2["ApprovedTotalPrice"] = NumberMap.GroupToDigits(transactionItem.ApprovedTotalPrice.ToString(CultureInfo.InvariantCulture)); dataTable2.Rows.Add(dr2); } const XplugDepartments lrGlobal = XplugDepartments.LrGlobal; var y = (int)Enum.Parse(typeof(XplugDepartments), Enum.GetName(typeof(XplugDepartments), lrGlobal)); const XplugDepartments xPlug = XplugDepartments.XPlug; var x = (int)Enum.Parse(typeof(XplugDepartments), Enum.GetName(typeof(XplugDepartments), xPlug)); var repFilePath = ""; if (dictObject.DepartmentId == x) { repFilePath = Server.MapPath("~/ExpenseMgt/Reports/ReportFiles/xPlugVoucher.rpt"); } if (dictObject.DepartmentId == y) { repFilePath = Server.MapPath("~/ExpenseMgt/Reports/ReportFiles/LRVoucher.rpt"); } if (dictObject.DepartmentId != x && dictObject.DepartmentId != y) { repFilePath = Server.MapPath("~/ExpenseMgt/Reports/ReportFiles/xPlugVoucher.rpt"); } var pdfPath = Session.SessionID + DateTime.Now.Millisecond.ToString(CultureInfo.InvariantCulture) + Environment.TickCount.ToString(CultureInfo.InvariantCulture) + ".pdf"; var path = Server.MapPath("~/GeneratedDocuments/"); pdfPath = path + pdfPath; var repDoc = new ReportDocument(); repDoc.Load(repFilePath); repDoc.Database.Tables[0].SetDataSource(dataTable2); repDoc.Database.Tables[1].SetDataSource(dataTable); var crDiskFileDestinationOptions = new DiskFileDestinationOptions(); var crFormatTypeOptions = new PdfRtfWordFormatOptions(); crDiskFileDestinationOptions.DiskFileName = pdfPath; var crExportOptions = repDoc.ExportOptions; { crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; crExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; crExportOptions.DestinationOptions = crDiskFileDestinationOptions; crExportOptions.FormatOptions = crFormatTypeOptions; } repDoc.Export(); Session["myPDF.InvoicePath"] = pdfPath; Context.Response.Buffer = false; var buffer = new byte[1024]; FileStream inStr = File.OpenRead(pdfPath); while ((inStr.Read(buffer, 0, buffer.Length)) > 0) { if (Context.Response.IsClientConnected) { Response.Clear(); //Response.AddHeader("Accept-Header", buffer.Length.ToString()); Response.ContentType = "application/pdf"; Context.Response.OutputStream.Write(buffer, 0, buffer.Length); Context.Response.Flush(); } } return(true); } catch (Exception ex) { ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message); return(false); } }
// PUT: api/TS/ public void Put([FromBody] DictObject value) { context.Update(value); }