public IHttpActionResult GetAllResourceForStatus(dynamic Json)
{
string Input = JsonConvert.SerializeObject(Json);
string output = ResourcesKeyDataAccessManager.GetAllResourceForStatus(Input);
JObject returnObject = new JObject();
if (output != null)
{
returnObject = (JObject)JsonConvert.DeserializeObject(output);
}
return(Ok(returnObject));
}
public IHttpActionResult UploadResourcesKey(dynamic Json)
{
dynamic rspjsonobj = new ExpandoObject();
rspjsonobj.IsValidExcel = false;
rspjsonobj.IsError = false;
string sPath = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/ResourcesKey/");
if (sPath != null && !Directory.Exists(sPath))
{
Directory.CreateDirectory(sPath);
}
string FileName = Guid.NewGuid().ToString() + Json.Json.FileName.Value;
if (!File.Exists(Path.Combine(sPath, FileName)))
{
try
{
File.WriteAllBytes(Path.Combine(sPath, FileName), Convert.FromBase64String(Json.Json.File.Value));
DataSet dsFileData = new DataSet();
ReadFile objreadFile = new ReadFile();
dsFileData = objreadFile.ReadExcel(Path.Combine(sPath, FileName));
if (dsFileData.Tables.Count > 0)
{
// DataTableToJSON(dsFileData.Tables[0]);
if (dsFileData.Tables[0].Columns.Count >= 8)
{
dsFileData.Tables[0].Columns[0].ColumnName = "ResourceId";
dsFileData.Tables[0].Columns[1].ColumnName = "CultureId";
dsFileData.Tables[0].Columns[2].ColumnName = "PageName";
dsFileData.Tables[0].Columns[3].ColumnName = "ResourceType";
dsFileData.Tables[0].Columns[4].ColumnName = "ResourceKey";
dsFileData.Tables[0].Columns[5].ColumnName = "ResourceValue";
dsFileData.Tables[0].Columns[6].ColumnName = "VersionNo";
dsFileData.Tables[0].Columns[7].ColumnName = "IsActive";
rspjsonobj.IsValidExcel = true;
var ResourceList = ToDynamic(dsFileData.Tables[0]);
foreach (dynamic resource in ResourceList)
{
dynamic orderJson1 = new ExpandoObject();
orderJson1.Resource = resource;
string InputStr = JsonConvert.SerializeObject(orderJson1);
var dd = ResourcesKeyDataAccessManager.UpdateResourcesKey(InputStr);
}
}
else
{
rspjsonobj.IsValidExcel = false;
}
}
else
{
rspjsonobj.IsValidExcel = false;
}
}
catch (Exception ex)
{
rspjsonobj.IsValidExcel = false;
LogData("Error Gratis Code Update" + ex.Message);
}
File.Delete(Path.Combine(sPath, FileName));
}
return(Ok(rspjsonobj));
}
public IHttpActionResult DownloadResourcesKey(dynamic Json)
{
dynamic orderDocument = new ExpandoObject();
dynamic DocumentList = new ExpandoObject();
DataSet dsSalesSummaryReportList = new DataSet();
string input = JsonConvert.SerializeObject(Json);
dsSalesSummaryReportList = ResourcesKeyDataAccessManager.GetAllResourcesKey <DataSet>(input);
JObject returnObject = new JObject();
dynamic filterJson = new ExpandoObject();
DataSet ds = dsSalesSummaryReportList;
HttpResponseMessage result = new HttpResponseMessage();
if (ds != null)
{
string filePath = "";
using (XLWorkbook wb = new XLWorkbook())
{
foreach (DataTable dts in ds.Tables)
{
wb.Worksheets.Add(dts);
}
string sPath = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/SalesSummaryReport/");
if (sPath != null && !Directory.Exists(sPath))
{
Directory.CreateDirectory(sPath);
}
using (MemoryStream myMemoryStream = new MemoryStream())
{
wb.SaveAs(myMemoryStream);
string fileName = DateTime.Now.ToString();
fileName = "Resources" + DateTime.Now.ToString("MMddyyyy-hhmm") + ".xlsx";
filePath = sPath + fileName;
FileStream file = new FileStream(filePath, FileMode.Create, FileAccess.Write);
myMemoryStream.WriteTo(file);
file.Close();
myMemoryStream.Close();
}
List <dynamic> orderList = new List <dynamic>();
byte[] byt = File.ReadAllBytes(filePath);
try
{
orderDocument.DocumentBlob = byt;
orderDocument.DocumentFormat = "xlsx";
filterJson.Json = orderDocument;
string Input1 = JsonConvert.SerializeObject(filterJson);
returnObject = (JObject)JsonConvert.DeserializeObject(Input1);
}
catch (Exception ex)
{
var dd = ex.Message;
}
}
}
return(Ok(returnObject));
}
