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 SingleResponeMessage <NewContractInfo> Get(int id, string _userID) { SingleResponeMessage <NewContractInfo> ret = new SingleResponeMessage <NewContractInfo>(); try { NewContractInfo item = ContractService.GetInstance().getContractNew(id, _userID); if (item == null) { ret.isSuccess = false; ret.err.msgCode = "001"; ret.err.msgString = "no Contract found"; return(ret); } ret.item = item; ret.isSuccess = true; } catch (Exception ex) { ret.isSuccess = false; ret.err.msgCode = "Internal Error !!!"; ret.err.msgString = ex.ToString(); } return(ret); }
public ContractPrintModel GetNegotiationPrintModel(int contractID, string _userID) { ContractPrintModel record = new ContractPrintModel(); NegotiationInfo info = new NegotiationInfo(); SqlConnectionFactory sqlConnection = new SqlConnectionFactory(); NewContractInfo contractInfo = getContractNew(contractID, _userID); using (SqlConnection connection = sqlConnection.GetConnection()) { info = NegotiationDataLayer.GetInstance().getNegotiation(connection, contractInfo.NegotiationID, _userID); if (record == null || info == null) { return(null); } CustomerInfo cusInfo = CustomerDataLayer.GetInstance().getCustomer(connection, info.CustomerID); record.ContractCode = contractInfo.ContractCode; record.DateIn = contractInfo.DateIn; 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.NegotiationTime = info.DateIn; record.Term = info.Term; record.NegotiationCode = info.NegotiationCode; 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.BidType = info.BidType; record.BidExpirated = info.BidExpirated; record.BidExpiratedUnit = info.BidExpiratedUnit; record.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, record.QuoteID); return(record); } }
public NewContractInfo getContractNew(SqlConnection connection, int _ID) { NewContractInfo info = null; using (var command = new SqlCommand(" Select * from tbl_Contract " + " where ContractID = @ContractID ", connection)) { AddSqlParameter(command, "@ContractID", _ID, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { info = new NewContractInfo(); info.ContractID = GetDbReaderValue <int>(reader["ContractID"]); info.ContractCode = GetDbReaderValue <string>(reader["ContractCode"]); info.NegotiationID = GetDbReaderValue <int>(reader["NegotiationID"]); info.DateIn = GetDbReaderValue <DateTime>(reader["DateIn"]); } } return(info); } }