public void AddClassSubscriptions(ClassSubscriptions cs)
{
string command = "INSERT INTO dbo.ClassSubscriptions(ClassID , MemberID , CreatedAt) VALUES (@ClassID , @MemberID , CURRENT_TIMESTAMP)";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@ClassID", cs.ClassID);
param[1] = new SqlParameter("@MemberID", cs.MemberID);
da.Insert(param, command);
}
public ActionResult addClassSubscriptions(FormCollection fc)
{
if (ModelState.IsValid)
{
int classID = int.Parse(fc["class"].ToString());
int memberID = int.Parse(fc["member"].ToString());
ClassSubscriptions cs = new ClassSubscriptions();
cs.ClassID = classID;
cs.MemberID = memberID;
classOpt.AddClassSubscriptions(cs);
}
return(RedirectToAction("AssignClass"));
}
