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 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 ProposalDetailWithContactItemsInfo GetProposalWithContactItemsByCode(string code, string _userID)
{
ProposalDetailBase proposalDetail = new ProposalDetailBase();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
ProposalDetailWithContactItemsInfo ret;
using (SqlConnection connection = sqlConnection.GetConnection())
{
proposalDetail = ProposalDataLayer.GetInstance().getProposalDetailByCode(connection, code, _userID);
if (proposalDetail == null)
{
return(null);
}
ret = new ProposalDetailWithContactItemsInfo(proposalDetail);
int QuoteID = ProposalDataLayer.GetInstance().getQuoteIDWithHaveFinalContact(connection, proposalDetail.ProposalID);
QuoteInfo quote = QuoteDataLayer.GetInstance().getQuote(connection, QuoteID, _userID);
if (quote.TotalCost > 30000000)
{
ret.DeliveryReceiptType = 2;
}
else
{
ret.DeliveryReceiptType = 1;
}
ret.Items = new List <ItemInfo>();
ret.Items = QuoteDataLayer.GetInstance().GetQuoteItems(connection, QuoteID);
}
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.Quote.ToString(), id);
//delete commet
CommentSeachCriteria _criteria = new CommentSeachCriteria();
_criteria.TableName = TableFile.Quote.ToString();
_criteria.PreferId = id.ToString();
CommentDataLayer.GetInstance().DeleteComment(connection, _criteria);
QuoteService.GetInstance().deleteProcess(connection, "Quote", id.ToString(), _userID);
QuoteDataLayer.GetInstance().DeleteQuoteItemsByQuotesID(connection, id.ToString());
//delete record
QuoteDataLayer.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 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 int getTotalRecords(QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(QuoteDataLayer.GetInstance().getTotalRecords(connection, _criteria, _userID));
}
}
public List <QuoteInfo> getAllQuote(int pageSize, int pageIndex, QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(QuoteDataLayer.GetInstance().GetListQuote(connection, _criteria, _userID));
}
}
public List <QuoteInfo> getQuote(QuoteSeachCriteria _criteria, string _userID)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <QuoteInfo> ListQuote = QuoteDataLayer.GetInstance().GetListQuote(connection, _criteria, _userID);
return(ListQuote);
}
}
public List <SelectItem> getListquoteCodeCanCreateContract(string quoteCode)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <SelectItem> ListQuote = QuoteDataLayer.GetInstance().getListquoteCodeCanCreateContract(connection, quoteCode);
return(ListQuote);
}
}
public List <int> getExitsQuoteProposal(QuoteCreateRequest obj, string _userI)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <int> ListQuote = QuoteDataLayer.GetInstance().getExitsQuoteProposal(connection, obj.ProposalList, obj.CustomerList, _userI);
return(ListQuote);
}
}
public async Task <ActionMessage> editBidPlan(int id, BidPlanInfo _BidPlan, string _userU, IList <IFormFile> files, string _userID)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
var chkBidPlanInfo = BidPlanDataLayer.GetInstance().getBidPlan(connection, id, _userID);
if (chkBidPlanInfo != null)
{
try
{
QuoteInfo quoteInfo = QuoteDataLayer.GetInstance().getQuote(connection, _BidPlan.QuoteID, _userID);
if (quoteInfo != null)
{
_BidPlan.QuoteID = quoteInfo.QuoteID;
//var ProposalInfo = ProposalDataLayer.GetInstance().getProposalDetail(connection, _BidPlan.ProposalID);
//if (ProposalInfo != null)
//{
// _BidPlan.ProposalCode = ProposalInfo.ProposalCode;
//}
}
else
{
_BidPlan.QuoteID /*= _BidPlan.ProposalID*/ = 0;
}
BidPlanDataLayer.GetInstance().UpdateBidPlan(connection, id, _BidPlan, _userU);
}
catch (Exception ex)
{
throw ex;
}
}
DocumentService.GetInstance().DeleteDocumentsNotExitsInList(_BidPlan.ListDocument, TableFile.BidPlan.ToString(), _BidPlan.BidPlanID);
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.BidPlan.ToString();
documentInfo.PreferId = _BidPlan.BidPlanID.ToString();
documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
documentInfo.FileName = item.FileName;
documentInfo.Length = item.Length.ToString();
documentInfo.Type = item.ContentType;
ret = await FilesHelpers.UploadFile(TableFile.BidPlan.ToString(), _BidPlan.BidPlanID.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, _userU);
}
ret.isSuccess = true;
return(ret);
}
}
public List <searchProposalItemRespone> searchQuoteItem(string text)
{
List <searchProposalItemRespone> ret = new List <searchProposalItemRespone>();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
ret = QuoteDataLayer.GetInstance().searchQuoteItem(connection, text);
}
return(ret);
}
public List <ItemInfo> getItemsQuote(int QuoteID, int CustomerID)
{
List <ItemInfo> ret = new List <ItemInfo>();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
ret = QuoteDataLayer.GetInstance().GetQuoteItems(connection, QuoteID, CustomerID);
}
return(ret);
}
public List <searchQuoteRespone> searchQuoteCanCreateAudit(string text)
{
List <searchQuoteRespone> ret = new List <searchQuoteRespone>();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
ret = QuoteDataLayer.GetInstance().searchQuoteCanCreateAudit(connection, text);
}
return(ret);
}
public ActionMessage selectQuote(int QuoteID, int customerID)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
QuoteDataLayer.GetInstance().chooseQuote(connection, QuoteID, customerID);
ret.isSuccess = true;
}
return(ret);
}
public ActionMessage updateQuoteNew(int QuoteID, QuoteUpdateRequest data)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
QuoteDataLayer.GetInstance().updateQuoteNew(connection, QuoteID, data);
ret.isSuccess = true;
}
return(ret);
}
public SelectedQuoteInfo getSelectedItemsQuote(int QuoteID, string _userID)
{
SelectedQuoteInfo ret = new SelectedQuoteInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
ret = QuoteDataLayer.GetInstance().getQuoteInfo(connection, QuoteID, _userID);
ret.items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, QuoteID);
}
return(ret);
}
public async Task <ActionMessage> createBidPlan2(BidPlanInfo _BidPlan, string _userI, IList <IFormFile> files, string _userID)
{
ActionMessage ret = new ActionMessage();
int insetId = -1;
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
QuoteInfo quoteInfo = QuoteDataLayer.GetInstance().getQuote(connection, _BidPlan.QuoteID, _userID);
if (quoteInfo != null)
{
_BidPlan.QuoteID = quoteInfo.QuoteID;
}
else
{
_BidPlan.QuoteID /*= _BidPlan.ProposalID*/ = 0;
}
insetId = BidPlanDataLayer.GetInstance().InsertBidPlan(connection, _BidPlan, _userI);
}
catch (Exception ex)
{
throw ex;
}
if (insetId > -1)
{
ret.id = insetId;
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.BidPlan.ToString();
documentInfo.PreferId = insetId.ToString();
documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
documentInfo.FileName = item.FileName;
documentInfo.Length = item.Length.ToString();
documentInfo.Type = item.ContentType;
ret = await FilesHelpers.UploadFile(TableFile.BidPlan.ToString(), insetId.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, _userI.ToString());
}
ret.isSuccess = true;
}
else
{
ret.isSuccess = false;
ret.err.msgCode = "lỗi thêm biên bản họp giá";
ret.err.msgString = "lỗi thêm biên bản họp giá";
}
return(ret);
}
}
public DRFillDetailInfo getDetailsAcceptanceByProposalID(int id)
{
DRFillDetailInfo proposalDetail = new DRFillDetailInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
proposalDetail = ProposalDataLayer.GetInstance().getDetailsForDR(connection, id);
proposalDetail.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, proposalDetail.QuoteID);
proposalDetail.DeliveryReceiptItems = DeliveryReceiptDataLayer.GetInstance().getDetailsAcceptanceByProposalID(connection, id);
return(proposalDetail);
}
}
public ActionMessage CreateQuoteWithMutilProposal(QuoteCreateRequest QuoteObj, string _userI)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
int quoteId = 0;
quoteId = QuoteDataLayer.GetInstance().InsertQuoteWithOutDetails(connection, _userI);
int i = 0;
foreach (int customerID in QuoteObj.CustomerList)
{
if (QuoteObj.CustomerList.Length == 1)
{
QuoteDataLayer.GetInstance().InsertQuoteCustomer(connection, quoteId, customerID, true);
}
else
{
if (i == 0)
{
QuoteDataLayer.GetInstance().InsertQuoteCustomer(connection, quoteId, customerID, true);
}
else
{
QuoteDataLayer.GetInstance().InsertQuoteCustomer(connection, quoteId, customerID, false);
}
}
i++;
}
foreach (int proposalId in QuoteObj.ProposalList)
{
QuoteDataLayer.GetInstance().InsertQuoteProposal(connection, quoteId, proposalId);
}
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.Message;
}
}
return(ret);
}
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 List <QuoteAuditInfo> getListQuoteInfos(int auditID)
{
List <QuoteAuditInfo> ret = new List <QuoteAuditInfo>();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <int> QuoteIDs = AuditDataLayer.GetInstance().getQuoteOfAudit(connection, auditID);
foreach (int quoteID in QuoteIDs)
{
QuoteAuditInfo temp = QuoteDataLayer.GetInstance().GetChoosedQuoteDetails(connection, quoteID);
temp.ProposalCodes = QuoteDataLayer.GetInstance().GetListProsalCode(connection, quoteID);
temp.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, quoteID);
ret.Add(temp);
}
}
return(ret);
}
public DRFillDetailInfo getDetailsForDR(int id)
{
DRFillDetailInfo proposalDetail = new DRFillDetailInfo();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
proposalDetail = ProposalDataLayer.GetInstance().getDetailsForDR(connection, id);
proposalDetail.Items = QuoteDataLayer.GetInstance().getSelectedItemsQuote(connection, proposalDetail.QuoteID);
string IDs = "( ";
foreach (var item in proposalDetail.Items)
{
IDs += item.QuoteItemID.ToString() + " ,";
}
IDs = IDs.Remove(IDs.Length - 1);
IDs += " )";
List <DeliveryReceiptItemInfoNew> deliveryReceiptItems = DeliveryReceiptDataLayer.GetInstance().getItemsByQuoteIDs(connection, IDs);
foreach (var DRitem in deliveryReceiptItems)
{
for (int i = 0; i < proposalDetail.Items.Count;)
{
if (DRitem.QuoteItemID == proposalDetail.Items[i].QuoteItemID)
{
proposalDetail.Items[i].Amount = proposalDetail.Items[i].Amount - DRitem.Amount;
}
if (proposalDetail.Items[i].Amount > 0)
{
i++;
}
else
{
proposalDetail.Items.RemoveAt(i);
}
}
}
//todo
return(proposalDetail);
}
}
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 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 async Task <ActionMessage> importData(IFormFile file, int quoteID, int customerID)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
try
{
string fileExtension = Path.GetExtension(file.FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
// var rootFolder = @"D:\Files";
var rootFolder = Utils.getRootFolder();
var imageFolder = rootFolder + Utils.uploadFolder();
var fileName = DateTime.Now.ToString("yyyyMMddHHmmss");
var filePath = Path.Combine(rootFolder, fileName);
var fileLocation = new FileInfo(filePath);
using (var fileStream = new FileStream(filePath, FileMode.Create))
{
await file.CopyToAsync(fileStream);
}
using (ExcelPackage package = new ExcelPackage(fileLocation))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets["baogia"];
if (workSheet == null)
{
workSheet = package.Workbook.Worksheets.First();
}
int totalRows = workSheet.Dimension.Rows;
if (totalRows < 2)
{
ret.err.msgString = "Không có dữ liệu";
return(ret);
}
using (SqlConnection connection = sqlConnection.GetConnection())
{
QuoteDataLayer.GetInstance().deleteQuoteItem(connection, quoteID, customerID);
}
for (int i = 2; i <= totalRows; i++)
{
if (workSheet.Cells[i, 1].Value.ToString().Trim() == "")
{
break;
}
string itemName = workSheet.Cells[i, 1].Value.ToString().Trim();
string itemDescription = "";
if (workSheet.Cells[i, 2].Value != null)
{
itemDescription = workSheet.Cells[i, 2].Value.ToString().Trim();
}
string itemUnit = workSheet.Cells[i, 3].Value.ToString().Trim();
string itemAmount = workSheet.Cells[i, 4].Value.ToString().Trim();
string itemPrice = workSheet.Cells[i, 5].Value.ToString().Trim();
string itemTotalPrice = workSheet.Cells[i, 6].Value.ToString().Trim();
using (SqlConnection connection = sqlConnection.GetConnection())
{
QuoteDataLayer.GetInstance().insertQuoteItem(connection,
itemName, itemDescription, itemUnit
, itemPrice, itemAmount, itemTotalPrice, quoteID, customerID);
}
}
}
}
}
catch (Exception ex)
{
ret.err.msgString = ex.Message;
}
return(ret);
}
