public NegotiationInfo GetNegotiationByCode(string code) { NegotiationInfo record = new NegotiationInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = NegotiationDataLayer.GetInstance().GetNegotiationByCode(connection, code); if (record == null) { return(null); } record.Items = new List <ItemInfo>(); record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID); //bidPlanDetail.ListMember = BidPlanDataLayer.GetInstance().GetBidPlanMembers(connection, _ID); //negotiationDetail.ListMember = NegotiationDataLayer.GetInstance().GetNegotiationMembers(connection, _ID); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Negotiation.ToString(); documentCriteria.PreferId = record.QuoteID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Negotiation.ToString(); commentCriteria.PreferId = record.QuoteID.ToString(); record.ListComment = CommentService.GetInstance().getComment(commentCriteria); foreach (var item in record.ListComment) { DocumentSeachCriteria documentCriteria2 = new DocumentSeachCriteria(); documentCriteria2.TableName = TableFile.Comment.ToString(); documentCriteria2.PreferId = item.AutoID.ToString(); item.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria2); } return(record); } }
public NegotiationInfo GetNegotiation(int _ID, string _userID) { NegotiationInfo record = new NegotiationInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = NegotiationDataLayer.GetInstance().getNegotiation(connection, _ID, _userID); if (record == null) { return(null); } record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Negotiation.ToString(); documentCriteria.PreferId = _ID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Negotiation.ToString(); commentCriteria.PreferId = _ID.ToString(); record.ListComment = CommentService.GetInstance().getComment(commentCriteria); foreach (var item in record.ListComment) { DocumentSeachCriteria documentCriteria2 = new DocumentSeachCriteria(); documentCriteria2.TableName = TableFile.Comment.ToString(); documentCriteria2.PreferId = item.AutoID.ToString(); item.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria2); } return(record); } }
public ActionMessage DeleteMuti(string ids, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { //delete comments CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Negotiation.ToString(); string[] IDsarray = ids.Split(','); foreach (string id in IDsarray) { _criteria.PreferId = id; CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); } //delete attach files and DB of attach files DocumentService.GetInstance().DeleteDocumentsByFeature(TableFile.Negotiation.ToString(), ids); //delete records List <string> quoteID = NegotiationDataLayer.GetInstance().GetQuoteByNegotiationIds(connection, ids); QuoteService.GetInstance().deleteProcess(connection, "Negotiation", String.Join(", ", quoteID.ToArray()), _userID); NegotiationDataLayer.GetInstance().DeleteMuti(connection, ids); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.Message; } } return(ret); }
public ActionMessage Delete(int id, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { //delete attach files and DB of attach files DocumentService.GetInstance().DeleteDocumentByFeature(TableFile.BidPlan.ToString(), id); //delete commet CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.BidPlan.ToString(); _criteria.PreferId = id.ToString(); CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); //delete record List <string> negotiationIDs = NegotiationDataLayer.GetInstance().GetNegotiationByBidPlanIds(connection, id.ToString()); List <string> quoteID = BidPlanDataLayer.GetInstance().GetQuoteByBidPlanIds(connection, id.ToString()); QuoteService.GetInstance().deleteProcess(connection, "BidPlan", String.Join(", ", quoteID.ToArray()), _userID); BidPlanDataLayer.GetInstance().Delete(connection, id); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.ToString(); } } return(ret); }
public NegotiationPrintModel GetNegotiationPrintModel(int _ID, string _userID) { NegotiationPrintModel record = new NegotiationPrintModel(); NegotiationInfo info = new NegotiationInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); SearchAuditInfo auditInfo = new SearchAuditInfo(); using (SqlConnection connection = sqlConnection.GetConnection()) { info = NegotiationDataLayer.GetInstance().getNegotiation(connection, _ID, _userID); if (record == null) { return(null); } CustomerInfo cusInfo = CustomerDataLayer.GetInstance().getCustomer(connection, info.CustomerID); auditInfo = AuditDataLayer.GetInstance().getAuditInfoByQuote(connection, info.QuoteID); BidPlanPrint bidPlanInfo = BidPlanDataLayer.GetInstance().getBidPlanInfoByQuote(connection, info.QuoteID); record.ASide = "BỆNH VIỆN TRUYỀN MÁU HUYẾT HỌC"; record.BSide = info.CustomerName; record.ALocation = info.Location; record.APhone = info.Phone; record.AFax = info.Fax; record.ABankID = info.BankID; record.ATaxCode = info.TaxCode; record.ARepresent = info.Represent; record.APosition = info.Position; record.BLocation = cusInfo.Address; record.BPhone = cusInfo.Phone; record.BFax = cusInfo.Fax; record.BBankID = cusInfo.BankNumber + " " + cusInfo.BankName; record.BTaxCode = cusInfo.TaxCode; record.BRepresent = cusInfo.Surrogate; record.BPosition = cusInfo.Position; record.DateIn = info.DateIn; record.Term = info.Term; record.NegotiationCode = info.NegotiationCode; record.AuditTime = auditInfo.InTime; record.AuditCode = auditInfo.AuditCode; record.VATNumber = info.VATNumber; record.IsVAT = info.IsVAT; record.QuoteTotalCost = info.QuoteTotalCost; record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); record.QuoteID = info.QuoteID; record.QuoteCode = info.QuoteCode; record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); record.BidExpirated = info.BidExpirated; record.BidExpiratedUnit = info.BidExpiratedUnit; record.BidType = info.BidType; return(record); } }
public void deleteProcess(SqlConnection connection, string feature, string quoteIds, string _userID) { switch (feature) { case "Quote": List <string> auditIds = AuditDataLayer.GetInstance().GetAuditByQuoteIds(connection, quoteIds); if (auditIds.Count > 0) { AuditService.GetInstance().DeleteMuti(String.Join(", ", auditIds.ToArray()), _userID); } List <string> bidPlans = BidPlanDataLayer.GetInstance().GetBidPlanByQuoteIds(connection, quoteIds); if (bidPlans.Count > 0) { BidPlanService.GetInstance().DeleteMuti(String.Join(", ", bidPlans.ToArray()), _userID); } List <string> negotiationIDs = NegotiationDataLayer.GetInstance().GetNegotiationByQuoteIds(connection, quoteIds); if (negotiationIDs.Count > 0) { NegotiationService.GetInstance().DeleteMuti(String.Join(", ", negotiationIDs.ToArray()), _userID); } List <string> decisonIDs = DecisionDataLayer.GetInstance().GetDecisionByQuoteIds(connection, quoteIds); if (decisonIDs.Count > 0) { DecisionService.GetInstance().DeleteMuti(String.Join(", ", decisonIDs.ToArray()), _userID); } List <string> contractIDs = ContractDataLayer.GetInstance().GetContractByQuoteIds(connection, quoteIds, _userID); if (contractIDs.Count > 0) { ContractService.GetInstance().deleteMuti(String.Join(", ", contractIDs.ToArray()), _userID); } List <string> deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } List <string> acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "Audit": bidPlans = BidPlanDataLayer.GetInstance().GetBidPlanByQuoteIds(connection, quoteIds); if (bidPlans.Count > 0) { BidPlanService.GetInstance().DeleteMuti(String.Join(", ", bidPlans.ToArray()), _userID); } negotiationIDs = NegotiationDataLayer.GetInstance().GetNegotiationByQuoteIds(connection, quoteIds); if (negotiationIDs.Count > 0) { NegotiationService.GetInstance().DeleteMuti(String.Join(", ", negotiationIDs.ToArray()), _userID); } decisonIDs = DecisionDataLayer.GetInstance().GetDecisionByQuoteIds(connection, quoteIds); if (decisonIDs.Count > 0) { DecisionService.GetInstance().DeleteMuti(String.Join(", ", decisonIDs.ToArray()), _userID); } contractIDs = ContractDataLayer.GetInstance().GetContractByQuoteIds(connection, quoteIds, _userID); if (contractIDs.Count > 0) { ContractService.GetInstance().deleteMuti(String.Join(", ", contractIDs.ToArray()), _userID); } deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "BidPlan": negotiationIDs = NegotiationDataLayer.GetInstance().GetNegotiationByQuoteIds(connection, quoteIds); if (negotiationIDs.Count > 0) { NegotiationService.GetInstance().DeleteMuti(String.Join(", ", negotiationIDs.ToArray()), _userID); } decisonIDs = DecisionDataLayer.GetInstance().GetDecisionByQuoteIds(connection, quoteIds); if (decisonIDs.Count > 0) { DecisionService.GetInstance().DeleteMuti(String.Join(", ", decisonIDs.ToArray()), _userID); } contractIDs = ContractDataLayer.GetInstance().GetContractByQuoteIds(connection, quoteIds, _userID); if (contractIDs.Count > 0) { ContractService.GetInstance().deleteMuti(String.Join(", ", contractIDs.ToArray()), _userID); } deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "Negotiation": decisonIDs = DecisionDataLayer.GetInstance().GetDecisionByQuoteIds(connection, quoteIds); if (decisonIDs.Count > 0) { DecisionService.GetInstance().DeleteMuti(String.Join(", ", decisonIDs.ToArray()), _userID); } contractIDs = ContractDataLayer.GetInstance().GetContractByQuoteIds(connection, quoteIds, _userID); if (contractIDs.Count > 0) { ContractService.GetInstance().deleteMuti(String.Join(", ", contractIDs.ToArray()), _userID); } deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "Decision": contractIDs = ContractDataLayer.GetInstance().GetContractByQuoteIds(connection, quoteIds, _userID); if (contractIDs.Count > 0) { ContractService.GetInstance().deleteMuti(String.Join(", ", contractIDs.ToArray()), _userID); } deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "Contract": deliveryReceiptIDs = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptByQuoteIds(connection, quoteIds); if (deliveryReceiptIDs.Count > 0) { DeliveryReceiptServices.GetInstance().DeleteMuti(String.Join(", ", deliveryReceiptIDs.ToArray()), _userID); } acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; case "DeliveryReceipt": acceptanceIDs = AcceptanceDataLayer.GetInstance().GetAcceptanceByQuoteIds(connection, quoteIds); if (acceptanceIDs.Count > 0) { AcceptanceServices.GetInstance().DeleteMuti(String.Join(", ", acceptanceIDs.ToArray())); } break; default: break; } }