public JsonResult GetIDFDraftList() { try { object output = PatentService.GetIDFDraftDetails(User.Identity.Name); return(Json(output, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult IDFReport() { long fno = Convert.ToInt64(TempData["FileNo"]); List <IDFRequestReport> model = new List <IDFRequestReport>(); ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("~/Report/IDFRequestrpt.rpt")); //ConnectionInfo connectInfo = new ConnectionInfo() //{ // ServerName = strServer, // DatabaseName = strDatabase, // UserID = strUserID, // Password = strPwd //}; //rpt.SetDatabaseLogon(strUserID, strPwd); //foreach (Table tbl in rpt.Database.Tables) //{ // tbl.LogOnInfo.ConnectionInfo = connectInfo; // tbl.ApplyLogOnInfo(tbl.LogOnInfo); //} //rpt.FileName = Server.MapPath("~/Report/IDFRequestrpt.rpt"); //string conn = "PatentIS"; //for (int i = 0; i < rpt.DataSourceConnections.Count; i++) // //rpt.DataSourceConnections[i].SetConnection("10.18.0.7", conn, "sa", "ICSR@123#"); // rpt.DataSourceConnections[i].SetConnection(strServer, strDatabase, strUserID, strPwd); model = PatentService.GenerateIDFReport(fno); if (model.Count > 0) { rpt.SetDataSource(model); Stream stream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, SeekOrigin.Begin); Response.AddHeader("Content-Disposition", "inline; filename=IDFRequest.pdf"); return(File(stream, "application/pdf")); } else { return(RedirectToAction("IDFReport", new { message = "No records found for this type of search entry" })); } }
public ActionResult IDFRequest(Int64 ReqNo = 0, string dno = null) { IDFRequestVM model = new IDFRequestVM(); ViewBag.Idftype = PatentIS.IDFTypeList(); ViewBag.pitype = PatentIS.GetPatentInventorType(); ViewBag.dept = PatentIS.DepartmentList(); model.Annex.ListIndustry = PatentIS.IndustryList(); model.Annex.ListIndustry1 = PatentIS.IndustryList1(); model.Annex.IITMode = PatentIS.CommericaliseMode(); model.Annex.JointMode = PatentIS.CommericaliseMode1(); ViewBag.CRCat = PatentIS.CRCategory(); ViewBag.Nature = PatentIS.CRNature(); ViewBag.CRClass = PatentIS.CRClass(); model.DesignClass.ClassList = PatentIS.DPClass(); if (dno == null) { if (ReqNo == 0) { var seqno = Convert.ToInt64(PatentIS.GetNewFileNo()); if (seqno > 0) { seqno += 1; model.FileNo = seqno; model.formUpdate = false; } } else { bool isOpen = PatentService.VerifyOpenStatus(ReqNo); if (isOpen) { model.FileNo = ReqNo; model = PatentService.EditIDFRequest(model); } else { TempData["FileNo"] = ReqNo; return(RedirectToAction("IDFReport")); } } } else { var seqno = Convert.ToInt64(PatentIS.GetNewFileNo()); if (seqno > 0) { seqno += 1; model.FileNo = seqno; } model.DraftNo = dno; model = PatentService.EditDraft(model); } model.ListAction = PatentIS.ActionList(); model.TMListAction = PatentIS.TMActionList(); model.CRListAction = PatentIS.CRActionList(); model.DPListAction = PatentIS.DesignActionList(); model.Annex.ListStage = PatentIS.StageList(); model.Trade.Catlist = PatentIS.TMCategory(); if (model.IDFType != "DesignPatent") { model.DesignClass.ClassList = PatentIS.DPClass(); } return(View(model)); }
public JsonResult DeleteDraft(string dno) { bool draft = PatentService.DeleteDraft(dno); return(Json(draft, JsonRequestBehavior.AllowGet)); }
public ActionResult IDFRequest(IDFRequestVM idf, HttpPostedFileBase[] file) { IDFRequestVM model = new IDFRequestVM(); ViewBag.Idftype = PatentIS.IDFTypeList(); ViewBag.pitype = PatentIS.GetPatentInventorType(); ViewBag.dept = PatentIS.DepartmentList(); model.ListAction = PatentIS.ActionList(); model.TMListAction = PatentIS.TMActionList(); model.CRListAction = PatentIS.CRActionList(); model.DPListAction = PatentIS.DesignActionList(); model.Annex.ListStage = PatentIS.StageList(); model.Annex.ListIndustry = PatentIS.IndustryList(); model.Annex.ListIndustry1 = PatentIS.IndustryList1(); model.Annex.IITMode = PatentIS.CommericaliseMode(); model.Annex.JointMode = PatentIS.CommericaliseMode1(); model.Trade.Catlist = PatentIS.TMCategory(); model.DesignClass.ClassList = PatentIS.DPClass(); ViewBag.CRCat = PatentIS.CRCategory(); ViewBag.Nature = PatentIS.CRNature(); ViewBag.CRClass = PatentIS.CRClass(); if (idf.IDFType == "Trademark") { idf.RequestedAction = idf.RequestedTMAction; } else if (idf.IDFType == "Copyright") { idf.RequestedAction = idf.RequestedCRAction; } else if (idf.IDFType == "DesignPatent") { idf.RequestedAction = idf.RequestedDPAction; } if (idf.isDraft == "Form") { if (idf.formUpdate == false) { var seqno = Convert.ToInt64(PatentIS.GetNewFileNo()); if (seqno > 0) { seqno += 1; idf.FileNo = seqno; string IIDF = PatentService.InsertIDFRequest(idf, file, User.Identity.Name); if (IIDF == "Success") { ViewBag.succMsg = "Your request has been created successfully with IDF Number - " + idf.FileNo + "."; if (idf.DraftNo != null) { bool draft = PatentService.DeleteDraft(idf.DraftNo); } //MailMessage mail = new MailMessage(); //mail.To.Add("*****@*****.**"); //mail.From = new MailAddress("*****@*****.**"); //mail.Subject= "Your request has been created successfully with IDF Number - " + idf.FileNo + "."; //mail.Body = "Trial"; //TempData["FileNo"] = idf.FileNo; //var report = new PatentISController().IDFReport(); } else { ViewBag.errMsg = IIDF; } } else { ViewBag.errMsg = "Error Connecting Database.Kindly Contact ICSR Computer Section -9741"; } } else { string IIDF = PatentService.UpdateIDFRequest(idf, file, User.Identity.Name); if (IIDF == "Success") { ViewBag.succMsg = "Your request has been created successfully with IDF Number - " + idf.FileNo + "."; } else { ViewBag.errMsg = IIDF; } } } else if (idf.isDraft == "Draft") { if (idf.draftUpdate == false) { var seqno = Convert.ToInt64(PatentIS.GetNewDraftNo()); if (seqno > 0) { seqno += 1; idf.FileNo = seqno; string IIDF = PatentService.InsertDraft(idf, User.Identity.Name); if (IIDF == "Success") { ViewBag.succMsg = "Your request has been created successfully with draft Number - D" + idf.FileNo + "."; } else { ViewBag.errMsg = IIDF; } } else { ViewBag.errMsg = "Error Connecting Database.Kindly Contact ICSR Computer Section -9741"; } } else { string IIDF = PatentService.UpdateDraft(idf, User.Identity.Name); if (IIDF == "Success") { ViewBag.succMsg = "Your request has been created successfully with Draft Number - " + idf.DraftNo + "."; } else { ViewBag.errMsg = IIDF; } } } return(View(model)); }