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