public async Task <Judet[]> InitJudete()
{
var dd = new DownloadData();
var dataBytes = await dd.Data(new Uri("http://data.gov.ro/storage/f/2013-11-01T11%3A53%3A13.359Z/siruta-judete.csv"));
string data = Encoding.UTF8.GetString(dataBytes);
var list = new List <Judet>();
var lines = data.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
foreach (var line in lines)
{
if (string.IsNullOrWhiteSpace(line))
{
continue;
}
var arr = line.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
if (arr[0] == "JUD")//header
{
continue;
}
var j = new Judet();
j.Cod = arr[3];
j.Nume = arr[1];
j.ID = arr[2];//FSJ
list.Add(j);
}
return(list.ToArray());
}
public async Task <UAT[]> InitUat(Judet[] judete)
{
var dd = new DownloadData();
var dataBytes = await dd.Data(new Uri("http://data.gov.ro/storage/f/2013-11-01T11%3A49%3A59.808Z/siruta.csv"));
string data = Encoding.UTF8.GetString(dataBytes);
var list = new List <UAT>();
var lines = data.Split(new string[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries);
Judet lastJudet = null;
foreach (var line in lines)
{
if (string.IsNullOrWhiteSpace(line))
{
continue;
}
var arr = line.Split(new string[] { ";" }, StringSplitOptions.None);
if (arr[0] == "\"SIRUTA\"")//header
{
continue;
}
if (arr[12].Contains("00000000000"))//rang => judet
{
var idJudet = int.Parse(arr[12].Replace("00000000000", "").Replace("\"", ""));
lastJudet = judete.First(it => it.ID == idJudet.ToString());
continue;
}
if (lastJudet == null)
{
throw new ArgumentException("not found judet for " + line);
}
var uat = new UAT();
uat.UatTip = (arr[5]);
uat.Nume = arr[1].Replace("\"", "");
uat.ID = arr[9];
uat.Judet = lastJudet;
list.Add(uat);
}
return(list.ToArray());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FCCL_DAL.Entities.Ferme_CCL farm = null;
if (Request.Params["ID"] != null)
{
var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
farm = farmManager.GetFarmById(Convert.ToInt32(Request.Params["ID"]));
}
var fabricaManager =
new FactoryManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
var fabrici = fabricaManager.GetFactories();
Asociatia.DataSource = fabrici;
if (farm != null && farm.FabricaId != null)
{
Asociatia.SelectedValue = farm.FabricaId.ToString();
}
Asociatia.DataBind();
var countyManager =
new CountyManager(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
var counties = countyManager.GetAllCounties();
Judet.DataSource = counties;
if (farm != null && farm.JudetId != null)
{
Judet.SelectedValue = farm.JudetId.ToString();
}
Judet.DataBind();
InsertF.Visible = true;
if (farm != null)
{
//populate farm table
IdFerma.Text = farm.Id.ToString();
FermaCod.Text = farm.Cod;
FermaName.Text = farm.Nume;
FarmEmail.Text = farm.Email;
Localitate.Text = farm.Oras;
Strada.Text = farm.Strada;
Numar.Text = farm.Numar;
CodPostal.Text = farm.CodPostal;
Telefon.Text = farm.Telefon;
Fax.Text = farm.Fax;
PersContact.Text = farm.PersoanaDeContact;
TelPersContact.Text = farm.TelPersoanaContact;
SendSms.Checked = farm.SendSms;
//populate user table
var userManager =
new UserManager(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
var userInfo = userManager.GetUserInformationByCod(farm.Cod);
if (userInfo != null)
{
UserId.Value = userInfo.UserId.ToString();
Nume.Text = userInfo.LastName;
Prenume.Text = userInfo.FirstName;
UserNameLbl.Text = userInfo.UserName;
Email.Text = userInfo.Email;
Update.Visible = true;
ResetareParola.Visible = true;
UserNameLbl.Visible = true;
Parola.Visible = false;
}
else
{
Insert.Visible = true;
UserName.Visible = true;
}
UserCodLbl.Text = farm.Cod;
UpdateF.Visible = true;
DeleteF.Visible = true;
}
}
}
public override int GetHashCode()
{
return(Localitate.GetHashCode() + Judet.GetHashCode() + Strada.GetHashCode() + Numar.GetHashCode());
}
public override async Task <RopDocument[]> FillDate()
{
var dd = new DownloadData();
var dataBytes = await dd.Data(rdBase.PathDocument);
string data = Encoding.UTF8.GetString(dataBytes);
var list = new List <RopData>();
var lines = data.Split((char)(10));
var restFromPreviousLine = "";
for (int lineIter = 0; lineIter < lines.Length; lineIter++)
{
if (lineIter == 0)//header
{
continue;
}
var line = lines[lineIter];
if (string.IsNullOrWhiteSpace(line))
{
continue;
}
var arr = (restFromPreviousLine + line).Split(new [] { "," }, StringSplitOptions.None);
if (arr.Length < 16)
{
restFromPreviousLine += line;
continue;
}
restFromPreviousLine = "";
for (int i = 0; i < arr.Length; i++)
{
arr[i] = arr[i].Replace("\"", "");
}
Judet judet = null;
for (int i = 16; i < arr.Length; i++)
{
var numeJudet = arr[i].ToString().Trim().ToLower();
try
{
judet = judetFinder.Find(numeJudet);
}
catch (ArgumentException)
{
//do not log
}
if (judet != null)
{
break;
}
}
if (judet == null)
{
throw new ArgumentException("not found judet:" + string.Join(",", arr));
}
var rd = new RopData();
rd.Judet = judet;
rd.Valoare = 1;
list.Add(rd);
}
list = list.GroupBy(it => it.Judet).Select(group =>
new RopData()
{
Judet = group.Key,
Valoare = group.Sum(it => it.Valoare)
}
).ToList();
rdBase.Data = list.ToArray();
return(new[] { rdBase });
}
