protected void BtnSave_Click(object sender, EventArgs e) { if (DpSeccion.SelectedItem != null) { MCoordinador NewIntegrant = new MCoordinador(TxtLastName.Text, TxtMiddleName.Text, TxtNames.Text, Int32.Parse(DpSeccion.SelectedItem.Value) , TxtStret.Text, TxtColony.Text, TxtEmail.Text, TxtPhoneHome.Text, TxtPhoneOffice.Text, TxtPhoneNextel.Text); Saved = C.SaveCoordinador(NewIntegrant); ReloadIntegrants(); if (Saved == true) { Clear(); } } }
public bool SaveCoordinador(MCoordinador coor) { bool Saved = false; try { if (!String.IsNullOrEmpty(coor.Paterno) && !String.IsNullOrEmpty(coor.Materno) && !String.IsNullOrEmpty(coor.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(coor.Paterno) , Extensions.SParam(coor.Materno) , Extensions.SParam(coor.Nombres)); object ID = DB.GetValue("Coordinador", IntegrantsColumns.Id, WhereStatement.ToString()); if (ID == null) { DB.Insert("Coordinador", new object[] { IntegrantsColumns.Id, "null" , IntegrantsColumns.Paterno, Extensions.SParam(coor.Paterno) , IntegrantsColumns.Materno, Extensions.SParam(coor.Materno) , IntegrantsColumns.Nombres, Extensions.SParam(coor.Nombres) , IntegrantsColumns.Seccion, coor.Seccion , IntegrantsColumns.Calle, Extensions.SParam(coor.Calle) , IntegrantsColumns.Colonia, Extensions.SParam(coor.Colonia) , IntegrantsColumns.Email, Extensions.SParam(coor.Email) , IntegrantsColumns.TelefonoDomicilio, Extensions.SParam(coor.Domicilio) , IntegrantsColumns.TelefonoOficina, Extensions.SParam(coor.Oficina) , IntegrantsColumns.TelefonoNextel, Extensions.SParam(coor.Nextel) }); Saved = true; } } } catch (Exception E) { throw E; } return(Saved); }