public TopicAlt GetTopicByOriginID(string topic_code) //every file review confirm is related to
{
try{
var sql = $@"SELECT Code, Type, Change_Item.Name as Change_item, Product_Type.Name AS Product_Type, Department, Revision, Model, PartNo, PartName, ProcessName, Status, [APP/IPP] as App, Subject, Detail, Timing, TimingDesc, Related, User_insert, Time_insert, ApprovedBy, ApprovedDate,
ID FROM Topic
LEFT JOIN Change_Item ON Topic.Change_item = ID_Change_item
LEFT JOIN Product_Type ON Topic.Product_Type = ID_Product_Type
WHERE Code = '{topic_code}' ORDER BY Revision DESC;";
var Topic = DB_CCS.Database.SqlQuery <TopicAlt>(sql).First();
return(Topic);
}catch (Exception ex) {
TopicAlt blank_topic = new TopicAlt();
return(blank_topic);
}
}
public TopicAlt GetTopicByCode(string topic_code)
{
try{
var sql = $@"SELECT Code, Type, Change_Item.Name as Change_item, Product_Type.Name AS Product_Type, Department, Revision, Model, PartNo, PartName, ProcessName, Status, Status.Name AS FullStatus, [APP/IPP] as App, Subject, Detail, Timing, Related, User_insert, Time_insert,
Topic.ID FROM Topic
LEFT JOIN Status ON Topic.Status = Status.id
LEFT JOIN Change_Item ON Topic.Change_item = ID_Change_item
LEFT JOIN Product_Type ON Topic.Product_Type = ID_Product_Type
WHERE Code = '{topic_code}' ORDER BY Revision DESC;";
var Topic = DB_CCS.Database.SqlQuery <TopicAlt>(sql).First();
return(Topic);
}catch (Exception ex) {
TopicAlt blank_topic = new TopicAlt();
return(blank_topic);
}
}
