//#region Methods
//public static IList<Framework.DataServices.Model.EntityBaseData> ConvertToList(DataTable table)
//{
// IList<Framework.DataServices.Model.EntityBaseData> list = new List<Framework.DataServices.Model.EntityBaseData>();
// foreach (DataRow row in table.Rows)
// {
// list.Add(ConvertToObject(row));
// }
// return list;
//}
//public static Framework.DataServices.Model.EntityBaseData ConvertToObject(DataRow row)
//{
// string nomeBolao = "";
// string fromUser = "";
// long messageID = 0;
// if (row.Table.Columns.Contains("MessageID") && !Convert.IsDBNull(row["MessageID"]))
// {
// messageID = Convert.ToInt64(row["MessageID"]);
// }
// if (row.Table.Columns.Contains("NomeBolao") && !Convert.IsDBNull(row["NomeBolao"]))
// {
// nomeBolao = Convert.ToString(row["NomeBolao"]);
// }
// if (row.Table.Columns.Contains("FromUser") && !Convert.IsDBNull(row["FromUser"]))
// {
// fromUser = Convert.ToString(row["FromUser"]);
// }
// Model.Boloes.Mensagem entry = new BolaoNet.Model.Boloes.Mensagem (messageID, fromUser, nomeBolao);
// entry.LoadDataRow(row);
// if (row.Table.Columns.Contains("CreationDate") && !Convert.IsDBNull(row["CreationDate"]))
// {
// entry.CreationDate = Convert.ToDateTime(row["CreationDate"]);
// }
// if (row.Table.Columns.Contains("Private") && !Convert.IsDBNull(row["Private"]))
// {
// entry.Private = Convert.ToBoolean(row["Private"]);
// }
// if (row.Table.Columns.Contains("ToUser") && !Convert.IsDBNull(row["ToUser"]))
// {
// entry.ToUser = Convert.ToString(row["ToUser"]);
// }
// if (row.Table.Columns.Contains("Title") && !Convert.IsDBNull(row["Title"]))
// {
// entry.Title = Convert.ToString(row["Title"]);
// }
// if (row.Table.Columns.Contains("Message") && !Convert.IsDBNull(row["Message"]))
// {
// entry.Message = Convert.ToString(row["Message"]);
// }
// if (row.Table.Columns.Contains("TotalRead") && !Convert.IsDBNull(row["TotalRead"]))
// {
// entry.TotalRead = Convert.ToInt32(row["TotalRead"]);
// }
// if (row.Table.Columns.Contains("AnsweredMessageID") && !Convert.IsDBNull(row["AnsweredMessageID"]))
// {
// entry.AnsweredMessageID = Convert.ToInt64(row["AnsweredMessageID"]);
// }
// if (row.Table.Columns.Contains("FromFullName") && !Convert.IsDBNull(row["FromFullName"]))
// {
// entry.FromFullName = Convert.ToString(row["FromFullName"]);
// }
// return entry;
//}
//#endregion
#region IDaoBase Members
public Framework.DataServices.Model.EntityBaseData Load(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.Mensagem entryData = (Model.Boloes.Mensagem)entry;
DataTable table = base.ExecuteFill(CommandType.StoredProcedure, base._commandSelect, true, currentUser,
base.Parameters.Create("@MessageID", DbType.Int64, entryData.MessageID),
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@FromUser", DbType.String, entryData.FromUser),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
int rowsFound = Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value);
if (rowsFound == 0)
{
return(null);
}
//throw new Exception("There is no item found in database with this ID.");
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Util.Mensagem.ConvertToObject(table.Rows[0]));
}
public bool AddMessage(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.Mensagem entryData = (Model.Boloes.Mensagem)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Mensagens_AddMessage", true, currentUser,
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@FromUser", DbType.String, entryData.FromUser),
base.Parameters.Create("@Private", DbType.Boolean, entryData.Private),
base.Parameters.Create("@ToUser", DbType.String, entryData.ToUser),
base.Parameters.Create("@Title", DbType.String, entryData.Title),
base.Parameters.Create("@Message", DbType.String, entryData.Message),
base.Parameters.Create("@AnsweredMessageID", DbType.Int64, entryData.AnsweredMessageID),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public void Copy(Model.Boloes.Mensagem entry)
{
_answeredMessageID = entry._answeredMessageID;
_bolao = entry._bolao;
_fromUser = entry._fromUser;
_message = entry._message;
_messageID = entry._messageID;
_private = entry._private;
_title = entry._title;
_totalRead = entry._totalRead;
_toUser = entry._toUser;
_fromFullName = entry._fromFullName;
base.Copy(entry);
}
private void Save()
{
if (!IsValid)
{
return;
}
Model.Boloes.Mensagem mensagem = GetMensagem();
Business.Boloes.Support.Mensagens business = new BolaoNet.Business.Boloes.Support.Mensagens(base.UserName);
business.Copy((Model.Boloes.Mensagem)mensagem);
if (business.AddMessage())
{
base.ShowMessages("Mensagem enviada com sucesso.");
}
else
{
base.ShowErrors("Erro ao enviar a mensagem.");
}
}
protected void dtlMessages_ItemDataBound(object sender, DataListItemEventArgs e)
{
Model.Boloes.Mensagem mensagem = (Model.Boloes.Mensagem)e.Item.DataItem;
//Atribuindo o ID da mensagem
LinkButton lnkDelete = (LinkButton)e.Item.FindControl("lnkDelete");
lnkDelete.CommandArgument = mensagem.MessageID.ToString();
//Mostrando a imagem do usuário
Image imgUser = (Image)e.Item.FindControl("imgUser");
string fileImage = "~/Images/Database/Users/" + mensagem.FromUser + ".jpg";
if (!System.IO.File.Exists(Server.MapPath(fileImage)))
{
fileImage = "~/Images/Database/Users/No-Image.png";
}
imgUser.ImageUrl = fileImage;
}
