public static int DeleteT_WQX_REF_TAXA_ORG(string orgName, string charName)
{
try
{
TWqxRefTaxaOrg r = new TWqxRefTaxaOrg();
r = (from c in _db.TWqxRefTaxaOrg
where c.OrgId == orgName &&
c.BioSubjectTaxonomy == charName
select c).FirstOrDefault();
_db.TWqxRefTaxaOrg.Remove(r);
_db.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
public static int InsertOrUpdateT_WQX_REF_TAXA_ORG(global::System.String bIO_SUBJECT_TAXAONOMY, global::System.String oRG_NAME, global::System.String cREATE_USER_ID)
{
try
{
Boolean insInd = true;
TWqxRefTaxaOrg a = new TWqxRefTaxaOrg();
if (_db.TWqxRefTaxaOrg.Any(o => o.BioSubjectTaxonomy == bIO_SUBJECT_TAXAONOMY && o.OrgId == oRG_NAME))
{
//update case
a = (from c in _db.TWqxRefTaxaOrg
where c.BioSubjectTaxonomy == bIO_SUBJECT_TAXAONOMY &&
c.OrgId == oRG_NAME
select c).FirstOrDefault();
insInd = false;
}
a.BioSubjectTaxonomy = bIO_SUBJECT_TAXAONOMY;
a.OrgId = oRG_NAME;
if (insInd) //insert case
{
a.CreateDt = System.DateTime.Now;
a.CreateUserid = cREATE_USER_ID;
_db.TWqxRefTaxaOrg.Add(a);
}
else
{
_db.TWqxRefTaxaOrg.Update(a);
}
_db.SaveChanges();
return(1);
}
catch (Exception ex)
{
return(0);
}
}
