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(); }