public bool UpdateParishioner(Parishioner P) { var conn = new SqlConnection(); var command = new SqlCommand(); var dataBase = new DBConnect(); bool answ; try { conn = dataBase.Open(); command.Connection = conn; command.CommandText = "UpdateParishioner"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id", P.Id); command.Parameters.AddWithValue("@Name", P.Name); command.Parameters.AddWithValue("@Surname", P.Surname); command.Parameters.AddWithValue("@Documento", P.Documento); if (P.BirthDate == null) { command.Parameters.AddWithValue("@BirthDate", Convert.DBNull); } else { command.Parameters.AddWithValue("@BirthDate", P.BirthDate); } command.Parameters.AddWithValue("@Observation", P.Observation); command.ExecuteNonQuery(); answ = true; } catch (Exception e) { MessageBox.Show(String.Concat(e.Message, e.StackTrace), ""); answ = false; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); conn.Dispose(); } } return(answ); }
}//Listar public List <Parishioner> ListParishByActivity(string Name, int activityId) { var conn = new SqlConnection(); var command = new SqlCommand(); var dataBase = new DBConnect(); var Lista = new List <Parishioner>(); try { conn = dataBase.Open(); command.Connection = conn; command.CommandText = "ListParishByActivity"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Name", Name); command.Parameters.AddWithValue("@ActivityId", activityId); var rdr = command.ExecuteReader(); while (rdr != null && rdr.Read()) { var reg = new Parishioner(); reg.Id = (int)rdr["Id"]; reg.Name = (string)rdr["Name"]; reg.Surname = (string)rdr["Surname"]; reg.Documento = (string)rdr["Documento"]; if (rdr["BirthDate"] is DBNull) { reg.BirthDate = null; } else { reg.BirthDate = Convert.ToDateTime(rdr["BirthDate"]); } reg.Telephone = Convert.ToString(rdr["Telephone"] is DBNull ? "" : rdr["Telephone"]); reg.Address = Convert.ToString(rdr["Address"] is DBNull ? "" : rdr["Address"]); reg.Mail = Convert.ToString(rdr["Mail"] is DBNull ? "" : rdr["Mail"]); reg.Observation = Convert.ToString(rdr["Observation"] is DBNull ? "" : rdr["Observation"]); if (rdr["IdTel"] is DBNull) { reg._parishionerData.IdTel = null; } else { reg._parishionerData.IdTel = (int)rdr["IdTel"]; } if (rdr["IdAddress"] is DBNull) { reg._parishionerData.IdAddress = null; } else { reg._parishionerData.IdAddress = (int)rdr["IdAddress"]; } if (rdr["IdMail"] is DBNull) { reg._parishionerData.IdMail = null; } else { reg._parishionerData.IdMail = (int)rdr["IdMail"]; } Lista.Add(reg); }//while } catch (Exception e) { MessageBox.Show(String.Concat(e.Message, e.StackTrace), ""); } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); conn.Dispose(); } } return(Lista); }//Listar
public ParishionerByActivity() { _activity = new Activity(); _parishioner = new Parishioner(); }