public static int InsertUpdatetT_OE_REF_TAGS(int?tAG_IDX, string tAG_NAME, string tAG_DESC, string tAG_CAT_NAME, bool?pROMOTE_IND, int?cREATE_USER = 0)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
Boolean insInd = false;
T_OE_REF_TAGS e = (from c in ctx.T_OE_REF_TAGS
where c.TAG_IDX == tAG_IDX
select c).FirstOrDefault();
if (e == null)
{
insInd = true;
e = new T_OE_REF_TAGS();
e.CREATE_DT = System.DateTime.Now;
e.CREATE_USERIDX = cREATE_USER;
}
if (tAG_NAME != null)
{
e.TAG_NAME = tAG_NAME;
}
if (tAG_DESC != null)
{
e.TAG_DESC = tAG_DESC;
}
if (tAG_CAT_NAME != null)
{
e.TAG_CAT_NAME = tAG_CAT_NAME;
}
if (pROMOTE_IND != null)
{
e.PROMOTE_IND = pROMOTE_IND ?? false;
}
if (insInd)
{
ctx.T_OE_REF_TAGS.Add(e);
}
ctx.SaveChanges();
return(e.TAG_IDX);
}
catch (Exception ex)
{
LogEFException(ex);
return(0);
}
}
}
public static int DeleteT_OE_REF_TAGS(int id)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_REF_TAGS rec = new T_OE_REF_TAGS {
TAG_IDX = id
};
ctx.Entry(rec).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
LogEFException(ex);
return(0);
}
}
}
//***************************project local****************************************
/// <summary>
/// Creates a new local PROJECT record and validates it according to the validation rules contained in XML file
/// </summary>
/// <param name="UserIDX"></param>
/// <param name="colVals">Name value pair for the different fields to import into the project record</param>
/// <returns></returns>
public static ProjectImportType InsertOrUpdate_T_OE_PROJECT_local(int UserIDX, Dictionary <string, string> colVals)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
//Boolean insInd = true;
ProjectImportType e = new ProjectImportType();
e.T_OE_PROJECT.PROJECT_IDX = Guid.NewGuid();
e.T_OE_PROJECT.CREATE_DT = System.DateTime.Now;
e.T_OE_PROJECT.CREATE_USERIDX = UserIDX;
//get import config rules
List <ConfigInfoType> _allRules = Utils.GetAllColumnInfo("P");
//explicitly validate mandatory fields
foreach (string entry in Utils.GetMandatoryImportFieldList("P"))
{
T_OE_PROJECT_validate(ref e, _allRules, colVals, entry);
}
//then only validate optional fields if supplied (performance)
foreach (string entry in Utils.GetOptionalImportFieldList("P"))
{
T_OE_PROJECT_validate(ref e, _allRules, colVals, entry);
}
//********************** CUSTOM POST VALIDATION ********************************************
//SET ORG_IDX based on supplied ORG_NAME
e.ORG_NAME = Utils.GetValueOrDefault(colVals, "ORG_NAME");
T_OE_ORGANIZATION oo = db_Ref.GetT_OE_ORGANIZATION_ByName(e.ORG_NAME);
if (oo != null)
{
e.T_OE_PROJECT.ORG_IDX = oo.ORG_IDX;
}
else
{
e.VALIDATE_CD = false;
e.VALIDATE_MSG += "No matching agency found.";
}
//MEDIA
e.MEDIA_NAME = Utils.GetValueOrDefault(colVals, "MEDIA_TAG");
T_OE_REF_TAGS media1 = db_Ref.GetT_OE_REF_TAGS_ByCategoryAndName("Project Media", e.MEDIA_NAME);
if (media1 != null)
{
e.T_OE_PROJECT.MEDIA_TAG = media1.TAG_IDX;
}
else
{
e.VALIDATE_CD = false;
e.VALIDATE_MSG += "Invalid Media name.";
}
//MOBILE
e.MOBILE_IND_NAME = Utils.GetValueOrDefault(colVals, "MOBILE_IND");
if (!string.IsNullOrEmpty(e.MOBILE_IND_NAME))
{
T_OE_REF_TAGS mobile1 = db_Ref.GetT_OE_REF_TAGS_ByCategoryAndName("Use Amount", e.MOBILE_IND_NAME);
if (mobile1 != null)
{
e.T_OE_PROJECT.MOBILE_IND = mobile1.TAG_IDX;
}
else
{
e.VALIDATE_CD = false;
e.VALIDATE_MSG += "Invalid Mobile Use. ";
}
}
//ADV MON
e.ADV_MON_IND_NAME = Utils.GetValueOrDefault(colVals, "ADV_MON_IND");
if (!string.IsNullOrEmpty(e.ADV_MON_IND_NAME))
{
T_OE_REF_TAGS adv1 = db_Ref.GetT_OE_REF_TAGS_ByCategoryAndName("Use Amount", e.ADV_MON_IND_NAME);
if (adv1 != null)
{
e.T_OE_PROJECT.ADV_MON_IND = adv1.TAG_IDX;
}
else
{
e.VALIDATE_CD = false;
e.VALIDATE_MSG += "Invalid Advanced Monitoring Use. ";
}
}
//BP MODERN
e.BP_MODERN_IND_NAME = Utils.GetValueOrDefault(colVals, "BP_MODERN_IND");
if (!string.IsNullOrEmpty(e.BP_MODERN_IND_NAME))
{
T_OE_REF_TAGS bp1 = db_Ref.GetT_OE_REF_TAGS_ByCategoryAndName("Use Amount", e.BP_MODERN_IND_NAME);
if (bp1 != null)
{
e.T_OE_PROJECT.BP_MODERN_IND = bp1.TAG_IDX;
}
else
{
e.VALIDATE_CD = false;
e.VALIDATE_MSG += "Invalid Business Process Improvement Use. ";
}
}
e.PROGRAM_AREAS = Utils.GetValueOrDefault(colVals, "PROGRAM_AREAS");
e.FEATURES = Utils.GetValueOrDefault(colVals, "FEATURES");
//********************** CUSTOM POST VALIDATION END ********************************************
return(e);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(null);
}
}
}
