public IList <Repair> GetAllByStockUnit(StockUnit stockUnit)
{
using (ISession session = NHibernateHelper.OpenSession())
{
if (!stockUnit.IsNew)
{
var result = session.CreateCriteria <Repair>()
.CreateCriteria("Unit")
.CreateCriteria("StockUnit")
.Add(Restrictions.Eq("Id", stockUnit.Id))
.List <Repair>();
foreach (var item in result)
{
NHibernateUtil.Initialize(item.Unit);
NHibernateUtil.Initialize(item.Unit.StockUnit.StockNumber);
NHibernateUtil.Initialize(item.User);
}
return(result);
}
return(new List <Repair>());
}
}
public void Put(string id, StockUnit entity)
{
if (ModelState.IsValid)
{
db.UpdateStockUnit(entity.GetPrivateEntity <StockUnit>());
}
}
public async Task <ActionResult <StockUnit> > PostStockUnit(StockUnit stockUnit)
{
_context.StockUnits.Add(stockUnit);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetStockUnit", new { id = stockUnit.StockUnitId }, stockUnit));
}
public ReturnType RemoveStockUnit(string stockunitCode)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<StockUnit> list = alading.StockUnit.Where(p => p.StockUnitID == stockunitID).ToList();*/
List <StockUnit> list = alading.StockUnit.Where(p => p.StockUnitCode == stockunitCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
StockUnit sy = list.First();
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public async Task <IActionResult> PutStockUnit(int id, StockUnit stockUnit)
{
if (id != stockUnit.StockUnitId)
{
return(BadRequest());
}
_context.Entry(stockUnit).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StockUnitExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ReturnType AddStockUnitGroup(StockUnitGroup stockunitgroup, StockUnit unit)
{
System.Data.Common.DbTransaction tran = null;
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
try
{
alading.Connection.Open();
tran = alading.Connection.BeginTransaction();
alading.AddToStockUnitGroup(stockunitgroup);
alading.AddToStockUnit(unit);
alading.SaveChanges();
tran.Commit();
return(ReturnType.Success);
}
catch (System.Exception ex)
{
if (tran != null)
{
tran.Rollback();
}
return(ReturnType.SaveFailed);
}
finally
{
if (alading != null && alading.Connection.State != System.Data.ConnectionState.Closed)
{
alading.Connection.Close();
}
}
}
}
public ReturnType AddStockUnit(StockUnit stockunit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToStockUnit(stockunit);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public StockUnitViewModel(StockUnit arg)
{
_stockUnitRepository = new StockUnitRepository();
_stockUnitNoteRepository = new StockUnitNoteRepository();
InitViewModel(!arg.IsNew ? _stockUnitRepository.GetById(arg.Id, true) : arg);
}
private void FillDocument(StockUnit arg, string filePath)
{
using (var wordDocument = WordprocessingDocument.Open(filePath, true))
{
var doc = wordDocument.MainDocumentPart.Document;
var xmlConverter = new StockUnitXmlConverter();
var stockUnitXml = xmlConverter.Convert(arg);
var body = doc.Body;
var tableList = body.Descendants <Table>().ToList();
foreach (var table in tableList)
{
var nodesValue = TableSelectNodesText("TblStart", table);
var startRow = FindRowByMergeFieldText("TblStart", table, true);
var endRow = FindRowByMergeFieldText("TblEnd", table, true);
if (startRow != null && endRow != null)
{
var nodes = stockUnitXml.SelectNodes(nodesValue);
FillTable(table, startRow, nodes);
}
}
var fieldCodes = body.Descendants <FieldCode>();
foreach (var fieldCode in fieldCodes)
{
}
doc.Save();
}
}
public StockUnitAddView(StockUnit arg)
{
InitializeComponent();
ViewModel = new StockUnitViewModel(arg);
DataContext = ViewModel;
SetActions();
StockNumberTb.Focus();
}
private void DisplayCopyDialog(StockUnit stockUnit)
{
var dialog = new StockUnitAddView(stockUnit)
{
Owner = Window.GetWindow(this)
};
dialog.Closed += (s, e) => dialog.Owner.Focus();
dialog.Show();
}
public IList <StockUnitFile> GetByStockUnitId(StockUnit stockUnit)
{
using (ISession session = NHibernateHelper.OpenSession())
{
var result = session.CreateCriteria <StockUnitFile>()
.CreateCriteria("StockUnit")
.Add(Restrictions.Eq("Id", stockUnit.Id))
.List <StockUnitFile>();
return(result);
}
}
public string Post(StockUnit entity)
{
if (ModelState.IsValid)
{
db.InsertStockUnit(entity);
entity.PublicId = entity.GetPublicId();
return(entity.GetPublicEntity <StockUnit>().PublicId);
}
return(string.Empty);
}
public ReturnType UpdateStockUnit(StockUnit stockunit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*StockUnit result = alading.StockUnit.Where(p => p.StockUnitID == stockunit.StockUnitID).FirstOrDefault();*/
StockUnit result = alading.StockUnit.Where(p => p.StockUnitCode == stockunit.StockUnitCode).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("StockUnit", stockunit);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
*
* result.StockUnitCode = stockunit.StockUnitCode;
*
* result.StockUnitName = stockunit.StockUnitName;
*
* result.IsBaseUnit = stockunit.IsBaseUnit;
*
* result.StockUnitGroupCode = stockunit.StockUnitGroupCode;
*
* result.Conversion = stockunit.Conversion;
*
* result.StockUnitSource = stockunit.StockUnitSource;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
return(ReturnType.OthersError);
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public XmlDocument Convert(StockUnit arg)
{
_stockUnit = _repository.GetById(arg.Id, true);
var doc = new XmlDocument();
doc.AppendChild(doc.CreateXmlDeclaration("1.0", "UTF-8", "yes"));
var root = (XmlElement)doc.AppendChild(doc.CreateElement("StockUnit"));
AppendStockUnitProperties(doc, root);
AppendUnits(doc, root);
AppendRepair(doc, root);
AppendNotes(doc, root);
return(doc);
}
private void InitViewModel(StockUnit stockUnit)
{
_itemsToDelete = new List <Unit>();
_addedFiles = new List <string>();
_deletedFiles = new List <string>();
_deletedStockUnitFiles = new List <StockUnitFile>();
StockUnit = stockUnit;
if (StockUnit.IsNew && StockUnit.UnitList == null)
{
StockUnit.UnitList = new List <Unit>();
}
InitLists();
UnitList = new ObservableCollection <Unit>(StockUnit.UnitList);
UnitList.CollectionChanged += UnitList_CollectionChanged;
var documentRepository = new DocumentRepository();
DocumnetsList = new ObservableCollection <Document>(documentRepository.GetByStockUnit(StockUnit));
var repairRepository = new RepairRepository();
RepairList = new ObservableCollection <Repair>(repairRepository.GetAllByStockUnit(StockUnit));
var filesRepository = new StockUnitFileRepository();
StockUnitFiles = new ObservableCollection <StockUnitFile>(filesRepository.GetByStockUnitId(StockUnit));
StockUnitNoteList = !StockUnit.IsNew ?
new ObservableCollection <StockUnitNote>(_stockUnitNoteRepository.GetByStockUnitId(StockUnit))
: new ObservableCollection <StockUnitNote>();
var repository = new UnitRepository();
ManufactureList = repository.GetManufactureList();
ModelList = repository.GetModelList();
AddUnitCommand = new RelayCommand(x => UnitList.Add(new Unit()));
RemoveUnitCommand = new RelayCommand(x => RemoveMethod());
ReportsCommand = new RelayCommand(x => ReportsMethod());
SaveCommand = new RelayCommand(x => SaveMethod());
CloseCommand = new RelayCommand(x => CloseMethod());
AddFileCommand = new RelayCommand(x => AddFileMethod());
RemoveFileCommand = new RelayCommand(x => RemoveFileMethod());
OpenFileCommand = new RelayCommand(x => OpenFileMethod());
OpenFolderCommand = new RelayCommand(x => OpenFolderMethod());
}
public ReturnType UpdateStockUnit(string stockunitCode, StockUnit stockunit)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.StockUnit.Where(p => p.StockUnitID == stockunitID).ToList();*/
var result = alading.StockUnit.Where(p => p.StockUnitCode == stockunitCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
StockUnit ob = result.First();
//ob.StockUnitCode = stockunit.StockUnitCode;
ob.StockUnitName = stockunit.StockUnitName;
//ob.IsBaseUnit = stockunit.IsBaseUnit;
//ob.StockUnitGroupCode = stockunit.StockUnitGroupCode;
ob.Conversion = stockunit.Conversion;
//ob.StockUnitSource = stockunit.StockUnitSource;
ob.Remark = stockunit.Remark;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
private void FillDocument(StockUnit arg, string filePath)
{
using (var wordDocument = WordprocessingDocument.Open(filePath, true))
{
var doc = wordDocument.MainDocumentPart.Document;
ExportStockUnitData(doc, arg);
ExportUnitData(doc, arg.UnitList);
var repair = _repairRepository.GetAllByStockUnit(arg);
ExportRepairData(doc, repair);
var notes = _noteRepository.GetByStockUnitId(arg);
ExportNoteData(doc, notes);
RemoveSdtElements(doc);
RemoveRubbish(doc);
doc.Save();
}
}
public IList <Document> GetByStockUnit(StockUnit stockUnit)
{
using (ISession session = NHibernateHelper.OpenSession())
{
if (!stockUnit.IsNew)
{
var result = session.CreateCriteria <Document>()
.CreateCriteria("StockUnitList", "s")
.Add(Restrictions.Eq("s.Id", stockUnit.Id))
.List <Document>();
foreach (var item in result)
{
NHibernateUtil.Initialize(item.DocumentType);
NHibernateUtil.Initialize(item.Owner);
}
return(result);
}
return(new List <Document>());
}
}
private TableRow GetUnitTableRow(StockUnit stockUnit, Unit unit, int pointA, int pointB)
{
TableRow tr = new TableRow();
TableCell cell1 = new TableCell();
Paragraph paragraph1 = cell1.AppendChild(new Paragraph());
Run run1 = paragraph1.AppendChild(new Run());
run1.AppendChild(new Text((pointA + 1) + "." + (pointB + 1)));
TableCell cell2 = new TableCell();
Paragraph paragraph2 = cell2.AppendChild(new Paragraph());
Run run2 = paragraph2.AppendChild(new Run());
run2.AppendChild(new Text(unit.UnitType.TypeName));
run2.AppendChild(new Break());
run2.AppendChild(new Text(unit.Manufacture + " " + unit.ModelName));
TableCell cell3 = new TableCell();
Paragraph paragraph3 = cell3.AppendChild(new Paragraph());
Run run3 = paragraph3.AppendChild(new Run());
run3.AppendChild(new Text(unit.Serial));
run3.AppendChild(new Break());
run3.AppendChild(new Text("(инв.№" + stockUnit.StockNumber + ")"));
var comments = unit.Comments;
TableCell cell4 = new TableCell();
Paragraph paragraph4 = cell4.AppendChild(new Paragraph());
Run run4 = paragraph4.AppendChild(new Run());
run4.AppendChild(new Text(comments));
tr.Append(cell1, cell2, cell3, cell4);
return(tr);
}
public static ReturnType UpdateStockUnit(string stockunitCode, StockUnit stockunit)
{
return(DataProviderClass.Instance().UpdateStockUnit(stockunitCode, stockunit));
}
public static ReturnType AddStockUnit(StockUnit stockunit)
{
return(DataProviderClass.Instance().AddStockUnit(stockunit));
}
private void ExportStockUnitData(DocumentFormat.OpenXml.Wordprocessing.Document doc, StockUnit stockUnit)
{
string tag;
tag = "StockUnit:StockNumber";
FillRepeatingData(doc, tag, stockUnit.StockNumber, false);
tag = "StockUnit:StockName";
FillRepeatingData(doc, tag, stockUnit.StockName, false);
tag = "StockUnit:CreationDate";
FillRepeatingData(doc, tag, stockUnit.CreationDate.ToShortDateString(), false);
}
//after Save For Grid Data
public List <PRDChemProdReqItem> GetTransactionItemList(long _TransactionID, string _IssueFrom)
{
using (var context = new BLC_DEVEntities())
{
var StockResult = (from p in context.INV_ChemStockSupplier
where p.StoreID.ToString() == _IssueFrom
group p by new
{
//p.StoreID,
p.SupplierID,
p.PackSize,
p.ItemID,
p.SizeUnit,
p.UnitID
} into g
select new
{
TransectionID = g.Max(p => p.TransectionID),
//StoreID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.StoreID).FirstOrDefault(),
ItemID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ItemID).FirstOrDefault(),
SupplierID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SupplierID).FirstOrDefault(),
//UnitID = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault(),
PackSize = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackSize).FirstOrDefault(),
SizeUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.SizeUnit).FirstOrDefault(),
PackQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.PackClosingQty).FirstOrDefault(),
ClosingQty = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.ClosingQty).FirstOrDefault(),
StockUnit = g.Where(p => p.TransectionID == g.Max(q => q.TransectionID)).Select(x => x.UnitID).FirstOrDefault()
});
var Data = (from i in context.INV_StoreTransItem
where i.TransactionID == _TransactionID
// Stock Size
from s in StockResult.Where(x => x.ItemID == i.ItemID && x.PackSize == i.PackSize && x.SizeUnit == i.SizeUnit && x.SupplierID == i.SupplierID).DefaultIfEmpty()
join si in context.Sys_Size on(s == null ? null : s.PackSize) equals si.SizeID into StockSize
from si in StockSize.DefaultIfEmpty()
join siu in context.Sys_Unit on(s == null ? null : s.SizeUnit) equals siu.UnitID into StockSizeUnit
from siu in StockSizeUnit.DefaultIfEmpty()
join su in context.Sys_Unit on(s == null ? null : s.StockUnit) equals su.UnitID into StockUnit
from su in StockUnit.DefaultIfEmpty()
// Stock Size
join it in context.Sys_ChemicalItem on(i == null ? null : i.ItemID) equals it.ItemID into Chemicals
from it in Chemicals.DefaultIfEmpty()
join sup in context.Sys_Supplier on(i == null ? null : i.SupplierID) equals sup.SupplierID into Suppliers
from sup in Suppliers.DefaultIfEmpty()
join iu in context.Sys_Unit on(i == null ? null : i.TransactionUnit) equals iu.UnitID into IUnits
from iu in IUnits.DefaultIfEmpty()
join issuesize in context.Sys_Size on(i == null ? null : i.PackSize) equals issuesize.SizeID into IssueSizes
from issuesize in IssueSizes.DefaultIfEmpty()
join issuesizeunit in context.Sys_Unit on(i == null ? null : i.SizeUnit) equals issuesizeunit.UnitID into IssueSizeUnit
from issuesizeunit in IssueSizeUnit.DefaultIfEmpty()
orderby(it == null ? null : it.ItemName)
select new PRDChemProdReqItem
{
TransItemID = i.TransItemID,
ItemID = i.ItemID,
ItemName = (it == null ? null : it.ItemName),
SupplierID = i.SupplierID,
SupplierName = (sup == null ? null : sup.SupplierName),
PackSize = (s == null ? 0 : s.PackSize),
PackSizeName = (si == null ? null : si.SizeName),
SizeUnit = (s == null ? 0 : s.SizeUnit),
SizeUnitName = (siu == null ? null : siu.UnitName),
PackQty = (s == null ? 0 : (Int32)(s.PackQty)),
StockQty = (s == null ? 0 : s.ClosingQty),
StockUnit = (s == null ? 0 : s.StockUnit),
StockUnitName = (su == null ? null : su.UnitName),
IssuePackSize = i.PackSize,
IssuePackSizeName = (issuesize == null ? null : issuesize.SizeName),
IssueSizeUnit = i.SizeUnit,
IssueSizeUnitName = (issuesizeunit == null ? null : issuesizeunit.UnitName),
IssuePackQty = i.PackQty,
IssueQty = i.TransactionQty,
IssueUnitName = (iu == null ? null : iu.UnitName)
}).ToList();
return(Data);
}
}
public static ReturnType AddStockUnitGroup(StockUnitGroup stockunitgroup, StockUnit unit)
{
return(DataProviderClass.Instance().AddStockUnitGroup(stockunitgroup, unit));
}
