static void Main(string[] args)
{
//var entity = new RangeEntity();
//var data = entity.GetRanges();
//var data2 = new string[2][];
//data2[0] = new String[] { "1", "2"};
//data2[1] = new String[] { "3", "4"};
//var entity2 = new RangeDataEntity();
//entity2.UploadRange("Guest", "435test", "foobar", "$A1:$B2", data2);
//var entity3 = new RangeDataEntity();
//var result = entity2.DownLoadRange(4);
var entity = new RangeEntity();
var data = entity.GetMyRanges("tonyj.lei");
var data2 = new string[2][];
data2[0] = new String[] { "1", "2" };
data2[1] = new String[] { "3", "4" };
var entity2 = new RangeDataEntity();
entity2.TargetedUploadRange("Guest", "435test", "foobar", "$A1:$B2", data2, new String[] { "saad.shaharyar,tony.lei"});
}
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 string UploadRange(string name, string desc, string xlAddress, ref string []allowedUsers, string fileName)
{
RangeDataEntity entity = new RangeDataEntity();
string result;
string[][] data;
int rows;
int cols;
using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read, FileShare.Read))
{
using (StreamReader sr = new StreamReader(fs, Encoding.UTF8))
{
rows = int.Parse(sr.ReadLine());
cols = int.Parse(sr.ReadLine());
sr.ReadLine();
data = new string[rows][];
for (int r = 0; r < rows; r++)
{
data[r] = new string[cols];
for (int c = 0; c < cols; c++)
{
data[r][c] = sr.ReadLine();
}
}
}
}
result = entity.TargetedUploadRange(Environment.UserName, name, desc, xlAddress, data, allowedUsers);
File.Delete(fileName);
return result;
}
