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 UpdateWQX_IMPORT_LOG_MarkPendingSampImportAsComplete(string oRG_ID) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_IMPORT_LOG t = new T_WQX_IMPORT_LOG(); t = (from c in ctx.T_WQX_IMPORT_LOG where c.IMPORT_PROGRESS == "P" && c.TYPE_CD == "Sample" select c).FirstOrDefault(); t.IMPORT_STATUS = "Success"; t.IMPORT_PROGRESS = "100"; t.IMPORT_PROGRESS_MSG = "Import complete."; ctx.SaveChanges(); return t.IMPORT_ID; } catch { return 0; } } }
/// <summary> /// Create a new T_WQX_IMPORT_LOG object. /// </summary> /// <param name="iMPORT_ID">Initial value of the IMPORT_ID property.</param> /// <param name="oRG_ID">Initial value of the ORG_ID property.</param> /// <param name="tYPE_CD">Initial value of the TYPE_CD property.</param> /// <param name="fILE_NAME">Initial value of the FILE_NAME property.</param> /// <param name="fILE_SIZE">Initial value of the FILE_SIZE property.</param> public static T_WQX_IMPORT_LOG CreateT_WQX_IMPORT_LOG(global::System.Int32 iMPORT_ID, global::System.String oRG_ID, global::System.String tYPE_CD, global::System.String fILE_NAME, global::System.Int32 fILE_SIZE) { T_WQX_IMPORT_LOG t_WQX_IMPORT_LOG = new T_WQX_IMPORT_LOG(); t_WQX_IMPORT_LOG.IMPORT_ID = iMPORT_ID; t_WQX_IMPORT_LOG.ORG_ID = oRG_ID; t_WQX_IMPORT_LOG.TYPE_CD = tYPE_CD; t_WQX_IMPORT_LOG.FILE_NAME = fILE_NAME; t_WQX_IMPORT_LOG.FILE_SIZE = fILE_SIZE; return t_WQX_IMPORT_LOG; }
//*********************** IMPORT LOG ******************************* public static int InsertUpdateWQX_IMPORT_LOG(int? iMPORT_ID, string oRG_ID, string tYPE_CD, string fILE_NAME, int fILE_SIZE, string iMPORT_STATUS, string iMPORT_PROGRESS, string iMPORT_PROGRESS_MSG, byte[] iMPORT_FILE, string uSER_ID) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { T_WQX_IMPORT_LOG t = new T_WQX_IMPORT_LOG(); if (iMPORT_ID != null) t = (from c in ctx.T_WQX_IMPORT_LOG where c.IMPORT_ID == iMPORT_ID select c).First(); if (iMPORT_ID == null) t = new T_WQX_IMPORT_LOG(); if (oRG_ID != null) t.ORG_ID = oRG_ID; if (tYPE_CD != null) t.TYPE_CD = tYPE_CD.Substring(0,5); if (fILE_NAME!= null) t.FILE_NAME = fILE_NAME; t.FILE_SIZE = fILE_SIZE; if (iMPORT_STATUS != null) t.IMPORT_STATUS = iMPORT_STATUS; if (iMPORT_PROGRESS != null) t.IMPORT_PROGRESS = iMPORT_PROGRESS; if (iMPORT_PROGRESS_MSG != null) t.IMPORT_PROGRESS_MSG = iMPORT_PROGRESS_MSG; if (iMPORT_FILE != null) t.IMPORT_FILE = iMPORT_FILE; if (uSER_ID != null) t.CREATE_USERID = uSER_ID; if (iMPORT_ID == null) //insert case { t.CREATE_DT = DateTime.Now; ctx.AddToT_WQX_IMPORT_LOG(t); } else { } ctx.SaveChanges(); return t.IMPORT_ID; } catch { return 0; } } }
/// <summary> /// Deprecated Method for adding a new object to the T_WQX_IMPORT_LOG EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_WQX_IMPORT_LOG(T_WQX_IMPORT_LOG t_WQX_IMPORT_LOG) { base.AddObject("T_WQX_IMPORT_LOG", t_WQX_IMPORT_LOG); }