//#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; }