public void Update_MSN(int p_MSN_ID, string p_MSN_Name, string p_MSN_Invitee)
{
p_MSN_Name = FilterUtility.FilterSQL(p_MSN_Name);
p_MSN_Invitee = FilterUtility.FilterSQL(p_MSN_Invitee);
Entity.MSN o_MSN = new Entity.MSN();
o_MSN.MSN_ID = p_MSN_ID;
o_MSN.MSN_Name = p_MSN_Name;
o_MSN.MSN_Invitee = p_MSN_Invitee;
d_MSN.Update_MSN(o_MSN);
}
public void Insert_MSN(string p_MSN_Name, string p_MSN_Invitee)
{
p_MSN_Name = FilterUtility.FilterSQL(p_MSN_Name);
p_MSN_Invitee = FilterUtility.FilterSQL(p_MSN_Invitee);
Entity.MSN o_MSN = new Entity.MSN();
o_MSN.MSN_ID = 0;
o_MSN.MSN_Name = p_MSN_Name;
o_MSN.MSN_Invitee = p_MSN_Invitee;
d_MSN.Insert_MSN(o_MSN);
}
public Entity.MSN[] Select_MSN()
{
DataTable o_DataTable = d_MSN.Select_MSN();
if (o_DataTable == null)
return null;
Entity.MSN[] e_MSN = new Entity.MSN[o_DataTable.Rows.Count];
int i = 0;
foreach (DataRow o_DataRow in o_DataTable.Rows)
{
e_MSN[i] = new Entity.MSN();
e_MSN[i].MSN_ID = Convert.ToInt32(o_DataRow["MSN_ID"].ToString());
e_MSN[i].MSN_Name = o_DataRow["MSN_Name"].ToString();
e_MSN[i].MSN_Invitee = o_DataRow["MSN_Invitee"].ToString();
i++;
}
return e_MSN;
}
