public static List <KanbanList> getKanbanList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <KanbanList> result = new List <KanbanList>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from kb in ef.EXT_KANBAN join mds in ef.MA_MODEL_STRUCTURE on kb.MODEL_STRUCTURE_ID equals mds.ID join m in ef.MA_MODEL on mds.MODEL_ID equals m.ID where (kb.STATUS == null) select new KanbanList { KanbnaId = kb.ID, customer_name = m.MA_CUSTOMER.CUSTOMER_NAME, model_name = m.MODEL_NAME, part_name = mds.MA_PART.PART_NAME, part_no = mds.MA_PART.PART_NO, tag_id = kb.TAG_ID, quantity = mds.LOT_SIZE, total_quantity = kb.EXT_PLAN.LOT_SIZE }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <KanbanList> iqQuery = query.AsQueryable().OrderBy(x => x.customer_name); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static List <OperatorMaster> getOperatorMasterList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <OperatorMaster> result = new List <OperatorMaster>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from mp in ef.MA_OPT_USER join ro in ef.MA_OPT_ROLE on mp.ROLE_ID equals ro.ID select new OperatorMaster { id = mp.ID, username = mp.USER_NAME, password = mp.PASSWORD, roleid = mp.ROLE_ID, rolename = ro.DESCRIPTION }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <OperatorMaster> iqQuery = query.AsQueryable().OrderBy(x => x.id); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static List <Part> getPartsList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <Part> result = new List <Part>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from mp in ef.MA_PART select new Part { ID = mp.ID, PART_NAME = mp.PART_NAME, PART_NO = mp.PART_NO, PROD_LENGTH = mp.PROD_LENGTH, PART_TYPE = mp.PACKING_TYPE, UNIT_QTY = mp.PACK_PCS_LOT, }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <Part> iqQuery = query.AsQueryable().OrderBy(x => x.ID); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static List <LineMaster> getLineList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <LineMaster> result = new List <LineMaster>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from mp in ef.MA_LINE select new LineMaster { id = mp.ID, Line = mp.LINE_NAME, Process = mp.PROCESS_NAME, Sequence = mp.PROCESS_SEQ }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <LineMaster> iqQuery = query.AsQueryable().OrderBy(x => x.id); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static List <CustomerMaster> getCustomerMasterList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <CustomerMaster> result = new List <CustomerMaster>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from mp in ef.MA_CUSTOMER select new CustomerMaster { id = mp.ID, customer_name = mp.CUSTOMER_NAME, customer_shortname = mp.CUSTOMER_SHOT }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <CustomerMaster> iqQuery = query.AsQueryable().OrderBy(x => x.id); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static List <OpeatorRoleMaster> getOperatorRoleList(ref int totalRecord, int?pageindex = null, int?pagesize = null) { List <OpeatorRoleMaster> result = new List <OpeatorRoleMaster>(); using (TAC_KANBANEntities ef = new TAC_KANBANEntities()) { try { var query = from mp in ef.MA_OPT_ROLE select new OpeatorRoleMaster { id = mp.ID, rolename = mp.ROLE_NAME, description = mp.DESCRIPTION }; totalRecord = query.Count(); if (pageindex.HasValue && pagesize.HasValue) { if (query.Any()) { IQueryable <OpeatorRoleMaster> iqQuery = query.AsQueryable().OrderBy(x => x.id); result = iqQuery.Skip(pagesize.Value * (pageindex.Value - 1)).Take(pagesize.Value).ToList(); } } else if (query.Any()) { result = query.ToList(); } } catch { } } return(result); }
public static string Update(FORECAST_ORDER fc, TAC_KANBANEntities ceRef = null) { String results = null; bool isSuccess = false; bool isRootTransaction = true; TAC_KANBANEntities ce; if (ceRef == null) { //using new entity object ce = new TAC_KANBANEntities(); } else { //using current entity object ce = ceRef; isRootTransaction = false; } // Start transaction for update a Lease Admin record. try { using (TransactionScope trans = EntityUtils.CreateTransactionScope()) { if (isRootTransaction) { // Manually open connection to prevent EF from auto closing // connection and causing issues with future queries. ce.Connection.Open(); } // Checking for version ce.AttachUpdated(fc); ce.SaveChanges(System.Data.Objects.SaveOptions.DetectChangesBeforeSave); isSuccess = true; trans.Complete(); // Transaction complete } } catch (OptimisticConcurrencyException oex) { // Log error in ELMAH for any diagnostic needs. results = "The current record has been modifed since you have " + "last retrieved it. Please reload the record and " + "attempt to save it again."; } catch (Exception ex) { // Error occurs // Log error in ELMAH for any diagnostic needs. isSuccess = false; results = "An error occurred saving the record. Please try again."; } finally { if (isRootTransaction) { ce.Connection.Dispose(); } } // Finally accept all changes from the transaction. if (isSuccess && isRootTransaction) { ce.Dispose(); } return(results); }
public static String Delete(int id, TAC_KANBANEntities ceRef = null) { String sResult = null; bool isSuccess = false; bool isRootTransaction = true; TAC_KANBANEntities ce; if (ceRef == null) { //using new entity object ce = new TAC_KANBANEntities(); } else { //using current entity object ce = ceRef; isRootTransaction = false; } try { using (TransactionScope trans = EntityUtils.CreateTransactionScope()) { if (isRootTransaction) { // Manually open connection to prevent EF from auto closing // connection and causing issues with future queries. ce.Connection.Open(); } var forecastDetail = from com in ce.FORECAST_ORDER_DETAIL where com.FORCAST_ID == id select com; if (forecastDetail.Count() > 0) { foreach (FORECAST_ORDER_DETAIL item in forecastDetail.ToList <FORECAST_ORDER_DETAIL>()) { ce.DeleteObject(item); } } //Delete record var forecast = from doc in ce.FORECAST_ORDER where doc.ID == id select doc; if (forecast.Any()) { FORECAST_ORDER fc = forecast.FirstOrDefault(); ce.FORECAST_ORDER.DeleteObject(fc); } else { throw new NullReferenceException(); } if (isRootTransaction) { // We tentatively save the changes so that we can finish // processing the transaction.foreach (var bk in books) ce.SaveChanges(System.Data.Objects.SaveOptions.DetectChangesBeforeSave); } isSuccess = true; trans.Complete(); //Transaction complete. } } catch (Exception ex) { // Log error in ELMAH for any diagnostic needs. sResult = ex.ToString(); isSuccess = false; } finally { if (isRootTransaction) { ce.Connection.Dispose(); } } // Finally accept all changes from the transaction. if (isSuccess && isRootTransaction) { ce.AcceptAllChanges(); ce.Dispose(); } return(sResult); }