public async Task <ActionResult> Create(ProductView view)
{
if (ModelState.IsValid)
{
var picture = string.Empty;
var folder = "~/Content/Products";
if (view.ImageFile != null)
{
picture = FilesHelpers.UploadPhoto(view.ImageFile, folder);
picture = $"{folder}/{picture}";
}
var product = this.ToProduct(view, picture);
try
{
db.Products.Add(product);
await db.SaveChangesAsync();
}
catch (Exception e)
{
}
return(RedirectToAction("Index"));
}
return(View(view));
}
public ActionResult Create(Product product)
{
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (ModelState.IsValid)
{
db.Products.Add(product);
db.SaveChanges();
if (product.ImageFile != null)
{
var folder = "~/Content/Products";
var file = string.Format("{0}-{1}.jpg", product.ProductId, product.Description);
var respose = FilesHelpers.UploadPhoto(product.ImageFile, folder, file);
if (respose)
{
var pic = string.Format("{0}/{1}", folder, file);
//si respose es true, actualizamos el logo de la compania
product.Image = pic;
//actalizamos la dv
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(CombosHelpers.GetCategories(user.CompanyId), "CategoryId", "Description", product.CategoryId);
ViewBag.TaxId = new SelectList(CombosHelpers.GetTaxes(user.CompanyId), "TaxId", "Description", product.TaxId);
return(View(product));
}
public async Task <IActionResult> DownloadAsync(string feature, string preferId, string fileName)
{
try
{
var rootFolder = Utils.getRootFolder();
var imageFolder = rootFolder + Utils.uploadFolder();
var filePath = imageFolder + @"/" + feature + @"/" + preferId + @"/" + fileName;
if (filePath == null)
{
return(Content("filename not present"));
}
var memory = new MemoryStream();
using (FileStream stream = new FileStream(filePath, FileMode.Open))
{
await stream.CopyToAsync(memory);
}
memory.Position = 0;
return(File(memory, FilesHelpers.GetContentType(filePath), Path.GetFileName(filePath)));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public async Task <ActionMessage> Create(AcceptanceInfo obj, [FromForm] List <IFormFile> files, string _userI)
{
ActionMessage ret = new ActionMessage();
int insetId = -1;
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
insetId = AcceptanceDataLayer.GetInstance().Create(connection, obj, _userI);
}
catch (Exception ex)
{
throw ex;
}
}
if (insetId > -1)
{
ret.id = insetId;
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
foreach (DeliveryReceiptItemInfoNew item in obj.Items)
{
ProposalDataLayer.GetInstance().UpdateItemAcceptance(connection, item, _userI);
}
}
catch (Exception ex)
{
throw ex;
}
}
if (files != null)
{
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Acceptance.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.Acceptance.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 phiếu nghiệm thu";
ret.err.msgString = "lỗi thêm phiếu nghiệm thu";
}
return(ret);
}
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
UsersHelper.CreateUserASP(user.UserName, "User");
if (user.PhotoFile != null)
{
var folder = "~/Content/Users";
var file = string.Format("{0}-{1}.jpg", user.UserId, user.FullName);
var respose = FilesHelpers.UploadPhoto(user.PhotoFile, folder, file);
if (respose)
{
var pic = string.Format("{0}/{1}", folder, file);
//si respose es true, actualizamos el logo de la compania
user.Photo = pic;
//actalizamos la dv
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(CombosHelpers.GetCities(), "CityId", "Name", user.CityId);
ViewBag.CompanyId = new SelectList(CombosHelpers.GetCompanies(), "CompanyId", "Name", user.CompanyId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", user.DepartmentId);
return(View(user));
}
public ActionResult Create(Company company)
{
if (ModelState.IsValid)
{
db.Companies.Add(company);
db.SaveChanges();
if (company.LogoFile != null)
{
var folder = "~/Content/Logos";
var file = string.Format("{0}-{1}.jpg", company.CompanyId, company.Name);
var respose = FilesHelpers.UploadPhoto(company.LogoFile, folder, file);
if (respose)
{
var pic = string.Format("{0}/{1}", folder, file);
//si respose es true, actualizamos el logo de la compania
company.Logo = pic;
//actalizamos la dv
db.Entry(company).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(CombosHelpers.GetCities(), "CityId", "Name", company.CityId);
ViewBag.DepartmentId = new SelectList(CombosHelpers.GetDepartments(), "DepartmentId", "Name", company.DepartmentId);
return(View(company));
}
public ActionResult Edit(Product product)
{
if (ModelState.IsValid)
{
if (product.ImageFile != null)
{
var pic = string.Empty;
var folder = "~/Content/Products";
var file = string.Format("{0}-{1}.jpg", product.ProductId, product.Description);
var respose = FilesHelpers.UploadPhoto(product.ImageFile, folder, file);
if (respose)
{
pic = string.Format("{0}/{1}", folder, file);
product.Image = pic;
}
}
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(CombosHelpers.GetCategories(product.CompanyId), "CategoryId", "Description", product.CategoryId);
ViewBag.TaxId = new SelectList(CombosHelpers.GetTaxes(product.CompanyId), "TaxId", "Description", product.TaxId);
return(View(product));
}
public async Task <ActionResult> Edit(ProductView view)
{
if (ModelState.IsValid)
{
var picture = view.ImagePath;
var folder = "~/Content/Products";
if (view.ImageFile != null)
{
picture = FilesHelpers.UploadPhoto(view.ImageFile, folder);
picture = $"{folder}/{picture}";
}
var product = this.ToProduct(view, picture);
try
{
db.Entry(product).State = EntityState.Modified;
await db.SaveChangesAsync();
}
catch (Exception e)
{
}
return(RedirectToAction("Index"));
}
return(View(view));
}
public async Task <ActionMessage> Put(int id, [FromForm] NegotiationInfo _Negotiation, [FromForm] List <IFormFile> files, string _userID)
{
ActionMessage ret = new ActionMessage();
try
{
ret = NegotiationService.GetInstance().editNegotiation(id, _Negotiation, GetUserId(), _userID);
//update list file
DocumentService.GetInstance().DeleteDocumentsNotExitsInList(_Negotiation.ListDocument, TableFile.Negotiation.ToString(), id);
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Negotiation.ToString();
documentInfo.PreferId = id.ToString();
documentInfo.FileName = item.FileName;
documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
documentInfo.Length = item.Length.ToString();
documentInfo.Type = item.ContentType;
ret = await FilesHelpers.UploadFile(TableFile.Negotiation.ToString(), _Negotiation.NegotiationID.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, GetUserId());
}
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public async Task <ActionMessage> PostwithAttFile([FromForm] NegotiationInfo NegotiationObj, [FromForm] List <IFormFile> files)
{
ActionMessage ret = new ActionMessage();
int insetId = -1;
try
{
insetId = NegotiationService.GetInstance().createNegotiation2(NegotiationObj, GetUserId());
ret.isSuccess = true;
if (insetId > -1)
{
ret.id = insetId;
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Negotiation.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.Negotiation.ToString(), insetId.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, GetUserId());
}
}
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public async Task <ActionMessage> EditExplanation(int id, ExplanationInfo _Explanation, string _userU, [FromForm] List <IFormFile> files)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
UserLogInfo info = new UserLogInfo();
info.Action = "Edit";
info.Description = "ngày : " + _Explanation.InTime + " code : " + _Explanation.ExplanationCode
+ " trạng thái : " + _Explanation.Status;
info.Feature = TableFile.Proposal.ToString();
info.Time = DateTime.Now;
info.UserName = _userU;
info.UserID = 1;
UserService.GetInstance().TrackUserAction(info);
ExplanationDataLayer.GetInstance().UpdateExplanation(connection, id, _Explanation, _userU);
}
catch (Exception ex)
{
throw ex;
}
}
DocumentService.GetInstance().DeleteDocumentsNotExitsInList(_Explanation.ListDocument, TableFile.Explanation.ToString(), id);
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
foreach (ItemPropsalInfo item in _Explanation.Items)
{
ProposalDataLayer.GetInstance().UpdateItemExplanation(connection, item, _userU);
}
}
catch (Exception ex)
{
throw ex;
}
}
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Explanation.ToString();
documentInfo.PreferId = id.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.Explanation.ToString(), id.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, _userU.ToString());
}
ret.isSuccess = true;
return(ret);
}
public ActionMessage DeleteDocuments(string ids)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
List <DocumentInfo> infos = DocumentDataLayer.GetInstance().GetDocumentsByIds(connection, ids);
if (infos.Count > 0)
{
foreach (DocumentInfo document in infos)
{
FilesHelpers.DeleteFile(document.TableName, document.PreferId, document.FileName);
}
}
DocumentDataLayer.GetInstance().DeleteDocuments(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 DeleteDocument(int id)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
DocumentInfo info = DocumentDataLayer.GetInstance().GetDocumentById(connection, id);
if (info.PreferId != null && info.TableName != "")
{
FilesHelpers.DeleteFile(info.TableName, info.PreferId, info.FileName);
}
DocumentDataLayer.GetInstance().DeleteDocument(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 DeleteDocumentsByFeature(string feature, string ids)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
string[] IDsarray = ids.Split(',');
foreach (string id in IDsarray)
{
FilesHelpers.DeleteFolder(feature, id);
DocumentDataLayer.GetInstance().DeleteDocumentByFeatureAndID(connection, feature, Int32.Parse(id));
}
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
return(ret);
}
public async Task <Data.Models.FileInfo> MoveTempFile(string tempFileName, string relativeFolderPath, string fileName)
{
var(fileNameWithoutExt, extension) = FilesHelpers.GetFileNameAndExtension(fileName);
var fileInfo = await fileProvider.MoveTempFile(tempFileName, relativeFolderPath, fileNameWithoutExt, extension);
var file = await CreateFileInfoToDb(relativeFolderPath, fileNameWithoutExt, extension);
return(file);
}
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 async Task <ActionMessage> Update(AcceptanceInfo obj, [FromForm] List <IFormFile> files, string _userI)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
AcceptanceDataLayer.GetInstance().Update(connection, obj, _userI);
}
catch (Exception ex)
{
throw ex;
}
}
DocumentService.GetInstance().DeleteDocumentsNotExitsInList(obj.ListDocument, TableFile.Acceptance.ToString(), obj.AcceptanceID);
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
foreach (DeliveryReceiptItemInfoNew item in obj.Items)
{
ProposalDataLayer.GetInstance().UpdateItemAcceptance(connection, item, _userI);
}
}
catch (Exception ex)
{
throw ex;
}
}
if (files != null)
{
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Acceptance.ToString();
documentInfo.PreferId = obj.AcceptanceID.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.Acceptance.ToString(), obj.AcceptanceID.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, _userI.ToString());
}
}
ret.isSuccess = true;
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 async Task <IActionResult> PostSubmitTask(CreateTaskSubmissionRequest request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var studentTask = await _context.StudentAssignedTasks
.FirstOrDefaultAsync(st => st.Id == request.StudentTaskId);
if (studentTask is null)
{
return(NotFound());
}
if (studentTask.StudentId != userManager.GetUserId(User))
{
return(Forbid());
}
var submission = new TaskSubmission {
AssignedTaskId = studentTask.Id,
State = TaskSubmissionState.Submitted,
DateAdded = DateTime.Now,
Files = new List <TaskSubmissionFile>(),
Description = request.Description
};
_context.TaskSubmissions.Add(submission);
await _context.SaveChangesAsync();
foreach (var uploadedFile in request.UploadedFiles)
{
var submissionFolder = $"StudentSubmissions/{studentTask.StudentId}/{studentTask.Id}/{submission.Id}";
// TODO: validate file extension.
var(fileName, extension) = FilesHelpers.GetFileNameAndExtension(uploadedFile.OriginalName);
var file = await fileService.MoveTempFile(uploadedFile.TempFileName, submissionFolder, uploadedFile.OriginalName);
submission.Files.Add(new TaskSubmissionFile {
FileId = file.Id,
FileType = TaskSubmissionFileType.SourceCode,
TaskSubmission = submission
});
}
await _context.SaveChangesAsync();
return(Ok());
}
public async Task <ActionMessage> Put(int id, [FromForm] ProposalInfo _proposal, [FromForm] List <IFormFile> files)
{
ActionMessage ret = new ActionMessage();
ret.isSuccess = true;
try
{
ret = ProposalService.GetInstance().editProposal(id, _proposal, GetUserId());
//update list file
//ProposalService.GetInstance().DelteDocument(id.ToString());
if (ret.isSuccess == false)
{
return(ret);
}
//++edit item
ret = ProposalService.GetInstance().EditItems(id, _proposal.Items);
if (ret.isSuccess == false)
{
return(ret);
}
//++EDIT document
//delete old document
DocumentService.GetInstance().DeleteDocumentsNotExitsInList(_proposal.Documents, TableFile.Proposal.ToString(), id);
//add new document
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Proposal.ToString();
documentInfo.PreferId = id.ToString();
documentInfo.FileName = item.FileName;
documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(item.FileName);
documentInfo.Length = item.Length.ToString();
documentInfo.Type = item.ContentType;
ret = await FilesHelpers.UploadFile(TableFile.Proposal.ToString(), _proposal.ProposalID.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, GetUserId());
}
//--EDIT document
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public async Task <ActionMessage> PostwithAttFile([FromForm] ProposalInfo propsalObj, [FromForm] List <IFormFile> files)
{
ActionMessage ret = new ActionMessage();
int insetId = -1;
try
{
ret.isSuccess = true;
insetId = ProposalService.GetInstance().createProposal2(propsalObj, GetUserId());
if (insetId > -1)
{
// upload file
//ret = await FilesHelpers.UploadFiles("proposal", insetId.ToString(), files);
// update list file
ret = ProposalService.GetInstance().insertItems(insetId, propsalObj.Items, propsalObj.DateIn, propsalObj.DepartmentID);
if (ret.isSuccess == false)
{
return(ret);
}
foreach (var item in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Proposal.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.Proposal.ToString(), insetId.ToString(), item, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, GetUserId());
}
}
else
{
ret.isSuccess = false;
ret.err.msgCode = "lỗi thêm proposal";
ret.err.msgString = "lỗi thêm proposal";
}
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error !!!";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public ActionResult Create(CategoriaVista categoriavista)
{
try
{
var pic = string.Empty;
var folder = "~/Content/ImagenesCategorias";
if (categoriavista.fotoFile != null)
{
pic = FilesHelpers.UploadPhoto(categoriavista.fotoFile, folder);
pic = $"{folder}/{pic}";
}
//almaceno los datos en la variable local
var categoria = this.ToCategoria(categoriavista, pic);
// comienza la conexión
MongoClientSettings settings = MongoClientSettings.FromUrl(
new MongoUrl(connectionString)
);
settings.SslSettings =
new SslSettings()
{
EnabledSslProtocols = SslProtocols.Tls12
};
var mongoClient = new MongoClient(settings);
//var client = new MongoClient(conec);
var db = mongoClient.GetDatabase(bdname);
var collectionSettings = new MongoCollectionSettings {
ReadPreference = ReadPreference.Nearest
};
// var cliente = new MongoClient(conec);
//var database = cliente.GetDatabase(bdname);
var listacategorias = db.GetCollection <Categoria>("Categoria");
//termina la conexión
listacategorias.InsertOneAsync(categoria);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
if (user.PhotoFile != null)
{
var pic = string.Empty;
var folder = "~/Content/Users";
var file = string.Format("{0}-{1}.jpg", user.UserId, user.FullName);
var respose = FilesHelpers.UploadPhoto(user.PhotoFile, folder, file);
if (respose)
{
pic = string.Format("{0}/{1}", folder, file);
//si respose es true, actualizamos el logo de la compania
user.Photo = pic;
}
}
var db2 = new ECommerceContext();
var currentUser = db2.Users.Find(user.UserId);
if (currentUser.UserName != user.UserName)
{
UsersHelper.UpdateUserName(currentUser.UserName, user.UserName);
}
db2.Dispose();
//actalizamos la dv
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(CombosHelpers.GetCities(), "CityId", "Name", user.CityId);
ViewBag.CompanyId = new SelectList(CombosHelpers.GetCompanies(), "CompanyId", "Name", user.CompanyId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", user.DepartmentId);
return(View(user));
}
public ActionResult Create(EntidadVista entidadvista)
{
try
{
var pic = string.Empty;
var folder = "~/Content/ImagenesEntidades";
if (entidadvista.fotoFile != null)
{
pic = FilesHelpers.UploadPhoto(entidadvista.fotoFile, folder);
pic = $"{folder}/{pic}";
}
//almaceno los datos en la variable local
var entidad = this.ToEntidad(entidadvista, pic);
string connectionString =
@"mongodb://*****:*****@appturismo.mongo.cosmos.azure.com:10255/?ssl=true&replicaSet=globaldb&maxIdleTimeMS=120000&appName=@appturismo@";
MongoClientSettings settings = MongoClientSettings.FromUrl(
new MongoUrl(connectionString)
);
settings.SslSettings =
new SslSettings()
{
EnabledSslProtocols = SslProtocols.Tls12
};
var mongoClient = new MongoClient(settings);
// var cliente = new MongoClient(conec);
//bd = cliente.GetDatabase(bdname);
var database = mongoClient.GetDatabase(bdname);
var entidades = database.GetCollection <Entidad>("Entidad");
entidades.InsertOneAsync(entidad);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public async Task <ActionResult> Edit(CategoryView view)
{
if (ModelState.IsValid)
{
var pic = view.ImagePath;
var folder = "~/Content/Categories";
if (view.ImageFile != null)
{
pic = FilesHelpers.UploadPhoto(view.ImageFile, folder);
pic = $"{folder}/{pic}";
}
var category = this.ToCategory(view, pic);
this.db.Entry(category).State = EntityState.Modified;
await this.db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(view));
}
public async Task <ActionResult> Create(CategoryView view)
{
if (ModelState.IsValid)
{
var pic = string.Empty;
var folder = "~/Content/Categories";
if (view.ImageFile != null)
{
pic = FilesHelpers.UploadPhoto(view.ImageFile, folder);
pic = $"{folder}/{pic}";
}
var category = this.ToCategory(view, pic);
this.db.Categories.Add(category);
await this.db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(view));
}
public async Task <Data.Models.FileInfo> MoveFile(Guid sourceFileId, string relativeFolderPath, string fileName)
{
var(fileNameWithoutExtension, extension) = FilesHelpers.GetFileNameAndExtension(fileName);
var file = await context.Files.FindAsync(sourceFileId);
if (file is null)
{
throw new InvalidOperationException("No file with the provided sourceFileId exists.");
}
var sourceFileInfo = await fileProvider.GetFile(file.RelativeFolderPath, file.FileName, file.Extension);
var fileInfo = await fileProvider.MoveFile(sourceFileInfo, relativeFolderPath, fileNameWithoutExtension, extension);
file.RelativeFolderPath = relativeFolderPath;
file.FileName = fileNameWithoutExtension;
file.Extension = extension;
await context.SaveChangesAsync();
return(file);
}
public async Task <ActionMessage> AddComment([FromForm] string preferId, [FromForm] string comment, [FromForm] string feature, [FromForm] List <IFormFile> files)
{
int insetId = -1;
ActionMessage ret = new ActionMessage();
try
{
CommentInfo commentInfo = new CommentInfo();
commentInfo.TableName = feature;
commentInfo.PreferId = preferId;
commentInfo.Comment = comment;
insetId = CommentService.GetInstance().InsertComment(commentInfo, GetUserId());
ret.isSuccess = true;
if (insetId > -1)
{
foreach (var file in files)
{
DocumentInfo documentInfo = new DocumentInfo();
documentInfo.TableName = TableFile.Comment.ToString();
documentInfo.PreferId = insetId.ToString();
documentInfo.Link = DateTime.Now.ToString("yyMMddHHmmssfff") + "-" + Utils.ChuyenTVKhongDau(file.FileName);
documentInfo.FileName = file.FileName;
documentInfo.Length = file.Length.ToString();
documentInfo.Type = file.ContentType;
ret = await FilesHelpers.UploadFile(documentInfo.TableName, insetId.ToString(), file, documentInfo.Link);
DocumentService.GetInstance().InsertDocument(documentInfo, GetUserId());
}
}
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Lỗi thêm comment";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public ActionMessage DeleteDocumentByFeature(string feature, int id)
{
ActionMessage ret = new ActionMessage();
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
try
{
FilesHelpers.DeleteFolder(feature, id.ToString());
DocumentDataLayer.GetInstance().DeleteDocumentByFeatureAndID(connection, feature, id);
ret.isSuccess = true;
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "Internal Error";
ret.err.msgString = ex.ToString();
}
}
return(ret);
}
public void DeleteDocumentsNotExitsInList(List <DocumentInfo> listDocument, string tableName, int preferId)
{
DocumentSeachCriteria _cri = new DocumentSeachCriteria();
_cri.TableName = tableName;
_cri.PreferId = preferId.ToString();
List <DocumentInfo> currentDocument = GetDocument(_cri);
List <DocumentInfo> listDelete = new List <DocumentInfo>();
if (listDocument == null)
{
listDelete = currentDocument;
}
else
{
listDelete = currentDocument.Where(el2 => !listDocument.Any(el1 => el1.AutoID == el2.AutoID)).ToList();
}
//delete data in tables
if (listDelete.Count > 0)
{
string deleteIds = "";
List <string> filesName = new List <string>();
foreach (DocumentInfo document in listDelete)
{
deleteIds += document.AutoID + ",";
}
deleteIds = deleteIds.Remove(deleteIds.Length - 1);
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
DocumentDataLayer.GetInstance().DeleteDocuments(connection, deleteIds);
}
//delete file physical
FilesHelpers.DeleteFiles(tableName, preferId.ToString(), filesName);
}
}
