public ApiResult <Boolean> UpdateProfile(User Item)
{
ApiResult <Boolean> Rs = new ApiResult <Boolean>();
try
{
DbProvider.SetCommandText("sp_User_UpdateProfile", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
if (!errorCode.Equals(Constants.SUCCESS))
{
Rs.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrorCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
}
catch (Exception ex)
{
Rs.Failed(new ErrorObject {
Code = "EX",
Description = ex.ToString()
});
}
return(Rs);
}
public ApiResult <NewOrderResult> Insert(Order Item, int UserId)
{
ApiResult <NewOrderResult> Rs = new ApiResult <NewOrderResult>()
{
Data = new NewOrderResult()
};
try
{
DbProvider.SetCommandText("sp_order_insert", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("UserId", UserId, SqlDbType.Int);
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.AddParameter("OrderId", DBNull.Value, SqlDbType.Int, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
try
{
Rs.Data.Id = int.Parse(DbProvider.Command.Parameters["OrderId"].Value.ToString());
}
catch (Exception)
{
Rs.Data.Id = 0;
}
if (!errorCode.Equals(Constants.SUCCESS))
{
Rs.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrorCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
}
catch (Exception ex)
{
Rs.Failed(new ErrorObject()
{
Code = Constants.ERR_EXCEPTION,
Description = ex.Message
});
}
return(Rs);
}
public ApiResult <RoomResult> Update(RoomDetail Item, int UserId = 0)
{
ApiResult <RoomResult> rs = new ApiResult <RoomResult>()
{
Data = new RoomResult()
};
try
{
DbProvider.SetCommandText2("sp_room_update", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("UserId", UserId, SqlDbType.Int);
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
if (!errorCode.Equals(Constants.SUCCESS))
{
rs.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrorCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
}
catch (Exception ex)
{
rs.Failed(new ErrorObject()
{
Code = Constants.ERR_EXCEPTION,
Description = ex.Message
});
}
return(rs);
}
public ApiResult <HotelModels> OwnerUpdate(PutHotel Item, int UserId)
{
ApiResult <HotelModels> Rs = new ApiResult <HotelModels>();
try
{
DbProvider.SetCommandText("sp_Hotel_Owner_Update", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("UserId", UserId, SqlDbType.Int);
// Output params
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
// Kiểm tra kết quả trả về
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
if (!errorCode.Equals(Constants.SUCCESS))
{
Rs.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrorCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
}
catch (Exception ex)
{
Rs.Failed(new ErrorObject()
{
Code = Constants.ERR_EXCEPTION,
Description = ex.Message
});
}
return(Rs);
}
public Boolean Insert(FileUploaded Item, int UserId)
{
try
{
DbProvider.SetCommandText2("sp_FileUploaded_Insert", CommandType.StoredProcedure);
DbProvider.AddParameter("InJson", Libs.SerializeObject(Item), SqlDbType.NVarChar);
DbProvider.AddParameter("UserId", UserId, SqlDbType.Int);
DbProvider.AddParameter("ErrorCode", DBNull.Value, SqlDbType.NVarChar, 100, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrorCode"].Value.ToString();
if (!errorCode.Equals(Constants.SUCCESS))
{
return(false);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// Cập nhật thông tin hồ sơ
/// </summary>
/// <param name="profiles"></param>
/// <param name="files"></param>
/// <returns></returns>
public ReturnResult <Profiles> Update(Profiles profiles, List <ComputerFile> files = null, List <ComputerFile> extFiles = null, string folderPath = "")
{
ReturnResult <Profiles> result = new ReturnResult <Profiles>();
DbProvider db;
try
{
db = new DbProvider();
string JsonStringFiles = string.Empty;
string JsonStringOverwrite = string.Empty;
if (files != null)
{
JsonStringFiles = Libs.SerializeObject(files);
}
if (extFiles != null)
{
JsonStringOverwrite = Libs.SerializeObject(extFiles);
}
db.SetQuery("PROFILES_UPDATE", CommandType.StoredProcedure);
db.SetParameter("ProfileId", SqlDbType.Int, profiles.ProfileId);
db.SetParameter("FontId", SqlDbType.Int, profiles.FontId);
db.SetParameter("OrganId", SqlDbType.Int, profiles.OrganId);
db.SetParameter("TableOfContentId", SqlDbType.Int, profiles.TableOfContentId);
db.SetParameter("GearBoxId", SqlDbType.Int, profiles.GearBoxId);
db.SetParameter("ProfileType", SqlDbType.Int, profiles.ProfileTypeId);
db.SetParameter("FileCode", SqlDbType.NVarChar, profiles.FileCode, 50);
db.SetParameter("FileCatalog", SqlDbType.Int, profiles.FileCatalog);
db.SetParameter("FileNotation", SqlDbType.NVarChar, profiles.FileNotation, 100);
db.SetParameter("Title", SqlDbType.NVarChar, profiles.Title, 1000);
db.SetParameter("Maintenance", SqlDbType.NVarChar, profiles.Maintenance, 200);
db.SetParameter("Rights", SqlDbType.NVarChar, profiles.Rights, 200);
db.SetParameter("LanguageId", SqlDbType.Int, profiles.LanguageId);
db.SetParameter("StartDate", SqlDbType.DateTime, profiles.StartDate != null ? profiles.StartDate : DateTime.Now);
db.SetParameter("EndDate", SqlDbType.DateTime, profiles.EndDate != null ? profiles.EndDate : DateTime.Now);
db.SetParameter("TotalDoc", SqlDbType.Int, profiles.TotalDoc);
db.SetParameter("Description", SqlDbType.NVarChar, profiles.Description, 1000);
db.SetParameter("Keyword", SqlDbType.NVarChar, profiles.KeyWord, 200);
db.SetParameter("InforSign", SqlDbType.NVarChar, profiles.InforSign, 200);
db.SetParameter("SheetNumber", SqlDbType.Int, profiles.SheetNumber);
db.SetParameter("PageNumber", SqlDbType.Int, profiles.PageNumber);
db.SetParameter("PhysicalStateId", SqlDbType.Int, profiles.PhysicalStateId);
db.SetParameter("UpdateBy", SqlDbType.NVarChar, profiles.UpdatedBy);
db.SetParameter("JSONFILE", SqlDbType.NVarChar, JsonStringFiles);
db.SetParameter("JSONOVER", SqlDbType.NVarChar, JsonStringOverwrite);
db.SetParameter("FolderPath", SqlDbType.NVarChar, folderPath != null ? folderPath : "");
db.SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output);
db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 400, ParameterDirection.Output);
db.ExcuteNonQuery();
db.Complete();
db.GetOutValue("ErrorCode", out string outCode);
db.GetOutValue("ErrorMessage", out string outMessage);
if (outCode.ToString() != "0")
{
result.Failed(outCode.ToString(), outMessage);
}
else
{
result.ErrorCode = "0";
result.ErrorMessage = "";
}
}
catch (Exception ex)
{
result.Failed("-1", ex.Message);
}
return(result);
}
public async Task <IActionResult> ProfileUpdate()
{
IFormCollection form;
object obj3 = Request.Form["profile"]; // object
Profiles profile = Libs.DeserializeObject <Profiles>(obj3.ToString());
ReturnResult <Profiles> result = new ReturnResult <Profiles>();
try
{
ICollection <IFormFile> files = Request.Form.Files.ToList();
List <ComputerFile> lstFilesExists = new List <ComputerFile>();
List <ComputerFile> lstFileInfo = new List <ComputerFile>();
List <ComputerFile> lstFiles = new List <ComputerFile>();
string path = Libs.GetFullPathDirectoryFileUpload();
string directoryPathFileUpload = Const.FILE_UPLOAD_DIR + profile.FileCode;
//string directoryPathFileUpload = Path.Combine(path, profile.FileCode);
if (!Directory.Exists(directoryPathFileUpload))
{
// FileCode changed
// string[] directories = Directory.GetDirectories(Const.FILE_UPLOAD_DIR);
var profileCheck = profileBUS.GetProfileByID(profile.ProfileId);
string directoryOfProfile = Path.Combine(path, profileCheck.Item.FileCode);
if (Directory.Exists(directoryOfProfile))
{
Directory.Move(directoryOfProfile, directoryPathFileUpload);
}
else
{
Directory.CreateDirectory(directoryPathFileUpload);
}
if (files.Count > 0)
{
string[] lstFilesDir = Directory.GetFiles(directoryPathFileUpload);
if (lstFilesDir.Length > 0)
{
string[] lstDirFilesUpload = lstFilesDir;
foreach (var fileAlreadyExsists in lstDirFilesUpload)
{
foreach (var file in files)
{
if (fileAlreadyExsists.IndexOf(file.FileName) > -1)
{
lstFilesExists.Add(new ComputerFile()
{
FileName = Path.GetFileName(fileAlreadyExsists),
ProfileId = profile.ProfileId,
Url = fileAlreadyExsists
});
}
}
}
string overwrite = Request.Form["overwrite"].ToString();
if (lstFilesExists.Count > 0)
{
if (overwrite == "accept")
{
foreach (var fileAlreadyExists in lstFilesExists)
{
System.IO.File.Delete(fileAlreadyExists.Url);
}
// overwrite file already exists
foreach (var file in files)
{
string filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
else
{
var fileResult = new ReturnResult <ComputerFile>()
{
ReturnValue = Libs.SerializeObject(lstFilesExists.Select(item => item.FileName))
};
fileResult.Failed("-2", "Tồn tại file đã được upload lên hệ thống.");
return(Ok(fileResult));
}
}
else
{
foreach (var file in files)
{
var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
}
else
{
foreach (var file in files)
{
var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
// lấy lại danh sách file đã được tải lên
string[] lstDirFilesUploaded = Directory.GetFiles(directoryPathFileUpload);
foreach (var fileUrl in lstDirFilesUploaded)
{
string fileName = Path.GetFileName(fileUrl);
foreach (var file in files)
{
if (fileName.Equals(file.FileName))
{
lstFiles.Add(new ComputerFile()
{
FileName = file.FileName,
Size = (Math.Round((double)(file.Length / 1000000.0), 6)).ToString(),
Url = fileUrl,
PageNumber = GetNumberOfPdfPages(fileUrl),
CreatedBy = profile.CreatedBy,
FolderPath = directoryPathFileUpload,
ClientUrl = Const.FILE_SERVER_FOLDER + profile.FileCode + "/" + HttpUtility.HtmlEncode(fileName)
});
}
}
}
result = profileBUS.Update(profile, lstFiles, lstFilesExists, directoryPathFileUpload);
}
else
{
// không tải file lên thì chỉ send thông tin hồ sơ
result = profileBUS.Update(profile, null, null, directoryPathFileUpload);
}
}
else
{
if (files.Count > 0)
{
string[] lstFilesDir = Directory.GetFiles(directoryPathFileUpload);
if (lstFilesDir.Length > 0)
{
string[] lstDirFilesUpload = lstFilesDir;
foreach (var fileAlreadyExsists in lstDirFilesUpload)
{
foreach (var file in files)
{
if (fileAlreadyExsists.IndexOf(file.FileName) > -1)
{
lstFilesExists.Add(new ComputerFile()
{
FileName = Path.GetFileName(fileAlreadyExsists),
ProfileId = profile.ProfileId,
Url = fileAlreadyExsists
});
}
}
}
string overwrite = Request.Form["overwrite"].ToString();
if (lstFilesExists.Count > 0)
{
if (overwrite == "accept")
{
foreach (var fileAlreadyExists in lstFilesExists)
{
System.IO.File.Delete(fileAlreadyExists.Url);
}
// overwrite file already exists
foreach (var file in files)
{
string filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
else
{
var fileResult = new ReturnResult <ComputerFile>()
{
ReturnValue = Libs.SerializeObject(lstFilesExists.Select(item => item.FileName))
};
fileResult.Failed("-2", "Tồn tại file đã được upload lên hệ thống.");
return(Ok(fileResult));
}
}
else
{
foreach (var file in files)
{
var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
}
else
{
foreach (var file in files)
{
var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
}
}
// lấy lại danh sách file đã được tải lên
string[] lstDirFilesUploaded = Directory.GetFiles(directoryPathFileUpload);
foreach (var fileUrl in lstDirFilesUploaded)
{
string fileName = Path.GetFileName(fileUrl);
foreach (var file in files)
{
if (fileName.Equals(file.FileName))
{
lstFiles.Add(new ComputerFile()
{
FileName = file.FileName,
Size = (Math.Round((double)(file.Length / 1000000.0), 6)).ToString(),
Url = fileUrl,
PageNumber = GetNumberOfPdfPages(fileUrl),
CreatedBy = profile.CreatedBy,
FolderPath = directoryPathFileUpload,
ClientUrl = Const.FILE_SERVER_FOLDER + profile.FileCode + "/" + HttpUtility.HtmlEncode(fileName)
});
}
}
}
result = profileBUS.Update(profile, lstFiles, lstFilesExists, directoryPathFileUpload);
}
else
{
// không tải file lên thì chỉ send thông tin hồ sơ
result = profileBUS.Update(profile, null, null, directoryPathFileUpload);
}
}
// check FileCode was edit ?
#region FILE UPLOAD
//if (files.Count > 0)
//{
// string[] lstFilesDir = Directory.GetFiles(directoryPathFileUpload);
// if (lstFilesDir.Length > 0)
// {
// string[] lstDirFilesUpload = lstFilesDir;
// foreach (var fileAlreadyExsists in lstDirFilesUpload)
// {
// foreach (var file in files)
// {
// if (fileAlreadyExsists.IndexOf(file.FileName) > -1)
// {
// lstFilesExists.Add(new ComputerFile()
// {
// FileName = fileAlreadyExsists,
// ProfileId = profile.ProfileId,
// Url = fileAlreadyExsists
// });
// }
// }
// }
// string overwrite = Request.Form["overwrite"].ToString();
// if (lstFilesExists.Count > 0)
// {
// if (overwrite == "accept")
// {
// foreach (var fileAlreadyExists in lstFilesExists)
// {
// System.IO.File.Delete(fileAlreadyExists.FileName);
// }
// // overwrite file already exists
// foreach (var file in files)
// {
// string filePath = Path.Combine(directoryPathFileUpload, file.FileName);
// FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
// }
// }
// else
// {
// var fileResult = new ReturnResult<ComputerFile>()
// {
// ReturnValue = Libs.SerializeObject(lstFilesExists.Select(item => item.FileName))
// };
// fileResult.Failed("-2", "Tồn tại file đã được upload lên hệ thống.");
// return Ok(fileResult);
// }
// }
// else
// {
// foreach (var file in files)
// {
// var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
// FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
// }
// }
// }
// else
// {
// foreach (var file in files)
// {
// var filePath = Path.Combine(directoryPathFileUpload, file.FileName);
// FilesUtillities.CopyFileToPhysicalDiskSync(file, filePath);
// }
// }
// // lấy lại danh sách file đã được tải lên
// string[] lstDirFilesUploaded = Directory.GetFiles(directoryPathFileUpload);
// foreach (var fileUrl in lstDirFilesUploaded)
// {
// string fileName = Path.GetFileName(fileUrl);
// foreach (var file in files)
// {
// if (fileName.Equals(file.FileName))
// {
// lstFiles.Add(new ComputerFile()
// {
// FileName = file.FileName,
// Size = (Math.Round((double)(file.Length / 1000000.0), 6)).ToString(),
// Url = fileUrl,
// PageNumber = GetNumberOfPdfPages(fileUrl),
// CreatedBy = profile.CreatedBy,
// FolderPath = directoryPathFileUpload
// });
// }
// }
// }
// result = profileBUS.Update(profile, lstFiles, lstFilesExists, directoryPathFileUpload);
//}
//else
//{
// // không tải file lên thì chỉ send thông tin hồ sơ
// result = profileBUS.Update(profile, null, null, directoryPathFileUpload);
//}
#endregion
return(Ok(result));
}
catch (Exception ex)
{
result.Failed("1", ex.Message);
return(Ok(result));
}
}
