public static int DeleteT_OE_ColumnConfig(int columnConfig_IDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_OE_COLUMNCONFIG r = new T_OE_COLUMNCONFIG(); r = (from c in ctx.T_OE_COLUMNCONFIG where c.COLUMNCONFIG_IDX == columnConfig_IDX select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_WQX_IMPORT_LOG(int iMPORT_ID) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_IMPORT_LOG r = new T_WQX_IMPORT_LOG(); r = (from c in ctx.T_WQX_IMPORT_LOG where c.IMPORT_ID == iMPORT_ID select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_ATTAINS_ASSESS(int aSSESS_IDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_ATTAINS_ASSESS r = (from c in ctx.T_ATTAINS_ASSESS where c.ATTAINS_ASSESS_IDX == aSSESS_IDX select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_WQX_REF_TAXA_ORG(string orgName, string charName) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_REF_TAXA_ORG r = new T_WQX_REF_TAXA_ORG(); r = (from c in ctx.T_WQX_REF_TAXA_ORG where c.ORG_ID == orgName && c.BIO_SUBJECT_TAXONOMY == charName select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_ATTAINS_REPORT(int aTTAINS_REPORT_IDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_ATTAINS_REPORT r = (from c in ctx.T_ATTAINS_REPORT where c.ATTAINS_REPORT_IDX == aTTAINS_REPORT_IDX select c).FirstOrDefault(); if (r.ATTAINS_SUBMIT_STATUS == "Y" || r.ATTAINS_SUBMIT_STATUS == "U") return -1; ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_WQX_USER_ORGS(global::System.String oRG_ID, global::System.Int32 uSER_IDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_USER_ORGS r = new T_WQX_USER_ORGS(); r = (from c in ctx.T_WQX_USER_ORGS where c.USER_IDX == uSER_IDX && c.ORG_ID == oRG_ID select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_WQX_RESULT(int ResultIDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_RESULT r = new T_WQX_RESULT(); r = (from c in ctx.T_WQX_RESULT where c.RESULT_IDX == ResultIDX select c).FirstOrDefault(); ctx.DeleteObject(r); ctx.SaveChanges(); return 1; } catch { return 0; } } }
public static int DeleteT_OE_USERS(int idx) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_OE_USERS row = new T_OE_USERS(); row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); ctx.DeleteObject(row); ctx.SaveChanges(); return 1; } catch (Exception ex) { return 0; } } }
public static int DeleteT_VCCB_USER_ROLE(int UserIDX, int RoleIDX) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_OE_USER_ROLES row = new T_OE_USER_ROLES(); row = (from c in ctx.T_OE_USER_ROLES where c.ROLE_IDX == RoleIDX && c.USER_IDX == UserIDX select c).FirstOrDefault(); ctx.DeleteObject(row); ctx.SaveChanges(); return 1; } catch (Exception ex) { return 0; } } }