public void UpdateTdLoad(TdLoad curLoad) { using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { context.TdLoad.Update(curLoad); context.SaveChanges(); }); } }
public bool LoadTextDataFileByBulk(int loadId, int refPeriodId) { bool retVal = false; using (var context = new EstimeContext(connString)) { var cmd = context.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "ESTIME.usp_BulkLoadTextFile"; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; //Add parameters DbParameter ldId = cmd.CreateParameter(); ldId.ParameterName = "@LoadId"; ldId.Value = loadId; cmd.Parameters.Add(ldId); DbParameter rpId = cmd.CreateParameter(); rpId.ParameterName = "@RefPeriodId"; rpId.Value = refPeriodId; cmd.Parameters.Add(rpId); //output parameters DbParameter success = cmd.CreateParameter(); success.ParameterName = "@SuccessCode"; success.Direction = System.Data.ParameterDirection.Output; success.DbType = System.Data.DbType.Int32; cmd.Parameters.Add(success); DbParameter errMessage = cmd.CreateParameter(); errMessage.ParameterName = "@ErrorExceptionMessage"; errMessage.Direction = System.Data.ParameterDirection.Output; errMessage.DbType = System.Data.DbType.String; errMessage.Size = 50000; cmd.Parameters.Add(errMessage); cmd.Connection.Open(); try { cmd.ExecuteNonQuery(); retVal = (int)success.Value == 0 ? true : false; } catch (Exception ex) { retVal = false; } finally { cmd.Connection.Close(); } } return(retVal); }
public TdLoad AddTdLoad(TdLoad newLoad) { using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { context.TdLoad.Add(newLoad); context.SaveChanges(); }); } return(newLoad); }
public TcRefPeriod GetRefPeriodByCode(string refPeriodCode) { TcRefPeriod rp = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { rp = context.TcRefPeriod.Include(r => r.RefPeriodType).FirstOrDefault(r => r.Code == refPeriodCode); }); } return(rp); }
public int GetRefPeriodId(string refPeriodCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TcRefPeriod.FirstOrDefault(r => r.Code == refPeriodCode).Id; }); } return(id); }
public TlLoadStatus GetLoadStatusByCode(string loadStatusCode) { TlLoadStatus ls = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { ls = context.TlLoadStatus.FirstOrDefault(l => l.Code == loadStatusCode); }); } return(ls); }
public int GetLoadStatusId(string loadStatusCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TlLoadStatus.FirstOrDefault(l => l.Code == loadStatusCode).Id; }); } return(id); }
public TlEstimeFileType GetEstimeFileTypeByCode(string estimeFileTypeCode) { TlEstimeFileType eft = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { eft = context.TlEstimeFileType.Include(e => e.FileType).FirstOrDefault(e => e.Code == estimeFileTypeCode); }); } return(eft); }
public int GetEstimeFileTypeId(string estimeFileTypeCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TlEstimeFileType.FirstOrDefault(eft => eft.Code == estimeFileTypeCode).Id; }); } return(id); }
public bool AddTdLoadStaging(int loadId, int refPeriodId, List <TdLoadStaging> newLoadStaging) { bool retVal = false; using (var context = new EstimeContext(connString)) { using (var trans = context.Database.BeginTransaction()) { //Add parameters for the stored proc SqlParameter loadIdParam = new SqlParameter("@LoadId", SqlDbType.Int) { Value = loadId }; SqlParameter refPeriodIdParam = new SqlParameter("@RefPeriodId", SqlDbType.Int) { Value = refPeriodId }; SqlParameter successParam = new SqlParameter("@SuccessCode", SqlDbType.Int) { Direction = ParameterDirection.Output }; SqlParameter errorMessageParam = new SqlParameter("@ErrorExceptionMessage", SqlDbType.NVarChar) { Size = 50000, Direction = ParameterDirection.Output }; SqlParameter[] parameters = new SqlParameter[] { loadIdParam, refPeriodIdParam, successParam, errorMessageParam }; try { context.TdLoadStaging.AddRange(newLoadStaging); context.SaveChanges(); context.Database.ExecuteSqlCommand("ESTIME.usp_ProcessLoadStagingData @LoadId, @RefPeriodId, @SuccessCode OUTPUT, @ErrorExceptionMessage OUTPUT", parameters); retVal = Convert.ToInt32(successParam.Value) == 0 ? true : false; trans.Commit(); } catch (Exception ex) { retVal = false; trans.Rollback(); } } } return(retVal); }
public IEnumerable <CodeSet> GetCodeSetList() { IQueryable <CodeSet> codesets = null; var options = new DbContextOptions <EstimeContext>(); List <CodeSet> myList = new List <CodeSet>(); using (var context = new EstimeContext(options, connString)) { //codesets = context.CodeSet.Include(cs => cs.CodeSetType).Include(cs => cs.CodeMember); EFHelper.CallEF(() => { //codesets = context.CodeSet.Include(cs => cs.CodeMember); codesets = context.CodeSet.Include(cs => cs.CodeSetType).Include(cs => cs.CodeMember); }); myList = codesets.ToList(); } return(myList); }
public IEnumerable <TlInputCoordinate> GetInputCoordinateListByEstimeFileType(int estFileTypeId) { IQueryable <TlInputCoordinate> coors = null; List <TlInputCoordinate> myList = new List <TlInputCoordinate>(); using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { coors = (from ic in context.TlInputCoordinate.Include(ic => ic.InputVariable).ThenInclude(iv => iv.Variable) join iv in context.TlInputVariable on ic.InputVariableId equals iv.Id where iv.EstimeFileTypeId == estFileTypeId select ic); }); myList = coors.ToList(); } return(myList); }