public ResponseModel CreateHierarchy([FromBody] CustomHierarchymodel customHierarchymodel)
{
HierarchyCaller hierarchy = new HierarchyCaller();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
customHierarchymodel.TenantID = authenticate.TenantId;
customHierarchymodel.CreatedBy = authenticate.UserMasterID;
int result = hierarchy.CreateHierarchy(new HierarchyService(Cache, Db), customHierarchymodel);
if (customHierarchymodel.Deleteflag == 1)
{
if (result == 0)
{
statusMessage = "Record in use";
}
else
{
statusMessage = "Record deleted successfully ";
}
statusCode =
result == 0 ? (int)EnumMaster.StatusCode.RecordInUse : (int)EnumMaster.StatusCode.RecordDeletedSuccess;
}
if (customHierarchymodel.DesignationID == 0)
{
if (result == 0)
{
statusCode =
result == 0 ?
(int)EnumMaster.StatusCode.RecordAlreadyExists : (int)EnumMaster.StatusCode.Success;
}
else
{
statusCode = result > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
}
}
else
{
statusCode =
result == 0 ?
(int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
}
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = result;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public ResponseModel ListHierarchy(int HierarchyFor = 1)
{
List <CustomHierarchymodel> customHierarchymodels = new List <CustomHierarchymodel>();
HierarchyCaller hierarchy = new HierarchyCaller();
ResponseModel objResponseModel = new ResponseModel();
int statusCode = 0;
string statusMessage = "";
try
{
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
customHierarchymodels = hierarchy.ListofHierarchy(new HierarchyService(Cache, Db), authenticate.TenantId, HierarchyFor);
statusCode =
customHierarchymodels.Count == 0 ?
(int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = statusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = customHierarchymodels;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
public ResponseModel BulkUploadHierarchy(IFormFile File, int HierarchyFor = 1)
{
string downloadFilePath = string.Empty;
string bulkUploadFilesPath = string.Empty;
bool errorFilesaved = false;
bool successFilesaved = false;
int count = 0;
HierarchyCaller hierarchy = new HierarchyCaller();
SettingsCaller fileU = new SettingsCaller();
ResponseModel objResponseModel = new ResponseModel();
int StatusCode = 0;
string statusMessage = "";
DataSet dataSetCSV = new DataSet();
List <string> CSVlist = new List <string>();
string fileName = "";
string finalAttchment = "";
try
{
var files = Request.Form.Files;
string timeStamp = DateTime.Now.ToString("ddMMyyyyhhmm");
if (files.Count > 0)
{
for (int i = 0; i < files.Count; i++)
{
fileName += files[i].FileName.Replace(".", timeStamp + ".") + ",";
}
finalAttchment = fileName.TrimEnd(',');
}
var Keys = Request.Form;
var exePath = Path.GetDirectoryName(System.Reflection
.Assembly.GetExecutingAssembly().CodeBase);
Regex appPathMatcher = new Regex(@"(?<!fil)[A-Za-z]:\\+[\S\s]*?(?=\\+bin)");
var appRoot = appPathMatcher.Match(exePath).Value;
string Folderpath = appRoot + "\\" + UploadedBulkFile;
if (files.Count > 0)
{
string[] filesName = finalAttchment.Split(",");
for (int i = 0; i < files.Count; i++)
{
using (var ms = new MemoryStream())
{
files[i].CopyTo(ms);
var fileBytes = ms.ToArray();
MemoryStream msfile = new MemoryStream(fileBytes);
FileStream docFile = new FileStream(Folderpath + "\\" + filesName[i], FileMode.Create, FileAccess.Write);
msfile.WriteTo(docFile);
docFile.Close();
ms.Close();
msfile.Close();
string s = Convert.ToBase64String(fileBytes);
byte[] a = Convert.FromBase64String(s);
// act on the Base64 data
}
}
}
string token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));
#region FilePath
bulkUploadFilesPath = appRoot + "\\" + "BulkUpload\\UploadFiles" + "\\" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)HierarchyFor);
downloadFilePath = appRoot + "\\" + "BulkUpload\\DownloadFiles" + "\\" + CommonFunction.GetEnumDescription((EnumMaster.FileUpload)HierarchyFor);
#endregion
dataSetCSV = CommonService.csvToDataSet(Folderpath + "\\" + finalAttchment);
CSVlist = hierarchy.HierarchyBulkUpload(new HierarchyService(Cache, Db),
authenticate.TenantId, authenticate.UserMasterID, HierarchyFor, dataSetCSV);
#region Create Error and Success files and Insert in FileUploadLog
if (!string.IsNullOrEmpty(CSVlist[0]))
{
successFilesaved = CommonService.SaveFile(downloadFilePath + "\\Hierarchy\\ Success" + "\\" + "HierarchySuccessFile.csv", CSVlist[0]);
}
if (!string.IsNullOrEmpty(CSVlist[1]))
{
errorFilesaved = CommonService.SaveFile(downloadFilePath + "\\Hierarchy\\Error" + "\\" + "HierarchyErrorFile.csv", CSVlist[1]);
}
count = fileU.CreateFileUploadLog(new FileUploadService(Cache, Db), authenticate.TenantId, "hierarchymaster.csv", errorFilesaved,
"HierarchyErrorFile.csv", "HierarchySuccessFile.csv", authenticate.UserMasterID, "Hierarchy",
downloadFilePath + "\\Hierarchy\\Error" + "\\" + "HierarchyErrorFile.csv",
downloadFilePath + "\\Hierarchy\\ Success" + "\\" + "HierarchySuccessFile.csv", HierarchyFor
);
#endregion
StatusCode = count > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;
statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)StatusCode);
objResponseModel.Status = true;
objResponseModel.StatusCode = StatusCode;
objResponseModel.Message = statusMessage;
objResponseModel.ResponseData = CSVlist.Count;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
