public Messagesinfo Messages_Sel_MessageID(int id)
{
Messagesinfo x = new Messagesinfo();
DataTable a = new DataTable();
Messagesdal t = new Messagesdal();
a = t.Messages_Sel_MessageID(id).Tables[0];
x.MessageID = id;
if (a.Rows[0]["MessageSubject"].ToString() != string.Empty)
{
x.MessageSubject = a.Rows[0]["MessageSubject"].ToString();
}
if (a.Rows[0]["MessageBody"].ToString() != string.Empty)
{
x.MessageBody = a.Rows[0]["MessageBody"].ToString();
}
if (a.Rows[0]["FileAttach"].ToString() != string.Empty)
{
x.FileAttach = a.Rows[0]["FileAttach"].ToString();
}
if (a.Rows[0]["MessageHot"].ToString() != string.Empty)
{
x.MessageHot = bool.Parse(a.Rows[0]["MessageHot"].ToString());
}
return(x);
}
public bool NewsAdd(Messagesinfo x)
{
Messagesdal t = new Messagesdal();
try
{
//t.NewsAdd2(x);
}
catch { }
return(t.NewsAdd(x));
}
public bool NewsUps(Messagesinfo x)
{
Messagesdal t = new Messagesdal();
try
{
// t.NewsUpdate2(x);
}
catch { }
return(t.NewsUpdate(x));
}
public Messagesinfo News_Sel_MessageID(int id)
{
Messagesinfo x = new Messagesinfo();
DataTable a = new DataTable();
Messagesdal t = new Messagesdal();
a = t.News_Sel_MessageID(id).Tables[0];
x.MessageID = id;
if (a.Rows[0]["MessageSubject"].ToString() != string.Empty)
{
x.MessageSubject = a.Rows[0]["MessageSubject"].ToString();
}
if (a.Rows[0]["MessageBody"].ToString() != string.Empty)
{
x.MessageBody = a.Rows[0]["MessageBody"].ToString();
}
if (a.Rows[0]["MessageNote"].ToString() != string.Empty)
{
x.MessageNote = a.Rows[0]["MessageNote"].ToString();
}
if (a.Rows[0]["FileAttach"].ToString() != string.Empty)
{
x.FileAttach = a.Rows[0]["FileAttach"].ToString();
}
if (a.Rows[0]["CreationDate"].ToString() != string.Empty)
{
x.CreationDate = a.Rows[0]["CreationDate"].ToString();
}
if (a.Rows[0]["SenderName"].ToString() != string.Empty)
{
x.SenderName = a.Rows[0]["SenderName"].ToString();
}
if (a.Rows[0]["MessageCateID"].ToString() != string.Empty)
{
x.MessageCateID = int.Parse(a.Rows[0]["MessageCateID"].ToString());
}
if ((a.Rows[0]["Note"].ToString() != string.Empty) && (a.Rows[0]["Note"].ToString() == "1"))
{
x.Note = 1;
}
else
{
x.Note = 0;
}
return(x);
}
public bool MessageUpdate(Messagesinfo x)
{
Messagesdal t = new Messagesdal();
return(t.MessageUpdate(x));
}
public bool MessageUpdate(Messagesinfo x)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_psc_ws_Message_Ups";
//
SqlParameter para;
para = cmd.Parameters.Add("MessageID", SqlDbType.Int);
para.Direction = ParameterDirection.Input;
para.Value = x.MessageID;
para = cmd.Parameters.Add("MessageSubject", SqlDbType.NVarChar);
para.Direction = ParameterDirection.Input;
if (x.MessageSubject == null)
{
para.Value = "";
}
else
{
para.Value = x.MessageSubject;
}
para = cmd.Parameters.Add("MessageBody", SqlDbType.NText);
para.Direction = ParameterDirection.Input;
if (x.MessageBody == null)
{
para.Value = "";
}
else
{
para.Value = x.MessageBody;
}
para = cmd.Parameters.Add("FileAttach", SqlDbType.VarChar);
para.Direction = ParameterDirection.Input;
if (x.FileAttach == null)
{
para.Value = DBNull.Value;
}
else
{
para.Value = x.FileAttach;
}
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
finally
{
con.Close();
}
}
