public string DownloadRange(int id)
{
string fileName = GetTempName();
RangeDataEntity entity = new RangeDataEntity();
RangeDataModel result = entity.DownloadRange(id);
using (FileStream fs = new FileStream(fileName, FileMode.Create, FileAccess.Write, FileShare.None))
{
using (StreamWriter sw = new StreamWriter(fs, Encoding.UTF8))
{
sw.WriteLine(result.Data.Length.ToString());
sw.WriteLine(result.Data[0].Length.ToString());
sw.WriteLine();
for (int r = 0; r < result.Data.Length; r++)
{
for (int c = 0; c < result.Data[r].Length; c++)
{
sw.WriteLine(result.Data[r][c]);
}
}
sw.Close();
}
}
return(fileName);
}
public JsonResult DownloadRange(int RangeId)
{
RangeDataModel rDataModel = new RangeDataModel();
using (var context = new xlsnippingtoolEntities())
{
var qry = context.RangeDatas.ToList().Where(x => x.RangeId.Equals(RangeId));
RangeData data = qry.FirstOrDefault();
if (data == null)
{
return null;
}
String[][] rData = JsonConvert.DeserializeObject<String[][]>(data.Data);
rDataModel.Address = data.Address;
rDataModel.Data = rData;
}
return Json(rDataModel, JsonRequestBehavior.AllowGet);
}
public JsonResult DownloadRange(int RangeId)
{
RangeDataModel rDataModel = new RangeDataModel();
using (var context = new xlsnippingtoolEntities())
{
var qry = context.RangeDatas.ToList().Where(x => x.RangeId.Equals(RangeId));
RangeData data = qry.FirstOrDefault();
if (data == null)
{
return(null);
}
String[][] rData = JsonConvert.DeserializeObject <String[][]>(data.Data);
rDataModel.Address = data.Address;
rDataModel.Data = rData;
}
return(Json(rDataModel, JsonRequestBehavior.AllowGet));
}
