public int InsertExamMaster(PlExamMaster pl)
{
cmd = new SqlCommand("SPExamMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UnivCode", pl.UnivCode);
//cmd.Parameters.AddWithValue("@Ctrl", pl.Ctrl);
cmd.Parameters.AddWithValue("@FacultyCD", pl.FacultyCD);
cmd.Parameters.AddWithValue("@ExamName", pl.ExamName);
cmd.Parameters.AddWithValue("@ExamShortName", pl.ExamShortName);
cmd.Parameters.AddWithValue("@ExamType", pl.ExamType);
cmd.Parameters.AddWithValue("@TotalYearSem", pl.TotalYearSem);
cmd.Parameters.AddWithValue("@NoOfYearSem", pl.NoOfYearSem);
cmd.Parameters.AddWithValue("@CourseCD", pl.CourseCD);
cmd.Parameters.AddWithValue("@CourseName", pl.CourseName);
cmd.Parameters.AddWithValue("@RefCtrl", pl.RefCtrl);
cmd.Parameters.AddWithValue("@IPAddress", pl.IPAddress);
cmd.Parameters.AddWithValue("@UserID", pl.UserID);
cmd.Parameters.AddWithValue("@CreationDate", pl.CreationDate);
cmd.Parameters.AddWithValue("@GroupID", pl.GroupID);
cmd.Parameters.AddWithValue("@GroupSubID", pl.GroupSubID);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return(i);
}
public DataTable GetLastExamMaster(PlExamMaster pl)
{
cmd = new SqlCommand("SPExamMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable GetLastExamMaster(PlExamMaster pl)
{
return(dt = dl.GetLastExamMaster(pl));
}
public int InsertExamMaster(PlExamMaster pl)
{
int i = dl.InsertExamMaster(pl);
return(i);
}
