private void Scan()
{
this.Loader.Update(0, "Comenzando...");
MemberModel mm = new MemberModel();
long members = mm.CountActive();
//long members = 500;
double step = 100.0 / members;
double real_percent = 0.0;
int percent = 0;
IDataReader reader = mm.GetAllWithJoin(true);
//for(int i = 0; i++ < members;)
while(reader.Read())
{
real_percent += step;
percent = (int) real_percent;
Thread.Sleep(5);
this.Loader.Update(percent, percent + "%");
Console.Out.WriteLine(reader["Name"] + ", " + reader["Weight"]);
while(Gtk.Application.EventsPending())
Gtk.Application.RunIteration();
}
this.Loader.Update(100, "Iniciando...");
while(Gtk.Application.EventsPending())
Gtk.Application.RunIteration();
Thread.Sleep(500);
//this.Loader.Success();
//this.Loader.Destroy();
}
public static Member FromId(long id)
{
MemberModel mm = new MemberModel();
IDataReader r = mm.GetById(id);
Member m = null;
if(r.Read())
{
m = new Member();
m.Id = id;
m.Active = (bool) r["Active"];
m.Height = (float) r["Height"];
m.Weight = (float) r["Weight"];
m.Gender = (char) (int.Parse((string) r["Gender"]));
//Console.Out.WriteLine(m.Gender);
m.BirthDate = (DateTime) r["BirthDate"];
m.PaymentDay = (int) ((long) r["PaymentDay"]);
m.JoinDate = (DateTime) r["JoinDate"];
m.Pack = (long) r["Pack"];
m.BinImage = mm.GetImage(m);
m.InnerClient = new Client();
m.InnerClient.Id = id;
m.InnerClient.Sync();
m.InnerContact = new Contact();
m.InnerContact.Id = long.TryParse(r["Contact"].ToString(), out m.InnerContact.Id) ? m.InnerContact.Id : 0;
m.InnerContact.Sync();
}
return m;
}
private void DoSearch(object sender, EventArgs args)
{
this.ClearForm();
string like = this.SearchEntry.Text.Trim();
MemberModel model = new MemberModel();
this.FillNodeView(model.GetAllWithJoinLike(like));
this.EditButton.Sensitive = false;
}
private void DoOk(object sender, EventArgs args)
{
Member m = new Member();
m.Id = this.CurrentClient.Id;
m.Sync();
MemberModel mm = new MemberModel();
if(m.Active != this.ActiveCheck.Active)
mm.Update(m, "Active", this.ActiveCheck.Active);
if(this.ImageToSave != null && this.ImageToSave.Length != m.BinImage.Length)
{
m.BinImage = this.ImageToSave;
mm.SetImage(m);
}
if(m.Weight != this.WeightSpin.Value)
mm.Update(m, "Weight", this.WeightSpin.Value);
if(m.Height != this.HeightSpin.Value)
mm.Update(m, "Height", this.HeightSpin.Value);
char ctrl_gender = this.GenderCombo.Active == 0 ? 'm' : 'f';
if(m.Gender != ctrl_gender)
mm.Update(m, "Gender", ctrl_gender);
if(m.BirthDate.CompareTo(this.BirthdayWidget.Date) != 0)
mm.Update(m, "BirthDate", this.BirthdayWidget.Date.ToString("yyyy-MM-dd"));
if(m.InnerContact.Id == 0 && !string.IsNullOrEmpty(this.ContactNameEntry.Text.Trim() + this.ContactPhoneEntry.Text.Trim()))
{
DbModel model = new DbModel("Contact");
model.Insert(null, this.ContactNameEntry.Text.Trim(), this.ContactPhoneEntry.Text.Trim());
long last = model.LastInsertId;
mm.Update(m, "Contact", last);
}
else if(m.InnerContact.Name != this.ContactNameEntry.Text || m.InnerContact.PhoneNumber != this.ContactPhoneEntry.Text)
{
DbModel model = new DbModel("Contact");
model.UpdateById(m.InnerContact.Id, "Name", this.ContactNameEntry.Text.Trim());
model.UpdateById(m.InnerContact.Id, "PhoneNumber", this.ContactPhoneEntry.Text.Trim());
}
Client c = m.InnerClient;
ClientModel cm = new ClientModel();
if(c.Name != this.NameEntry.Text)
cm.Update(c, "Name", this.NameEntry.Text.Trim());
if(c.Surname != this.SurnameEntry.Text)
cm.Update(c, "Surname", this.SurnameEntry.Text.Trim());
if(c.Address != this.AddressEntry.Text)
cm.Update(c, "Address", this.AddressEntry.Text.Trim());
omarkhd.Validation.Validator v = new omarkhd.Validation.Validator();
v.SetRule(this.PhoneEntry.Text, "phone", omarkhd.Validation.ValidationRule.Natural);
if(c.PhoneNumber != this.PhoneEntry.Text && v.Run().Status)
cm.Update(c, "PhoneNumber", this.PhoneEntry.Text.Trim());
v = new omarkhd.Validation.Validator();
v.SetRule(this.EmailEntry.Text, "email", omarkhd.Validation.ValidationRule.Email);
if(c.Email != this.EmailEntry.Text && v.Run().Status)
cm.Update(c, "Email", this.EmailEntry.Text.Trim());
this.DoCancel(null, null);
}
private void NewEnrollment(object sender, EventArgs args)
{
MemberWizard ww = new MemberWizard();
ww.SuccessEvent += (object o) =>
{
Member m = (Member) o;
Client c = m.InnerClient;
ClientModel cm = new ClientModel();
MemberModel mm = new MemberModel();
///adding the new client if needed
if(c.Id == -1) //-1 = new client
{
cm.Insert(c);
c.Id = cm.LastInsertId;
}
//add the contact info
if(m.InnerContact.Name.Length > 0)
{
DbModel contact_m = new DbModel("Contact");
contact_m.Insert(null, m.InnerContact.Name, m.InnerContact.PhoneNumber);
m.InnerContact.Id = contact_m.LastInsertId;
}
//adding the member
m.Id = c.Id;
mm.Insert(m);
//adding the membership debt
if(m.ChargeMembership)
{
DbModel mship_m = new DbModel("MembershipDebt");
mship_m.Insert(m.Id, null);
}
PaymentRuler.ChargeFirstMonth(m);
};
ww.Run();
}
