protected void BtnSave_Click(object sender, EventArgs e) { if (DpSeccion.SelectedItem != null) { MLider NewLider = new MLider(Int32.Parse(DpTerr.SelectedItem.Value), TxtLastName.Text, TxtMiddleName.Text, TxtNames.Text, Int32.Parse(DpSeccion.SelectedItem.Value) , TxtStret.Text, TxtColony.Text, TxtEmail.Text, TxtPhoneHome.Text, TxtPhoneOffice.Text, TxtPhoneNextel.Text, TxtElector.Text); Saved = C.SaveLider(NewLider); ReloadIntegrantsTable(); ReloadTerritorial(); if (Saved == true) { Clear(); } } }
public bool SaveLider(MLider lid) { bool Saved = false; try { if (!String.IsNullOrEmpty(lid.Paterno) && !String.IsNullOrEmpty(lid.Materno) && !String.IsNullOrEmpty(lid.Nombres)) { DBManager DB = new DBManager(ConfigurationManager.AppSettings["SQLiteDB"]); StringBuilder WhereStatement = new StringBuilder(); WhereStatement.AppendFormat(@"ApellidoPaterno like {0} and ApellidoMaterno like {1} and Nombres like {2}" , Extensions.SParam(lid.Paterno) , Extensions.SParam(lid.Materno) , Extensions.SParam(lid.Nombres)); object ID = DB.GetValue("Lider", IntegrantsColumns.Id, WhereStatement.ToString()); if (ID == null) { DB.Insert("Lider", new object[] { IntegrantsColumns.Id, "null" , IntegrantsColumns.Territorial, lid.Territorial , IntegrantsColumns.Paterno, Extensions.SParam(lid.Paterno) , IntegrantsColumns.Materno, Extensions.SParam(lid.Materno) , IntegrantsColumns.Nombres, Extensions.SParam(lid.Nombres) , IntegrantsColumns.Seccion, lid.Seccion , IntegrantsColumns.Calle, Extensions.SParam(lid.Calle) , IntegrantsColumns.Colonia, Extensions.SParam(lid.Colonia) , IntegrantsColumns.Email, Extensions.SParam(lid.Email) , IntegrantsColumns.TelefonoDomicilio, Extensions.SParam(lid.Domicilio) , IntegrantsColumns.TelefonoOficina, Extensions.SParam(lid.Oficina) , IntegrantsColumns.TelefonoNextel, Extensions.SParam(lid.Nextel) , IntegrantsColumns.ClaveElector, Extensions.SParam(lid.Elector) }); Saved = true; } } } catch (Exception E) { throw E; } return(Saved); }