public static void Create(TbMessage msg)
{
using (DataAccess.Message db = new DataAccess.Message())
{
msg.RegisterDate = DateTime.Now;
msg.SendDate = msg.RegisterDate;
db.Create(msg);
}
}
public void Create(TbMessage msg)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Insert Into TbMessage (CategoryId,UserId,RegisterDate,SendDate,Description) values (@CategoryId,@UserId,@RegisterDate,@SendDate,@Description)";
cmd.Parameters.AddWithValue("@CategoryId", msg.CategoryId);
cmd.Parameters.AddWithValue("@UserId", msg.UserId);
cmd.Parameters.AddWithValue("@RegisterDate", msg.RegisterDate);
cmd.Parameters.AddWithValue("@SendDate", msg.SendDate);
cmd.Parameters.AddWithValue("@Description", msg.Description);
cmd.ExecuteNonQuery();
}
public static TbMessage ToEntity(System.Data.IDataReader reader)
{
TbMessage msg = null;
msg = new TbMessage();
msg.Id = Convert.ToInt32(reader["Id"]);
msg.CategoryId = Convert.ToInt32(reader["CategoryId"]);
msg.UserId = Convert.ToInt32(reader["UserId"]);
msg.Description = Convert.ToString(reader["Description"]);
msg.RegisterDate = Convert.ToDateTime(reader["RegisterDate"]);
if (reader["SendDate"] != DBNull.Value)
msg.SendDate = Convert.ToDateTime(reader["SendDate"]);
msg.CategoryTitle = Convert.ToString(reader["CategoryTitle"]);
if (reader["Share"] != DBNull.Value)
msg.Share = Convert.ToInt32(reader["Share"]);
return msg;
}
public MethodResult InsertMessage(int categoryId, int userId, string description)
{
try
{
TbMessage msg = new TbMessage();
msg.CategoryId = categoryId;
msg.UserId = userId;
msg.Description = description;
Business.Message.Create(msg);
return new MethodResult(false, null, null);
}
catch (HabbeException e)
{
return new MethodResult(true, e.Message, null);
}
}
public void Update(TbMessage msg)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Update TbMessage set CategoryId=@CategoryId , Description=@Description,RegisterDate=@RegisterDate,SendDate=@SendDate,UserId=@UserId where Id=@Id";
cmd.Parameters.AddWithValue("@CategoryId", msg.CategoryId);
cmd.Parameters.AddWithValue("@Description", msg.Description);
cmd.Parameters.AddWithValue("@RegisterDate", msg.RegisterDate);
cmd.Parameters.AddWithValue("@SendDate", msg.SendDate);
cmd.Parameters.AddWithValue("@UserId", msg.UserId);
cmd.Parameters.AddWithValue("@Id", msg.Id);
cmd.ExecuteNonQuery();
}
