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);
}
