public int InsertAreas(Pack p) { IList<long> list = p.Areas; if(list == null || list.Length == 0) return 0; int inserted = 0; DbModel model = new DbModel("PackArea", null); for(int i = 0; i < list.Length; i++) inserted += (model.Insert(p.Id, list[i]) ? 1 : 0); return inserted; }
public bool Sync() { DbModel m = new DbModel("Contact"); IDataReader r = m.GetById(this.Id); bool success = false; if(r.Read()) { this.Name = (string) r["Name"]; this.PhoneNumber = r["PhoneNumber"].ToString(); success = true; } return success; }
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); }
public long DeleteAreas(Pack p) { DbModel model = new DbModel("PackArea", null); return model.DeleteBy("Pack", p.Id); }
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(); }