public static List <string> CRClass() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "copyright" && m.Grouping == "ClassOfWork").Select(m => m.ItemText).ToList(); return(query); } }
public static List <string> ActionList() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "Patent" && m.Grouping == "RequestedAction").Select(m => m.ItemText).ToList(); return(query); } }
public static long GetNewFileNo() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tblIDFRequest.OrderByDescending(m => m.FileNo).Select(m => m.FileNo).FirstOrDefault(); return(query); } }
public static List <string> GetPatentInventorType() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "PatentIDF" && m.Grouping == "InventorType").Select(m => m.ItemText).ToList(); return(query); } }
public static List <string> TMCategory() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "Trademark" && m.Grouping == "Category").Select(m => m.ItemText).ToList(); return(query); } }
public static List <string> StageList() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "AnexB" && m.Grouping == "DevelopmentStage").Select(m => (m.ItemValue + "-" + m.ItemText)).ToList(); return(query); } }
public static List <string> IDFTypeList() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "IDF" && m.Grouping == "Type").OrderBy(m => m.ItemValue).Select(m => m.ItemText).ToList(); return(query); } }
public static List <SelectListItem> DPClass() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "DesignPatent" && m.Grouping == "Classes").Select(m => new SelectListItem { Value = (m.ItemValue + "-" + m.ItemText), Text = (m.ItemValue + "-" + m.ItemText) }).ToList(); return(query); } }
public static List <SelectListItem> CommericaliseMode1() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "AnexB" && m.Grouping == "CommercialisationModeJoint").Select(m => new SelectListItem { Value = m.ItemText, Text = m.ItemValue }).ToList(); return(query); } }
public static List <SelectListItem> IndustryList1() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_mst_ListItem.Where(m => m.Category == "AnexB" && m.Grouping == "SubIndustry").Select(m => new SelectListItem { Value = m.ItemText, Text = m.ItemValue }).ToList(); return(query); } }
public static long GetNewDraftNo() { using (PatentISEntities pat = new PatentISEntities()) { var query = pat.tbl_draft_IDFReq.OrderByDescending(m => m.DraftNo).Select(m => m.DraftNo).FirstOrDefault(); if (query != null) { long q = Convert.ToInt64(query.Substring(1)); return(q); } else { var q = pat.tblIDFRequest.OrderByDescending(m => m.FileNo).Select(m => m.FileNo).FirstOrDefault(); return(q); } } }