public static void PrepareDS(DSReport ds, Data.Model.Document document, DataSet groupByPrice) { Data.DSReport.DocumentRow rowd = ds.Document.NewDocumentRow(); rowd.ID = (int)document.ID; rowd.DocumentNo = document.DocumentNo; rowd.DocumentType = ((DocumentType)document.DocumentType).AsString(EnumFormat.Description); //rowd.DocumentType = Enum.GetName(typeof(DocumentType), document.DocumentType); rowd.DocumentDateTime = document.DocumentDateTime; rowd.PaymentDate = document.PaymentDate; rowd.PaymentEndDate = document.PaymentEndDate; rowd.ClientID = (int)document.ClientID; rowd.GroupByPrice = ""; foreach (DataRow d in groupByPrice.Tables[0].Rows) { rowd.GroupByPrice += "Cena: " + d["StartWith"] + "; Površina: " + d["Surface"] + Environment.NewLine; } rowd.TotalPrice = document.TotalPrice; ds.Document.AddDocumentRow(rowd); foreach (var item in document.DocumentItems) { Data.DSReport.DocumentItemRow row = ds.DocumentItem.NewDocumentItemRow(); row.ItemPrice = item.ItemPrice; row.DocumentID = (int)document.ID; row.ArticleNo = item.ArticleNo; row.ItemPrice = item.ItemPrice; row.Name = item.Article.Name; row.Note = item.Note; row.OrderDate = item.OrderDate; row.ItemID = (int)item.Article.ID; row.Quantity = item.Quantity; row.QuantityItemPrice = item.QuantityItemPrice; row.Height = item.Height; row.Width = item.Width; row.Surface = item.Surface; //row.Name = "test"; ds.DocumentItem.AddDocumentItemRow(row); } Data.DSReport.ClientRow rowc = ds.Client.NewClientRow(); rowc.Address = document.Client.Address; rowc.ID = (int)document.ClientID; rowc.Name = document.Client.Name; rowc.Phone = document.Client.Phone; rowc.PhoneFax = document.Client.PhoneFax; rowc.PIB = document.Client.PIB; rowc.MB = document.Client.MB; rowc.BankAccount = document.Client.BankAccount; rowc.Email = document.Client.Email; ds.Client.AddClientRow(rowc); ds.AcceptChanges(); }
public static void GenerateDefaultDocuments(Guid pIdTransaction, Guid pFirmInstitution) { using (UpsilabEntities context = new UpsilabEntities()) { var documentCategories = context.DocumentCategory.Where(docCateg => docCateg.idFirmInstitution == pFirmInstitution && docCateg.IsDocumentDefault); foreach (var docCategory in documentCategories) { Data.Model.Document doc = new Data.Model.Document() { DateCreated = DateTime.Now, IdDocumentCategory = docCategory.idDocumentCategory, idDocument = Guid.NewGuid(), idSignatureTransaction = pIdTransaction, Status = DocumentBL.Status.Created.ToString(), DocumentType = Upsilab.Business.Document.ElectronicSafeDocumentBL.DocumentType.DOC.ToString() }; context.Document.AddObject(doc); } var trans = context.SignatureTransaction.Where(st => st.idSignatureTransaction == pIdTransaction).FirstOrDefault(); trans.DocumentsInitialized = true; context.SaveChanges(); } }
public static void AddDocument(Guid idDoc, string location, string name) { using (var db = new UpsilabEntities()) { var doc = db.Document.FirstOrDefault(x => x.idDocument == idDoc); var transaction = doc.SignatureTransaction; if (transaction != null) { //var docupdate = transaction.Document.FirstOrDefault(x => string.IsNullOrEmpty(x.Name) && string.IsNullOrEmpty(x.Location)); //if (docupdate != null) //{ // docupdate.Location = location; // docupdate.Name = name; //} //else var docupdate = new Data.Model.Document() { Name = name, Location = location, DateCreated = DateTime.Now, IdDocumentCategory = doc.IdDocumentCategory, idDocument = Guid.NewGuid(), idSignatureTransaction = doc.idSignatureTransaction, Status = DocumentBL.Status.Created.ToString(), DocumentType = Upsilab.Business.Document.ElectronicSafeDocumentBL.DocumentType.DOC.ToString() }; db.Document.AddObject(docupdate); db.SaveChanges(); } } }
private void InitDocument() { _articalLogic = new ArticalLogic(); _documentLogic = new DocumentLogic(); _warehouseLogic = new WarehouseLogic(); if (FormMode == FormMode.New) { _document = new Document(); _documentLogic.AddDocument(_document); // datum _document.DocumentDateTime = DateTime.Now; _document.PaymentEndDate = DateTime.Now; _document.PaymentDate = DateTime.Now; _document.DocumentType = DocumentTypeID; string documentNumber = ""; string middle = _documentLogic.GetLastNoForDoument(_document.DocumentDateTime.Year, DocumentTypeID) + "-" + DateTime.Now.Year; string end = ""; switch (DocumentTypeID) { case 0: documentNumber = "P"; break; case 1: documentNumber = "O"; break; case 2: _client = _documentForPayment.Client; _document.ClientID = _documentForPayment.ClientID; _document.TotalPrice = _documentForPayment.TotalPrice; documentNumber = "DO"; end = " {" + _documentForPayment.DocumentNo + "}"; // _client = _document.Client; _document.LinkDocumentNo = _documentForPayment.DocumentNo; _document.DocumentType = 2; break; default: break; } documentNumber += "-" + middle + end; _document.DocumentNo = documentNumber;// (DocumentTypeID == 0 ? "P" : "O") + "-" + _documentLogic.GetLastNoForDoument(_document.DocumentDateTime.Year, DocumentTypeID) + "-" + DateTime.Now.Year; } else if (FormMode == FormMode.Modifying || FormMode == FormMode.ReadOnly) { _document = _documentLogic.GetDocument(SelectedDocument.ID); _client = _document.Client; if (FormMode == FormMode.ReadOnly) { SetAllControlsReadOnly(); } } if (_client != null) { BindClientProperties(); } tbTotalWithVAT.DataBindings.Clear(); tbTotalWithVAT.DataBindings.Add("Text", _document, "TotalPrice"); tbDocumentNo.DataBindings.Clear(); tbDocumentNo.DataBindings.Add("Text", _document, "DocumentNo"); tbSpoljniBroj.DataBindings.Clear(); tbSpoljniBroj.DataBindings.Add("Text", _document, "LinkDocumentNo"); dtpCreationDate.DataBindings.Clear(); dtpCreationDate.DataBindings.Add("Value", _document, "DocumentDateTime"); dtpEndDateForPayment.DataBindings.Clear(); dtpEndDateForPayment.DataBindings.Add("Value", _document, "PaymentEndDate"); dtpPaymentDate.DataBindings.Clear(); dtpPaymentDate.DataBindings.Add("Value", _document, "PaymentDate"); // status cmbStatus.DisplayMember = "Description"; cmbStatus.DataSource = Enum.GetValues(typeof(Classes.Lib.StatusEnum)) .Cast <Enum>() .Select(value => new { (Attribute.GetCustomAttribute(value.GetType().GetField(value.ToString()), typeof(DescriptionAttribute)) as DescriptionAttribute).Description, v = (int)(Enum.Parse(typeof(Classes.Lib.StatusEnum), value.ToString())) }) .OrderBy(item => item.v) .ToList(); cmbStatus.SelectedIndex = _document.StatusID; // magacini cmbWarehouse.DataSource = _warehouseLogic.GetAllWarehouse(); cmbWarehouse.DisplayMember = "Name"; cmbWarehouse.ValueMember = "WarehouseTypeID"; cmbWarehouse.SelectedIndex = 1; cmbWarehouse.SelectedIndexChanged += CmbWarehouse_ValuseChanged; // tip dokumenta cmbDocumentType.DisplayMember = "Description"; cmbDocumentType.DataSource = Enum.GetValues(typeof(Classes.Lib.DocumentType)) .Cast <Enum>() .Select(value => new { (Attribute.GetCustomAttribute(value.GetType().GetField(value.ToString()), typeof(DescriptionAttribute)) as DescriptionAttribute).Description, v = (int)(Enum.Parse(typeof(Classes.Lib.DocumentType), value.ToString())) }) .OrderBy(item => item.v) .ToList(); cmbDocumentType.Enabled = false; cmbDocumentType.SelectedIndex = _document.DocumentType; this.Text = cmbDocumentType.Text; listaArtikla = _articalLogic.GetAllArticlesByWarehouseType(cmbWarehouse.SelectedIndex); documentItemBindingSource.DataSource = _document.DocumentItems; articleBindingSource.DataSource = listaArtikla; documentItemBindingSource.ListChanged += DocumentItemBindingSource_ListChanged; documentItemBindingSource.CurrentChanged += DocumentItemBindingSource_CurrentChanged; DGVReceiptsDespatchsItems.DataError += DGVReceiptsDespatchsItems_DataError; DGVReceiptsDespatchsItems.CellValueChanged += DGVReceiptsDespatchsItems_CellValueChanged; DGVReceiptsDespatchsItems.CellContentClick += DGVReceiptsDespatchsItems_CellContentClick; DGVReceiptsDespatchsItems.CellFormatting += DGVReceiptsDespatchsItems_CellFormatting; if (_document.DocumentType == (int)DocumentType.Payment) { DGVReceiptsDespatchsItems.Enabled = false; tbTotalWithVAT.Text = _document.TotalPrice.ToString("N2"); } else { inload = true; InitUnboundColumns(); inload = false; } DGVReceiptsDespatchsItems.Update(); DGVReceiptsDespatchsItems.Refresh(); }