public ActionMessage editDecision(int id, DecisionInfo _Decision, string _userU, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { var chkDecisionInfo = DecisionDataLayer.GetInstance().getDecision(connection, id, _userID); if (chkDecisionInfo != null) { try { DecisionDataLayer.GetInstance().UpdateDecision(connection, id, _Decision, _userU); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.ToString(); } } } return(ret); }
public ActionMessage createDecision(DecisionInfo _Decision, string _userI, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { var quoteInfo = QuoteDataLayer.GetInstance().getQuoteByCode(connection, _Decision.QuoteCode, _userID); if (quoteInfo != null) { _Decision.QuoteID = quoteInfo.QuoteID; } else { _Decision.QuoteID /* = _Decision.ProposalID*/ = 0; } ret.id = DecisionDataLayer.GetInstance().InsertDecision(connection, _Decision, _userI); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.Message; } } return(ret); }
public List <DecisionInfo> getAllDecision(int pageSize, int pageIndex, DecisionSeachCriteria _criteria, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { return(DecisionDataLayer.GetInstance().getDecision(connection, _criteria, _userID)); } }
public int getTotalRecords(DecisionSeachCriteria _criteria, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { return(DecisionDataLayer.GetInstance().getTotalRecords(connection, _criteria, _userID)); } }
public List <DecisionInfo> getDecision(DecisionSeachCriteria _criteria, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <DecisionInfo> ListDecision = DecisionDataLayer.GetInstance().getDecision(connection, _criteria, _userID); return(ListDecision); } }
public List <string> GetListDecisionByCode(string code, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <string> ListAudit = DecisionDataLayer.GetInstance().GetListDecisionByCode(connection, code, _userID); return(ListAudit); } }
//public ActionMessage deleteDecisions(string ids) //{ // ActionMessage ret = new ActionMessage(); // SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); // using (SqlConnection connection = sqlConnection.GetConnection()) // { // try // { // DecisionDataLayer.GetInstance().DeleteDecision(connection, ids); // ret.isSuccess = true; // } // catch (Exception ex) // { // ret.isSuccess = false; // ret.err.msgCode = "Internal Error"; // ret.err.msgString = ex.ToString(); // } // } // return ret; //} public List <string> getListDecisionCode(string decisionCode, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <string> ListDecision = DecisionDataLayer.GetInstance().getListDecisionCode(connection, decisionCode, _userID); return(ListDecision); } }
public int createDecision2(DecisionInfo _Decision, string _userI) { int ret = -1; SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { ret = DecisionDataLayer.GetInstance().InsertDecision(connection, _Decision, _userI); } catch (Exception ex) { ret = -1; } } return(ret); }
public DecisionInfo GetDecisionByCode(string code, string _userID) { DecisionInfo record = new DecisionInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = DecisionDataLayer.GetInstance().GetDecisionByCode(connection, code, _userID); if (record == null) { return(null); } record.Items = new List <ItemInfo>(); record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Decision.ToString(); documentCriteria.PreferId = record.QuoteID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Decision.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 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.Decision.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.Decision.ToString(), ids); //delete records List <string> quoteID = DecisionDataLayer.GetInstance().GetQuoteByDecisionIds(connection, ids); QuoteService.GetInstance().deleteProcess(connection, "Decision", String.Join(", ", quoteID.ToArray()), _userID); DecisionDataLayer.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 createContract(ContractInfo _Contract, string _userI, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { var DecisionInfo = DecisionDataLayer.GetInstance().GetDecisionByCode(connection, _Contract.DecisionCode, _userID); if (DecisionInfo != null) { _Contract.DecisionID = DecisionInfo.DecisionID; //Bỏ proposalID từ Dicision //_Contract.ProposalID = DecisionInfo.ProposalID; var ProposalInfo = ProposalDataLayer.GetInstance().getProposalDetail(connection, _Contract.ProposalID, ""); if (ProposalInfo != null) { _Contract.ProposalCode = ProposalInfo.ProposalCode; } } else { _Contract.DecisionID = _Contract.ProposalID = 0; } ret.id = ContractDataLayer.GetInstance().InsertContract(connection, _Contract, _userI); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.Message; } } return(ret); }
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; } }