public DeleteGroupResponse Delete(int id) { var response = new DeleteGroupResponse(); try { var group = new Group { Id = id }; DataContext.Groups.Attach(group); DataContext.Entry(group).State = EntityState.Deleted; DataContext.SaveChanges(); response.IsSuccess = true; response.Message = "Group item has been updated successfully"; } catch (DbUpdateException dbUpdateException) { response.IsSuccess = false; response.Message = dbUpdateException.Message; } return response; }
public void Installer() { ////var group = new Group(); ////group.Id = 1; ////group.IsActive = true; ////group.Name = "Fatality"; ////group.Order = 1; ////group.Remark = "test"; ////var group2 = new Group(); ////group2.Id = 2; ////group2.IsActive = true; ////group2.Name = "Security"; ////group2.Order = 2; ////group2.Remark = "test"; ////var gr1 = new Group { Id = 1, Name = "Fatality", Order=1, IsActive=1 }; //_dataContext.Groups.AddOrUpdate(group); //_dataContext.Groups.AddOrUpdate(group2); var gr1 = new Group { Id = 1, Name = "Fatality", Order = 1, IsActive = true }; var gr2 = new Group { Id = 2, Name = "DAFWC", Order = 1, IsActive = true }; var gr3 = new Group { Id = 3, Name = "LOPC", Order = 1, IsActive = true }; var gr4 = new Group { Id = 4, Name = "Security", Order = 1, IsActive = true }; var gr5 = new Group { Id = 5, Name = "LNG Production", Order = 1, IsActive = true }; var gr6 = new Group { Id = 6, Name = "Flarred Gas", Order = 1, IsActive = true }; var gr7 = new Group { Id = 7, Name = "Thermal Efficiency", Order = 1, IsActive = true }; var gr8 = new Group { Id = 8, Name = "Plant Availibility", Order = 1, IsActive = true }; var gr9 = new Group { Id = 9, Name = "Plant Reliability", Order = 1, IsActive = true }; var gr10 = new Group { Id = 10, Name = "Cargo Commitment", Order = 1, IsActive = true }; var gr11 = new Group { Id = 11, Name = "Dividen Payout Ratio", Order = 1, IsActive = true }; var gr12 = new Group { Id = 12, Name = "Debt Service Ratio", Order = 1, IsActive = true }; var gr13 = new Group { Id = 13, Name = "Ebitda", Order = 1, IsActive = true }; var gr14 = new Group { Id = 14, Name = "Budget Utilization", Order = 1, IsActive = true }; var gr15 = new Group { Id = 15, Name = "Total Operating Cost", Order = 1, IsActive = true }; var gr16 = new Group { Id = 16, Name = "Production Cost", Order = 1, IsActive = true }; var gr17 = new Group { Id = 17, Name = "Positive Tone", Order = 1, IsActive = true }; var gr18 = new Group { Id = 18, Name = "Program recognized by Gov & Institution", Order = 1, IsActive = true }; var gr19 = new Group { Id = 19, Name = "Community acceptance through CSR program & CR", Order = 1, IsActive = true }; var gr20 = new Group { Id = 20, Name = "Social ROI", Order = 1, IsActive = true }; var gr21 = new Group { Id = 21, Name = "EBITDA/Employee", Order = 1, IsActive = true }; var gr22 = new Group { Id = 22, Name = "Cost/POB ", Order = 1, IsActive = true }; var gr23 = new Group { Id = 23, Name = "Employee Retention", Order = 1, IsActive = true }; var gr24 = new Group { Id = 24, Name = "Employee Turn over", Order = 1, IsActive = true }; var gr25 = new Group { Id = 25, Name = "ICT service availability", Order = 1, IsActive = true }; var gr26 = new Group { Id = 26, Name = "QHSE training attend", Order = 1, IsActive = true }; var gr27 = new Group { Id = 27, Name = "QHSE Closure actions", Order = 1, IsActive = true }; var gr28 = new Group { Id = 28, Name = "% fitness for work", Order = 1, IsActive = true }; var gr29 = new Group { Id = 29, Name = "PS-Near miss", Order = 1, IsActive = true }; var gr30 = new Group { Id = 30, Name = "Traffic transportation incidents", Order = 1, IsActive = true }; var gr31 = new Group { Id = 31, Name = "Activation of a safety inspection system", Order = 1, IsActive = true }; var gr32 = new Group { Id = 32, Name = "Activation of a Mechanical shutdown system", Order = 1, IsActive = true }; var gr33 = new Group { Id = 33, Name = "Activation of pressure relief device", Order = 1, IsActive = true }; var gr34 = new Group { Id = 34, Name = "alarm rate/operator", Order = 1, IsActive = true }; var gr35 = new Group { Id = 35, Name = "standing alarm", Order = 1, IsActive = true }; var gr36 = new Group { Id = 36, Name = "# backlog in corrective & preventive plant maintenance", Order = 1, IsActive = true }; var gr37 = new Group { Id = 37, Name = "Planned hour vs actual hours", Order = 1, IsActive = true }; var gr38 = new Group { Id = 38, Name = "Planned Shutdown (hours)", Order = 1, IsActive = true }; var gr39 = new Group { Id = 39, Name = "Unplanned shutdown (hours)", Order = 1, IsActive = true }; var gr40 = new Group { Id = 40, Name = "Maintenance efficiency (budget)", Order = 1, IsActive = true }; var gr41 = new Group { Id = 41, Name = "Recordable Injury Frequency", Order = 1, IsActive = true }; var gr42 = new Group { Id = 42, Name = "Feed Gas Supply", Order = 1, IsActive = true }; var gr43 = new Group { Id = 43, Name = "Feed Gas Supply(Senoro)", Order = 1, IsActive = true }; var gr44 = new Group { Id = 44, Name = "Feed Gas Supply(Matindok)", Order = 1, IsActive = true }; var gr45 = new Group { Id = 45, Name = "Condensate Production", Order = 1, IsActive = true }; var gr46 = new Group { Id = 46, Name = "Condensate Sales", Order = 1, IsActive = true }; var gr47 = new Group { Id = 47, Name = "JCC Price (USD/bbl)", Order = 1, IsActive = true }; var gr48 = new Group { Id = 48, Name = "Senoro Feed Gas Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr49 = new Group { Id = 49, Name = "Matindok Feed Gas Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr50 = new Group { Id = 50, Name = "Chubu SPA LNG Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr51 = new Group { Id = 51, Name = "Kyushu SPA LNG Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr52 = new Group { Id = 52, Name = "KOGAS SPA LNG Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr53 = new Group { Id = 53, Name = "LNG Spot Price (USD/mmbtu)", Order = 1, IsActive = true }; var gr54 = new Group { Id = 54, Name = "Condensate Price (USD/bbl)", Order = 1, IsActive = true }; var gr55 = new Group { Id = 55, Name = "Total Revenue (USD Million)", Order = 1, IsActive = true }; var gr56 = new Group { Id = 56, Name = "Revenue from LNG Sales (USD Million)", Order = 1, IsActive = true }; var gr57 = new Group { Id = 57, Name = "Revenue from Condensate Sales (USD Million)", Order = 1, IsActive = true }; var gr58 = new Group { Id = 58, Name = "Total COGS - (USD Million)", Order = 1, IsActive = true }; var gr59 = new Group { Id = 59, Name = "Total Cost of Feed Gas (USD Million)", Order = 1, IsActive = true }; var gr60 = new Group { Id = 60, Name = "Direct Labor Cost (USD Million)", Order = 1, IsActive = true }; var gr61 = new Group { Id = 61, Name = "Factory Overhead (USD Million)", Order = 1, IsActive = true }; var gr62 = new Group { Id = 62, Name = "Depreciation Expense (USD Million)", Order = 1, IsActive = true }; var gr63 = new Group { Id = 63, Name = "OPEX - Shipping & Marketing (USD Million)", Order = 1, IsActive = true }; var gr64 = new Group { Id = 64, Name = "OPEX - General & Administrative (USD Million)", Order = 1, IsActive = true }; var gr65 = new Group { Id = 65, Name = "Income Tax (USD Million)", Order = 1, IsActive = true }; var gr66 = new Group { Id = 66, Name = "Profit After Tax (USD Million)", Order = 1, IsActive = true }; var gr67 = new Group { Id = 67, Name = "Project Cash Flow", Order = 1, IsActive = true }; var gr68 = new Group { Id = 68, Name = "CAPEX", Order = 1, IsActive = true }; var gr69 = new Group { Id = 69, Name = "Change in Working Capital", Order = 1, IsActive = true }; var gr70 = new Group { Id = 70, Name = "Equity Cash Flow", Order = 1, IsActive = true }; var gr71 = new Group { Id = 71, Name = "Equity Injections", Order = 1, IsActive = true }; var gr72 = new Group { Id = 72, Name = "SH Loan Interest Return", Order = 1, IsActive = true }; var gr73 = new Group { Id = 73, Name = "Cash Generated for Equity Holders", Order = 1, IsActive = true }; var gr74 = new Group { Id = 74, Name = "Cash Flow Available for Debt Service/CFADS", Order = 1, IsActive = true }; var gr75 = new Group { Id = 75, Name = "Debt Service", Order = 1, IsActive = true }; var gr76 = new Group { Id = 76, Name = "NPV of CFADS", Order = 1, IsActive = true }; var gr77 = new Group { Id = 77, Name = "Debt Balance", Order = 1, IsActive = true }; var gr78 = new Group { Id = 78, Name = "Dividend Paid", Order = 1, IsActive = true }; var gr79 = new Group { Id = 79, Name = "Retained Earnings for Dividend", Order = 1, IsActive = true }; var gr80 = new Group { Id = 80, Name = "Loan Life Coverage Ratio", Order = 1, IsActive = true }; _dataContext.Groups.AddOrUpdate(gr1); _dataContext.Groups.AddOrUpdate(gr2); _dataContext.Groups.AddOrUpdate(gr3); _dataContext.Groups.AddOrUpdate(gr4); _dataContext.Groups.AddOrUpdate(gr5); _dataContext.Groups.AddOrUpdate(gr6); _dataContext.Groups.AddOrUpdate(gr7); _dataContext.Groups.AddOrUpdate(gr8); _dataContext.Groups.AddOrUpdate(gr9); _dataContext.Groups.AddOrUpdate(gr10); _dataContext.Groups.AddOrUpdate(gr11); _dataContext.Groups.AddOrUpdate(gr12); _dataContext.Groups.AddOrUpdate(gr13); _dataContext.Groups.AddOrUpdate(gr14); _dataContext.Groups.AddOrUpdate(gr15); _dataContext.Groups.AddOrUpdate(gr16); _dataContext.Groups.AddOrUpdate(gr17); _dataContext.Groups.AddOrUpdate(gr18); _dataContext.Groups.AddOrUpdate(gr19); _dataContext.Groups.AddOrUpdate(gr20); _dataContext.Groups.AddOrUpdate(gr21); _dataContext.Groups.AddOrUpdate(gr22); _dataContext.Groups.AddOrUpdate(gr23); _dataContext.Groups.AddOrUpdate(gr24); _dataContext.Groups.AddOrUpdate(gr25); _dataContext.Groups.AddOrUpdate(gr26); _dataContext.Groups.AddOrUpdate(gr27); _dataContext.Groups.AddOrUpdate(gr28); _dataContext.Groups.AddOrUpdate(gr29); _dataContext.Groups.AddOrUpdate(gr30); _dataContext.Groups.AddOrUpdate(gr31); _dataContext.Groups.AddOrUpdate(gr32); _dataContext.Groups.AddOrUpdate(gr33); _dataContext.Groups.AddOrUpdate(gr34); _dataContext.Groups.AddOrUpdate(gr35); _dataContext.Groups.AddOrUpdate(gr36); _dataContext.Groups.AddOrUpdate(gr37); _dataContext.Groups.AddOrUpdate(gr38); _dataContext.Groups.AddOrUpdate(gr39); _dataContext.Groups.AddOrUpdate(gr40); _dataContext.Groups.AddOrUpdate(gr41); _dataContext.Groups.AddOrUpdate(gr42); _dataContext.Groups.AddOrUpdate(gr43); _dataContext.Groups.AddOrUpdate(gr44); _dataContext.Groups.AddOrUpdate(gr45); _dataContext.Groups.AddOrUpdate(gr46); _dataContext.Groups.AddOrUpdate(gr47); _dataContext.Groups.AddOrUpdate(gr48); _dataContext.Groups.AddOrUpdate(gr49); _dataContext.Groups.AddOrUpdate(gr50); _dataContext.Groups.AddOrUpdate(gr51); _dataContext.Groups.AddOrUpdate(gr52); _dataContext.Groups.AddOrUpdate(gr53); _dataContext.Groups.AddOrUpdate(gr54); _dataContext.Groups.AddOrUpdate(gr55); _dataContext.Groups.AddOrUpdate(gr56); _dataContext.Groups.AddOrUpdate(gr57); _dataContext.Groups.AddOrUpdate(gr58); _dataContext.Groups.AddOrUpdate(gr59); _dataContext.Groups.AddOrUpdate(gr60); _dataContext.Groups.AddOrUpdate(gr61); _dataContext.Groups.AddOrUpdate(gr62); _dataContext.Groups.AddOrUpdate(gr63); _dataContext.Groups.AddOrUpdate(gr64); _dataContext.Groups.AddOrUpdate(gr65); _dataContext.Groups.AddOrUpdate(gr66); _dataContext.Groups.AddOrUpdate(gr67); _dataContext.Groups.AddOrUpdate(gr68); _dataContext.Groups.AddOrUpdate(gr69); _dataContext.Groups.AddOrUpdate(gr70); _dataContext.Groups.AddOrUpdate(gr71); _dataContext.Groups.AddOrUpdate(gr72); _dataContext.Groups.AddOrUpdate(gr73); _dataContext.Groups.AddOrUpdate(gr74); _dataContext.Groups.AddOrUpdate(gr75); _dataContext.Groups.AddOrUpdate(gr76); _dataContext.Groups.AddOrUpdate(gr77); _dataContext.Groups.AddOrUpdate(gr78); _dataContext.Groups.AddOrUpdate(gr79); _dataContext.Groups.AddOrUpdate(gr80); }