public string AddUploadFileDbEntry(string cicoid, string sYear, string atCd, string fileName, string flUrl)
{
string sMessage;
var form3 = new HMT_PCIS_Docs();
{
form3.CICOID = cicoid;
form3.FiscalYear = sYear;
form3.ATCode = atCd;
form3.PCIS_DocName = fileName;
form3.PCIS_DocUrl = flUrl;
form3.PCIS_DocDt = DateTime.Now;
}
var rowExists =
_hmEntities.HMT_PCIS_Docs.Where(
x => x.CICOID == cicoid && x.FiscalYear == sYear && x.ATCode == atCd);
//if (!rowExists.Any())
if (rowExists.Count() < 5)
{
using (var dbCtx = new HotelMotelTaxEntities())
{
dbCtx.HMT_PCIS_Docs.Add(form3);
dbCtx.SaveChanges();
sMessage = "Successfully added PCIS document";
}
}
else
{
using (var dbCtx = new HotelMotelTaxEntities())
{
dbCtx.Entry(rowExists).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
sMessage = "Successfully updated PCIS document";
}
}
return(sMessage);
}
