public NewContractInfo getContractNew(int _ID, string _userID)
{
NewContractInfo record = new NewContractInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
record = ContractDataLayer.GetInstance().getContractNew(connection, _ID);
record.negotiation = NegotiationService.GetInstance().GetNegotiation(record.NegotiationID, _userID);
//Get document
DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria();
documentCriteria.TableName = TableFile.Contract.ToString();
documentCriteria.PreferId = _ID.ToString();
record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria);
//get Comment
CommentSeachCriteria commentCriteria = new CommentSeachCriteria();
commentCriteria.TableName = TableFile.Contract.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 TimeLineRecord GetProposalProccess2(int proposalID, string _userI, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
TimeLineRecord ret = new TimeLineRecord();
using (SqlConnection connection = sqlConnection.GetConnection())
{
ProcessInfo info = ProposalDataLayer.GetInstance().GetProposalProccessID(connection, proposalID);
if (info.ProposalID != 0)
{
ret.ProposalDetailInfo = ProposalService.GetInstance().getDetailProposal(info.ProposalID, _userI);
}
if (info.SurveyID != 0)
{
ret.SurveyDetailInfo = SurveyService.GetInstance().GetDetailSurvey(info.SurveyID, _userID);
}
if (info.ExplanationID != 0)
{
ret.ExplanationDetailInfo = ExplanationService.GetInstance().getDetailExplanation(info.ExplanationID, _userID);
}
if (info.QuoteID != 0)
{
ret.QuoteInfo = QuoteService.GetInstance().getQuote(info.QuoteID, _userID);
}
if (info.AuditID != 0)
{
ret.AuditDetailInfo = AuditService.GetInstance().getAuditInfo(info.AuditID, _userID);
}
if (info.BidPlanID != 0)
{
ret.BidPlanInfo = BidPlanService.GetInstance().getBidPlan(info.BidPlanID, _userID);
}
if (info.NegotiationID != 0)
{
ret.NegotiationInfo = NegotiationService.GetInstance().GetNegotiation(info.NegotiationID, _userID);
}
if (info.DecisionID != 0)
{
ret.DecisionInfo = DecisionService.GetInstance().GetDecision(info.DecisionID, _userID);
}
if (info.ContractID != 0)
{
ret.ContractInfo = ContractService.GetInstance().getContractNew(info.ContractID, _userID);
}
if (info.DeliveryReceiptID != 0)
{
ret.DeliveryReceiptInfo = DeliveryReceiptServices.GetInstance().GetDetail(info.DeliveryReceiptID, _userID);
}
if (info.AcceptanceID != 0)
{
ret.AcceptanceInfo = AcceptanceServices.GetInstance().GetDetail(info.AcceptanceID, _userID);
}
}
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;
}
}