public async Task <bool> AddData(Standarddetailtbl obj)
{
try
{
using (var context = new smlpobDB())
{
var isExsist = (from x in context.Standarddetailtbl
where x.ElementId == obj.ElementId &&
x.StdId == obj.StdId
select x).SingleOrDefault();
if (isExsist != null)
{
return(false);
}
context.Standarddetailtbl.Add(obj);
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> UpdateData(string id, Standarddetailtbl obj)
{
try
{
if (id != obj.StdId.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
var isExsist = (from x in context.Standarddetailtbl
where x.ElementId == obj.ElementId &&
x.StdId == obj.StdId
select x).SingleOrDefault();
if (isExsist != null)
{
return(false);
}
context.Standarddetailtbl.Attach(obj);
context.Entry(obj).Property(x => x.StdId).IsModified = true;
context.Entry(obj).Property(x => x.ElementId).IsModified = true;
context.Entry(obj).Property(x => x.ModBy).IsModified = true;
context.Entry(obj).Property(x => x.ModDate).IsModified = true;
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
