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 ActionMessage DeleteAll(string ids) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { //delete comments CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Explanation.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.Explanation.ToString(), ids); //delete records ExplanationDataLayer.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) { 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.Acceptance.ToString(), id); //delete commet CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Acceptance.ToString(); _criteria.PreferId = id.ToString(); CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); //delete record AcceptanceDataLayer.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 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.Negotiation.ToString(), id); //delete commet CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Negotiation.ToString(); _criteria.PreferId = id.ToString(); CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); //delete record List <string> quoteID = NegotiationDataLayer.GetInstance().GetQuoteByNegotiationIds(connection, id.ToString()); QuoteService.GetInstance().deleteProcess(connection, "Negotiation", String.Join(", ", quoteID.ToArray()), _userID); NegotiationDataLayer.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 ContractInfo getContract(int _ID, string _userID) { ContractInfo record = new ContractInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = ContractDataLayer.GetInstance().getContract(connection, _ID, _userID); record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); //bidPlanDetail.ListMember = BidPlanDataLayer.GetInstance().GetBidPlanMembers(connection, _ID); //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 void DeleteComment(SqlConnection connection, CommentSeachCriteria _criteria) { using (var command = new SqlCommand(" delete tbl_Comment where TableName=@TableName and PreferId = @PreferId ", connection)) { AddSqlParameter(command, "@TableName", _criteria.TableName, System.Data.SqlDbType.VarChar); AddSqlParameter(command, "@PreferId", _criteria.PreferId, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); command.ExecuteScalar(); } }
public ActionMessage DeleteMuti(string ids, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { //delete employees List <DeliveryReceiptEmployeeInfo> currentItems = DeliveryReceiptDataLayer.GetInstance().GetDeliveryReceiptEmployeesByIds(connection, ids); if (currentItems.Count > 0) { string autoIds = ""; foreach (var item in currentItems) { autoIds = autoIds + item.AutoID + ','; } autoIds = autoIds.Remove(autoIds.Length - 1); DeliveryReceiptDataLayer.GetInstance().DeleteDeliveryReceiptEmployees(connection, autoIds); } //delete comments CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.DeliveryReceipt.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.DeliveryReceipt.ToString(), ids); //delete records /* List<string> acceptanceSids = AcceptanceDataLayer.GetInstance().getAcceptanceByDeliveryReceiptids(connection,ids); * if (acceptanceSids.Count > 0) { * AcceptanceDataLayer.GetInstance().DeleteMuti(connection,String.Join(", ", acceptanceSids.ToArray())); * }*/ List <string> quoteID = DeliveryReceiptDataLayer.GetInstance().GetQuoteByDeliveryReceiptIds(connection, ids); QuoteService.GetInstance().deleteProcess(connection, "DeliveryReceipt", String.Join(", ", quoteID.ToArray()), _userID); DeliveryReceiptDataLayer.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 Items Table List <AuditEmployeeInfo> currentItems = AuditDataLayer.GetInstance().GetAuditEmployeesById(connection, id.ToString()); if (currentItems.Count > 0) { string autoIds = ""; foreach (var item in currentItems) { autoIds = autoIds + item.AutoID + ','; } autoIds = autoIds.Remove(autoIds.Length - 1); // AuditDataLayer.GetInstance().DeleteAuditEmployees(connection, autoIds); } //delete attach files and DB of attach files DocumentService.GetInstance().DeleteDocumentByFeature(TableFile.Audit.ToString(), id); //delete commet CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Audit.ToString(); _criteria.PreferId = id.ToString(); CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); //delete Process List <string> quoteID = AuditDataLayer.GetInstance().GetQuoteByAuditIds(connection, id.ToString()); QuoteService.GetInstance().deleteProcess(connection, "Audit", String.Join(", ", quoteID.ToArray()), _userID); AuditDataLayer.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 List <CommentInfo> getComment(CommentSeachCriteria _criteria) { if (!string.IsNullOrEmpty(_criteria.TableName) && !string.IsNullOrEmpty(_criteria.PreferId)) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { List <CommentInfo> ListComment = CommentDataLayer.GetInstance().getComment(connection, _criteria); return(ListComment); } } else { return(null); } }
public ContractInfo GetContractByCode(string code, string _userID) { ContractInfo record = new ContractInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = ContractDataLayer.GetInstance().GeContractByCode(connection, code, _userID); if (record == null) { return(null); } record.Items = new List <ItemInfo>(); record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID); QuoteInfo quote = QuoteDataLayer.GetInstance().getQuote(connection, record.QuoteID, _userID); if (quote.TotalCost > 30000000) { record.DeliveryReceiptType = 2; } else { record.DeliveryReceiptType = 1; } //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Contract.ToString(); documentCriteria.PreferId = record.QuoteID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Contract.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 ProposalDetailInfo GetDetailProposalByCode(string code, string _userID) { ProposalDetailBase proposalDetail = new ProposalDetailBase(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); ProposalDetailInfo ret; using (SqlConnection connection = sqlConnection.GetConnection()) { proposalDetail = ProposalDataLayer.GetInstance().getProposalDetailByCode(connection, code, _userID); if (proposalDetail == null) { return(null); } ret = new ProposalDetailInfo(proposalDetail); ret.ListComment = new List <CommentInfo>(); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Proposal.ToString(); documentCriteria.PreferId = proposalDetail.ProposalID.ToString(); ret.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); ret.Items = new List <ItemPropsalInfo>(); ret.Items = ProposalDataLayer.GetInstance().GetPropsalItems(connection, proposalDetail.ProposalID); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Proposal.ToString(); commentCriteria.PreferId = proposalDetail.ProposalID.ToString(); ret.ListComment = CommentService.GetInstance().getComment(commentCriteria); foreach (var item in ret.ListComment) { DocumentSeachCriteria documentCriteria2 = new DocumentSeachCriteria(); documentCriteria2.TableName = TableFile.Comment.ToString(); documentCriteria2.PreferId = item.AutoID.ToString(); item.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria2); } } return(ret); }
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 QuoteInfo GetQuoteDetailsBycode(string code, string _userID) { QuoteInfo record = new QuoteInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = QuoteDataLayer.GetInstance().getQuoteByCode(connection, code, _userID); if (record == null) { return(null); } record.ListComment = new List <CommentInfo>(); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Quote.ToString(); documentCriteria.PreferId = record.QuoteID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); record.Items = new List <ItemInfo>(); record.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, record.QuoteID); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Quote.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 AuditDetailInfo getAuditInfo(int _ID, string _userID) { AuditDetailInfo record = new AuditDetailInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = AuditDataLayer.GetInstance().getAudtiGeneralInfo(connection, _ID, _userID); if (record == null) { return(null); } record.Quotes = getListQuoteInfos(_ID); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Audit.ToString(); documentCriteria.PreferId = _ID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); record.Employees = new List <AuditEmployeeInfo>(); record.Employees = AuditDataLayer.GetInstance().GetAuditEmployeesById(connection, record.AuditID.ToString()); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Audit.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 List <CommentInfo> getComment(SqlConnection connection, CommentSeachCriteria _criteria) { var result = new List <CommentInfo>(); using (var command = new SqlCommand("Select C.*, U.UserName " + " from tbl_Comment C left join tbl_User U on C.UserI = U.UserID where 1 = 1 ", connection)) { if (!string.IsNullOrEmpty(_criteria.TableName)) { command.CommandText += " and TableName = @TableName"; AddSqlParameter(command, "@TableName", _criteria.TableName, System.Data.SqlDbType.VarChar); } if (!string.IsNullOrEmpty(_criteria.PreferId)) { command.CommandText += " and PreferId = @PreferId"; AddSqlParameter(command, "@PreferId", _criteria.PreferId, System.Data.SqlDbType.Int); } command.CommandText += " order by InTime "; WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new CommentInfo(); info.AutoID = GetDbReaderValue <int>(reader["AutoID"]); info.TableName = GetDbReaderValue <string>(reader["TableName"]); info.PreferId = GetDbReaderValue <int>(reader["PreferId"]).ToString(); info.Comment = GetDbReaderValue <string>(reader["Comment"]); info.UserI = GetDbReaderValue <string>(reader["UserI"]); info.UserName = GetDbReaderValue <string>(reader["UserName"]); info.Intime = GetDbReaderValue <DateTime?>(reader["InTime"]); result.Add(info); } } return(result); } }
public AcceptanceInfo GetDetail(int id, string _userID) { SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); AcceptanceInfo record = new AcceptanceInfo(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = AcceptanceDataLayer.GetInstance().GetDetail(connection, id, _userID); if (record == null) { return(null); } record.ListComment = new List <CommentInfo>(); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Acceptance.ToString(); documentCriteria.PreferId = id.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); record.Items = new List <DeliveryReceiptItemInfoNew>(); record.Items = DeliveryReceiptDataLayer.GetInstance().getSelectedItems(connection, record.DeliveryReceiptID, _userID); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Acceptance.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 ExplanationDetailInfo getDetailExplanation(int _ID, string _userID) { ExplanationDetailInfo record = new ExplanationDetailInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = ExplanationDataLayer.GetInstance().getExplanationDetail(connection, _ID, _userID); if (record == null) { return(null); } //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Explanation.ToString(); documentCriteria.PreferId = _ID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); record.Items = new List <ItemPropsalInfo>(); record.Items = ProposalDataLayer.GetInstance().GetPropsalItems(connection, record.ProposalID); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Explanation.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 DecisionInfo GetDecision(int _ID, string _userID) { DecisionInfo record = new DecisionInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { record = DecisionDataLayer.GetInstance().getDecision(connection, _ID, _userID); if (record == null) { return(null); } record.Items = new List <ItemInfo>(); record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); record.DepartmentNames = DepartmentDataLayer.GetInstance().GetDepartmentNamesFromQuote(connection, record.QuoteID); //Get document DocumentSeachCriteria documentCriteria = new DocumentSeachCriteria(); documentCriteria.TableName = TableFile.Decision.ToString(); documentCriteria.PreferId = _ID.ToString(); record.ListDocument = DocumentService.GetInstance().GetDocument(documentCriteria); //get Comment CommentSeachCriteria commentCriteria = new CommentSeachCriteria(); commentCriteria.TableName = TableFile.Decision.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.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 DeleteProposal(int id, string user, string _userID) { ActionMessage ret = new ActionMessage(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { ProposalDetailInfo temp = ProposalService.GetInstance().getDetailProposal(id, ""); UserLogInfo info = new UserLogInfo(); info.Action = "Delete "; if (temp != null) { info.Description = "code : " + temp.ProposalCode + " id : " + id; } else { info.Description = " id : " + id; } info.Feature = TableFile.Proposal.ToString(); info.Time = DateTime.Now; info.UserName = user; info.UserID = 1; UserService.GetInstance().TrackUserAction(info); //delete Items Table List <ItemPropsalInfo> currentItems = ProposalDataLayer.GetInstance().GetPropsalItems(connection, id); if (currentItems.Count > 0) { string autoIds = ""; foreach (var item in currentItems) { autoIds = autoIds + item.AutoID + ','; } autoIds = autoIds.Remove(autoIds.Length - 1); ProposalDataLayer.GetInstance().DeleteProposalItems(connection, autoIds); } CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Proposal.ToString(); _criteria.PreferId = id.ToString(); CommentDataLayer.GetInstance().DeleteComment(connection, _criteria); //delete attach files and DB of attach files DocumentService.GetInstance().DeleteDocumentByFeature(TableFile.Proposal.ToString(), id); //deleteRelatedProsal // .. var quoteIds = QuoteDataLayer.GetInstance().GetQuotesByProposalId(connection,id.ToString()); // if(quoteIds.Count > 0) // QuoteService.DeleteMuti(String.Join(", ", quoteIds.ToArray())); var surveyIds = SurveyDataLayer.GetInstance().GetSurveyByProposalId(connection, id.ToString()); if (surveyIds.Count > 0) { SurveyDataLayer.GetInstance().DeleteMuti(connection, String.Join(", ", surveyIds.ToArray())); } var explanationServiceIds = ExplanationDataLayer.GetInstance().GetExplanationsByProposalId(connection, id.ToString(), _userID); if (explanationServiceIds.Count > 0) { ExplanationDataLayer.GetInstance().DeleteMuti(connection, String.Join(", ", explanationServiceIds.ToArray())); } //delete record ProposalDataLayer.GetInstance().DeleteProposal(connection, id); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.ToString(); } } return(ret); }
public ActionMessage DeleteProposals(string ids, string user, string _userID) { ActionMessage ret = new ActionMessage(); UserLogInfo info = new UserLogInfo(); info.Action = "Delete "; info.Description = " ids: " + ids; info.Feature = TableFile.Proposal.ToString(); info.Time = DateTime.Now; info.UserName = user; info.UserID = 1; UserService.GetInstance().TrackUserAction(info); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); using (SqlConnection connection = sqlConnection.GetConnection()) { try { //delete Items Table List <ItemPropsalInfo> currentItems = ProposalDataLayer.GetInstance().GetPropsalItemsByIds(connection, ids); if (currentItems.Count > 0) { string autoIds = ""; foreach (var item in currentItems) { autoIds = autoIds + item.AutoID + ','; } autoIds = autoIds.Remove(autoIds.Length - 1); ProposalDataLayer.GetInstance().DeleteProposalItems(connection, autoIds); } //delete comments CommentSeachCriteria _criteria = new CommentSeachCriteria(); _criteria.TableName = TableFile.Proposal.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.Proposal.ToString(), ids); //delete records /* //deleteRelatedProsal * var quoteIds = QuoteDataLayer.GetInstance().GetQuotesByProposalId(connection, ids); * * QuoteService.DeleteMuti(String.Join(", ", quoteIds.ToArray()));*/ var surveyIds = SurveyDataLayer.GetInstance().GetSurveyByProposalId(connection, ids); if (surveyIds != null && surveyIds.Count > 0) { SurveyDataLayer.GetInstance().DeleteMuti(connection, String.Join(", ", surveyIds.ToArray())); } var explanationServiceIds = ExplanationDataLayer.GetInstance().GetExplanationsByProposalId(connection, ids, _userID); if (explanationServiceIds != null && explanationServiceIds.Count > 0) { ExplanationDataLayer.GetInstance().DeleteMuti(connection, String.Join(", ", explanationServiceIds.ToArray())); } ProposalDataLayer.GetInstance().DeleteProposals(connection, ids); ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error"; ret.err.msgString = ex.Message; } } return(ret); }