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