public bool Edit(ImportedInventory newInstance) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.ImportedInventories.FirstOrDefault(m => m.ID == newInstance.ID); if (currentInstance == null) { return(false); } currentInstance.MaterialID = newInstance.MaterialID; currentInstance.ParcelCode = newInstance.ParcelCode; currentInstance.ImportDate = newInstance.ImportDate; currentInstance.Quantity = newInstance.Quantity; currentInstance.WeightUnit = newInstance.WeightUnit; db.Entry(currentInstance).State = System.Data.Entity.EntityState.Modified; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public bool AddMonthReport(int month, int year, MonthReport newInstance) { var db = new MaterialMeasurementEntities(); try { var monthReport = db.MonthReports.Where(i => i.MaterialId == newInstance.MaterialId && i.ParcelCode == newInstance.ParcelCode && i.ReportDate.Month == month && i.ReportDate.Year == year).FirstOrDefault(); if (monthReport == null) { db.MonthReports.Add(newInstance); SaveChanges(db); } if (monthReport != null) { monthReport.RemainQuantity = monthReport.RemainQuantity == 0 ? newInstance.RemainQuantity : monthReport.RemainQuantity; monthReport.ImportQuantity = monthReport.ImportQuantity == 0 ? newInstance.ImportQuantity : monthReport.ImportQuantity; monthReport.ExportQuantity = monthReport.ExportQuantity == 0 ? newInstance.ExportQuantity : monthReport.ExportQuantity; db.Entry(monthReport).State = System.Data.Entity.EntityState.Modified; SaveChanges(db); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } return(true); }
public bool Add(Composition newInstance) { var db = new MaterialMeasurementEntities(); try { //var resultMaterial = db.Materials.FirstOrDefault(m => m.ID == newInstance.ResultMaterialID); //var componentMaterial = db.Materials.FirstOrDefault(m => m.ID == newInstance.ComponentMaterialID); //if (resultMaterial == null || componentMaterial == null) //{ // return false; //} //newInstance.Material = resultMaterial; //newInstance.Material1 = componentMaterial; var composition = db.Compositions.Where(c => c.ResultMaterialID == newInstance.ResultMaterialID && c.ComponentMaterialID == newInstance.ComponentMaterialID); if (composition.Count() == 0) { db.Compositions.Add(newInstance); SaveChanges(db); return(true); } } catch (Exception ex) { return(false); } return(false); }
public bool Add(Material newInstance) { var db = new MaterialMeasurementEntities(); try { var material = db.Materials.FirstOrDefault(m => m.Code.Equals(newInstance.Code) && (m.Revision == newInstance.Revision || m.TypeID == (int)MaterialTypeEnum.Raw)); if (material == null) { db.Materials.Add(newInstance); SaveChanges(db); } else if ("".Equals(material.Name.Trim())) { newInstance.ID = material.ID; Edit(newInstance); } else { return(false); } } catch (Exception) { return(false); } return(true); }
public bool Edit(MeasurementDetailRecord newInstance) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.MeasurementDetailRecords.FirstOrDefault(m => m.ID == newInstance.ID); if (currentInstance == null) { return(false); } currentInstance.MeasurementRecordID = newInstance.MeasurementRecordID; currentInstance.RawMaterialID = newInstance.RawMaterialID; currentInstance.Weight = newInstance.Weight; currentInstance.WeightUnit = newInstance.WeightUnit; db.Entry(currentInstance).State = System.Data.Entity.EntityState.Modified; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public List <MeasurementDetailRecord> GetMeasurementDetailRecordByMonth(int month, int year) { var db = new MaterialMeasurementEntities(); var listRecords = db.MeasurementDetailRecords.Where(r => r.MeasurementRecord.RecordDate.Month == month && r.MeasurementRecord.RecordDate.Year == year) .OrderBy(r => r.MeasurementRecord.RecordDate) .GroupBy(r => new { Date = r.MeasurementRecord.RecordDate.Day, ComponentMaterialID = r.RawMaterialID, ParcelCode = r.ParcelCode, WeightUnit = r.WeightUnit, ResultMaterial = r.MeasurementRecord.Material }).ToList(); var listDetailRecords = new List <MeasurementDetailRecord>(); foreach (var item in listRecords) { listDetailRecords.Add(new MeasurementDetailRecord { RawMaterialID = item.Key.ComponentMaterialID, ParcelCode = item.Key.ParcelCode, WeightUnit = item.Key.WeightUnit, MeasurementRecordID = item.First().MeasurementRecordID, Weight = item.Sum(r => r.Weight), Material = item.First().Material, MeasurementRecord = item.First().MeasurementRecord }); } return(listDetailRecords); }
public bool Edit(Material newInstance) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.Materials.FirstOrDefault(m => m.ID == newInstance.ID); if (currentInstance == null) { return(false); } currentInstance.Name = newInstance.Name; currentInstance.PatId = newInstance.PatId; currentInstance.Revision = newInstance.Revision; currentInstance.Code = newInstance.Code; currentInstance.IsDeleted = newInstance.IsDeleted; currentInstance.TypeID = newInstance.TypeID; db.Entry(currentInstance).State = System.Data.Entity.EntityState.Modified; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
//public List<DetailRecord> GetDetailRecordsByMonth(int month) //{ // var listRecords = db.MeasurementDetailRecords.Where(r => r.MeasurementRecord.RecordDate.Month == month) // .GroupBy(r => new // { // r.RawMaterialID, // r.ParcelCode, // r.WeightUnit // }) // .Select(g => new DetailRecord() // { // RawMaterialID = g.Key.RawMaterialID, // ParcelCode = g.Key.ParcelCode, // Unit = g.Key.WeightUnit, // Weight = g.Sum(s => s.Weight), // }); // return listRecords.ToList(); //} public MeasurementDetailRecord GetLatestDetailRecord(long componentID, long recordID) { var db = new MaterialMeasurementEntities(); var record = db.MeasurementDetailRecords.Where(r => r.MeasurementRecordID == recordID && r.RawMaterialID == componentID).OrderByDescending(r => r.ID).FirstOrDefault(); return(record); }
public IEnumerable <ImportedInventory> GetNotEmptyInventoriesByMaterialID(long materialID) { var db = new MaterialMeasurementEntities(); var importedInventories = db.ImportedInventories.Where(i => i.MaterialID == materialID && i.Quantity > 0).OrderBy(i => i.ID); return(importedInventories); }
public IEnumerable <MeasurementRecord> GetMeasurementRecordByMonth(int month, int year) { var db = new MaterialMeasurementEntities(); var listRecords = db.MeasurementRecords.Where(r => r.RecordDate.Month == month && r.RecordDate.Year == year); return(listRecords); }
public MeasurementRecord GetLatestRecord(long resultMaterialId) { var db = new MaterialMeasurementEntities(); var record = db.MeasurementRecords.Where(r => r.ResultMaterialID == resultMaterialId).OrderByDescending(r => r.ID).FirstOrDefault(); return(record); }
public Material GetMaterialById(long materialId) { var db = new MaterialMeasurementEntities(); var material = db.Materials.FirstOrDefault(m => m.ID == materialId); return(material); }
public IEnumerable <ImportedInventory> GetImportedInventories() { var db = new MaterialMeasurementEntities(); var importedInventories = db.ImportedInventories; return(importedInventories); }
public IEnumerable <MonthReport> GetMonthReportsByMonth(int month, int year) { var db = new MaterialMeasurementEntities(); var listMonthReport = db.MonthReports.Where(m => m.ReportDate.Month == month && m.ReportDate.Year == year); return(listMonthReport); }
public IEnumerable <Material> GetMaterialsByCode(string materialCode) { var db = new MaterialMeasurementEntities(); var materialList = db.Materials.Where(m => m.Code.ToLower().Equals(materialCode.ToLower())).OrderBy(m => m.Revision); return(materialList); }
public Material GetMaterialByCodeAndRev(string materialCode, int rev) { var db = new MaterialMeasurementEntities(); var material = db.Materials.Where(m => m.Code.ToLower().Equals(materialCode.ToLower()) && m.Revision == rev).FirstOrDefault(); return(material); }
public IEnumerable <Material> GetMaterials() { var db = new MaterialMeasurementEntities(); var materialList = db.Materials.Where(m => !m.IsDeleted); return(materialList); }
public MonthReport GetPreviousMonthReport(long materialId, string parcelCode, int month) { var db = new MaterialMeasurementEntities(); var monthReport = db.MonthReports.Where(m => m.MaterialId == materialId && m.ParcelCode == parcelCode && m.ReportDate.Month == month - 1).FirstOrDefault(); return(monthReport); }
public IEnumerable <MonthReport> GetAllRemainPreviousMonthReport(int month, int year) { var db = new MaterialMeasurementEntities(); var listMonthReport = db.MonthReports.Where(m => m.ReportDate.Month == month - 1 && m.ReportDate.Year == year && (m.RemainQuantity + m.ImportQuantity - m.ExportQuantity) > 0); return(listMonthReport); }
public IEnumerable <ImportedInventory> GetImportedInventoriesByMonthAndMaterialIDAndParcelCode(int month, int year, long materialId, string parcelCode) { var db = new MaterialMeasurementEntities(); var importedInventories = db.ImportedInventories.Where(i => i.ImportDate.Month == month && i.ImportDate.Year == year && i.MaterialID == materialId && i.ParcelCode.ToLower().Equals(parcelCode.ToLower())); return(importedInventories); }
public int GetLatestRevision(string materialCode) { var db = new MaterialMeasurementEntities(); var materials = db.Materials.Where(m => m.Code.Equals(materialCode)).OrderByDescending(m => m.Revision).FirstOrDefault(); if (materials == null) { return(0); } return(materials.Revision); }
//existed => true public bool IsExisted(string materialCode) { var db = new MaterialMeasurementEntities(); var materials = GetMaterialsByCode(materialCode); if (materials.Count() > 0) { return(!"".Equals(materials.ElementAt(0).Name.Trim())); } return(false); }
public IEnumerable <User> GetAll() { var db = new MaterialMeasurementEntities(); try { return(db.Users.AsEnumerable()); } catch (Exception) { return(null); } }
public IEnumerable <Composition> GetCompositionsByResultMaterialId(long rsMaterialId) { var db = new MaterialMeasurementEntities(); try { var compositions = db.Compositions.Where(c => c.ResultMaterialID == rsMaterialId); return(compositions); } catch (Exception) { return(null); } }
public Composition GetCompositionByID(long compositionID) { var db = new MaterialMeasurementEntities(); try { var composition = db.Compositions.FirstOrDefault(c => c.ID == compositionID); return(composition); } catch (Exception) { return(null); } }
public bool Add(MeasurementDetailRecord newInstance) { var db = new MaterialMeasurementEntities(); try { db.MeasurementDetailRecords.Add(newInstance); SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public User SignIn(string username, string password) { var db = new MaterialMeasurementEntities(); var currentInstance = db.Users.FirstOrDefault(u => u.Username.Equals(username)); if (currentInstance == null) { return(null); } if (!currentInstance.Password.Equals(password)) { return(null); } return(currentInstance); }
public bool Delete(long Id) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.MeasurementDetailRecords.FirstOrDefault(m => m.ID == Id); if (currentInstance == null) { return(false); } db.Entry(currentInstance).State = System.Data.Entity.EntityState.Deleted; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public bool Delete(string username) { var db = new MaterialMeasurementEntities(); try { var currentInstance = db.Users.FirstOrDefault(u => u.Username.Equals(username)); if (currentInstance == null) { return(false); } db.Entry(currentInstance).State = System.Data.Entity.EntityState.Deleted; SaveChanges(db); } catch (Exception) { return(false); } return(true); }
public bool Add(ImportedInventory newInstance) { var db = new MaterialMeasurementEntities(); try { var importedInventory = db.ImportedInventories.Where(i => i.MaterialID == newInstance.MaterialID && i.ParcelCode == newInstance.ParcelCode); if (importedInventory.Count() == 0) { db.ImportedInventories.Add(newInstance); SaveChanges(db); } } catch (Exception) { return(false); } return(true); }