public List <EmailBE> SelectList(String IdContato)
{
{
List <SqlParameter> lstPar = new List <SqlParameter>();
StringBuilder Query = new StringBuilder();
Query.AppendFormat("SELECT [IdEmail], [IdContato], [Email] FROM Email WHERE IdContato = '{0}'", IdContato);
DataTable tB = Conn.ExecSql_DataTable(Query.ToString());
List <EmailBE> objList = new List <EmailBE>();
foreach (DataRow rw in tB.Rows)
{
EmailBE obj = new EmailBE();
obj.IdEmail = rw["IdEmail"].ToString();
obj.IdContato = rw["IdContato"].ToString();
obj.Email = rw["Email"].ToString();
objList.Add(obj);
}
return(objList);
}
}
public EmailBE Insert_Update(EmailBE obj_list)
{
{
List <SqlParameter> lstPar = new List <SqlParameter>();
obj_list.IdEmail = (obj_list.IdEmail == "0" ? Guid.NewGuid().ToString() : obj_list.IdEmail);
lstPar.Add(new SqlParameter("@IdEmail", obj_list.IdEmail));
lstPar.Add(new SqlParameter("@IdContato", obj_list.IdContato ?? ""));
lstPar.Add(new SqlParameter("@Email", obj_list.Email ?? ""));
Conn.ExecSp("Email_Insert_Update", lstPar);
return(obj_list);
}
}