public static int DeleteT_OE_PROJECTS(Guid id)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_PROJECTS rec = new T_OE_PROJECTS {
PROJECT_IDX = id
};
ctx.Entry(rec).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(0);
}
}
}
public static Guid?InsertUpdatetT_OE_PROJECTS(Guid?pROJECT_IDX, Guid?oRG_IDX, string pROJ_NAME, string pROJ_DESC, int?mEDIA_TAG, int?sTART_YEAR,
string pROJ_STATUS, int?dATE_LAST_UPDATE, string rECORD_SOURCE, string pROJECT_URL, int?mOBILE_IND, string mOBILE_DESC, int?aDV_MON_IND,
string aDV_MON_DESC, int?bP_MODERN_IND, string bP_MODERN_DESC, string cOTS, string vENDOR, bool aCT_IND, bool?sYNC_IND, int?cREATE_USER = 0,
bool?updateSearch = false)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
Boolean insInd = false;
T_OE_PROJECTS e = (from c in ctx.T_OE_PROJECTS
where c.PROJECT_IDX == pROJECT_IDX
select c).FirstOrDefault();
if (e == null)
{
insInd = true;
e = new T_OE_PROJECTS();
e.PROJECT_IDX = Guid.NewGuid();
e.CREATE_DT = System.DateTime.Now;
e.CREATE_USERIDX = cREATE_USER;
}
else
{
e.MODIFY_DT = System.DateTime.Now;
e.MODIFY_USERIDX = cREATE_USER;
}
if (oRG_IDX != null)
{
e.ORG_IDX = oRG_IDX.ConvertOrDefault <Guid>();
}
if (pROJ_NAME != null)
{
e.PROJ_NAME = pROJ_NAME;
}
if (pROJ_DESC != null)
{
e.PROJ_DESC = pROJ_DESC;
}
if (mEDIA_TAG != null)
{
e.MEDIA_TAG = mEDIA_TAG;
}
if (sTART_YEAR != null)
{
e.START_YEAR = sTART_YEAR;
}
if (pROJ_STATUS != null)
{
e.PROJ_STATUS = pROJ_STATUS;
}
if (dATE_LAST_UPDATE != null)
{
e.DATE_LAST_UPDATE = dATE_LAST_UPDATE;
}
if (rECORD_SOURCE != null)
{
e.RECORD_SOURCE = rECORD_SOURCE;
}
if (e.RECORD_SOURCE == null)
{
e.RECORD_SOURCE = "Agency supplied";
}
if (pROJECT_URL != null)
{
e.PROJECT_URL = pROJECT_URL;
}
if (mOBILE_IND != null)
{
e.MOBILE_IND = mOBILE_IND;
}
if (mOBILE_DESC != null)
{
e.MOBILE_DESC = mOBILE_DESC;
}
if (aDV_MON_IND != null)
{
e.ADV_MON_IND = aDV_MON_IND;
}
if (aDV_MON_DESC != null)
{
e.ADV_MON_DESC = aDV_MON_DESC;
}
if (bP_MODERN_IND != null)
{
e.BP_MODERN_IND = bP_MODERN_IND;
}
if (bP_MODERN_DESC != null)
{
e.BP_MODERN_DESC = bP_MODERN_DESC;
}
if (cOTS != null)
{
e.COTS = cOTS;
}
if (vENDOR != null)
{
e.VENDOR = vENDOR;
}
e.ACT_IND = aCT_IND;
if (sYNC_IND != null)
{
e.SYNC_IND = sYNC_IND ?? false;
}
if (insInd)
{
ctx.T_OE_PROJECTS.Add(e);
}
ctx.SaveChanges();
return(e.PROJECT_IDX);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(null);
}
}
}
//INITIALIZE
public ProjectImportType()
{
T_OE_PROJECT = new T_OE_PROJECTS();
VALIDATE_CD = true;
}