public static string EnrollCourse(string[] cid, int credithours)
{
string result = "";
DBFunctions db = new DBFunctions();
for (int i = 0; i < cid.Length;i++)
{
Enroll_Course enroll = new Enroll_Course { CourseID = Convert.ToInt16(cid[i]), Uid = uid, Status = 0 };
db.Enrollcourse(enroll);
}
StudentSelectedCredit obj = db.getStudentCredits(uid).FirstOrDefault();
if (obj == null)
{
StudentSelectedCredit temp = new StudentSelectedCredit();
temp.UserID = uid;
temp.SelectedCourseCount = credithours;
int check = -1;
check = db.AddCreditHours(temp);
if (check != 1)
{
result = "Success";
}
}
else
{
StudentSelectedCredit temp = new StudentSelectedCredit();
temp.UserID = uid;
temp.SelectedCourseCount = credithours;
temp.ID = obj.ID;
db.UpdateCreditHours(temp);
}
return result;
}
public static string EnrollCourse(string[] cid, int credithours)
{
string result = "";
DBFunctions db = new DBFunctions();
for (int i = 0; i < cid.Length; i++)
{
Enroll_Course enroll = new Enroll_Course {
CourseID = Convert.ToInt16(cid[i]), Uid = uid, Status = 0
};
db.Enrollcourse(enroll);
}
StudentSelectedCredit obj = db.getStudentCredits(uid).FirstOrDefault();
if (obj == null)
{
StudentSelectedCredit temp = new StudentSelectedCredit();
temp.UserID = uid;
temp.SelectedCourseCount = credithours;
int check = -1;
check = db.AddCreditHours(temp);
if (check != 1)
{
result = "Success";
}
}
else
{
StudentSelectedCredit temp = new StudentSelectedCredit();
temp.UserID = uid;
temp.SelectedCourseCount = credithours;
temp.ID = obj.ID;
db.UpdateCreditHours(temp);
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
bool loggedStatus = false;
if (System.Web.HttpContext.Current.User != null)
{
if (!IsPostBack)
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
DBFunctions db = new DBFunctions();
DatabaseFunctions d = new DatabaseFunctions();
Userid = Membership.GetUser().ProviderUserKey.ToString();
uid = d.GetCandidateID(Userid);
// loadprogrammes();
StudentInfo_tbl temp = db.getstdentinfo(uid);
StudentSelectedCredit obj = db.getStudentCredits(uid).FirstOrDefault();
if (obj != null)
{
Credits = Convert.ToInt16(obj.SelectedCourseCount);
}
getcourses();
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
}
// dropdownCourse.DataSource=
}
public void UpdateCreditHours(StudentSelectedCredit t)
{
db = new CollegeERPDBEntities();
db.StudentSelectedCredits.Attach(t);
db.Entry(t).State = EntityState.Modified;
db.SaveChanges();
}
public int AddCreditHours(StudentSelectedCredit obj)
{
using (db = new CollegeERPDBEntities())
{
db.StudentSelectedCredits.Add(obj);
db.SaveChanges();
}
return obj.ID;
}
