public static string getClassdata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblClasses
orderby c.CLASS_ID descending
select new
{
CLASS_ID = c.CLASS_ID,
CLASS_STATUS = c.CLASS_STATUS,
CLASS_LEVEL_NAME = c.tblClassLevel.CLASS_LEVEL_NAME,
CLASS_DAY = c.CLASS_DAY,
CLASS_TIME = c.CLASS_TIME
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getRankdata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblRanks
orderby c.RANK_ID descending
select new
{
RANK_ID = c.RANK_ID,
RANK_BELT_COLOR = c.RANK_BELT_COLOR,
RANK_REQUIREMENTS = c.RANK_REQUIREMENTS,
RANK_STATUS = c.RANK_STATUS,
RANK_IS_DEFAULT = c.RANK_IS_DEFAULT
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string ChangeStatus(string strAssignRankID)
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iAssignRankID = int.Parse(strAssignRankID);
var query = (from c in entities.tblStudentProgresses
where c.STU_PROG_ID == iAssignRankID
select c).Single();
if (query.STU_PROG_STATUS == true)
{
query.STU_PROG_STATUS = false;
}
else
{
query.STU_PROG_STATUS = true;
}
entities.SaveChanges();
}
return("True");
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iClassLevelID = int.Parse(hdnPKId.Value);
var query = (from c in entities.tblClassLevels
where c.CLASS_LEVEL_ID == iClassLevelID
select c).FirstOrDefault();
txtClassLevel.Text = query.CLASS_LEVEL_NAME;
if (query.CLASS_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getAssignedRankdata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblStudentProgresses
orderby c.STU_PROG_ID descending
select new
{
STU_PROG_ID = c.STU_PROG_ID,
STU_PROG_STATUS = c.STU_PROG_STATUS,
STU_NUM = c.tblStudent.STU_NUM,
RANK_BELT_COLOR = c.tblRank.RANK_BELT_COLOR,
STU_PROG_RANK_DATE = c.STU_PROG_RANK_DATE
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string ChangeStatus(string strPaymentID)
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iPaymentID = int.Parse(strPaymentID);
var query = (from c in entities.tblPayments
where c.PAYMENT_ID == iPaymentID
select c).Single();
if (query.PAYMENT_STATUS == true)
{
query.PAYMENT_STATUS = false;
}
else
{
query.PAYMENT_STATUS = true;
}
entities.SaveChanges();
}
return("True");
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iPaymentID = int.Parse(hdnPKId.Value);
var query = (from p in entities.tblPaymentTypes
where p.PAYMENT_TYPE_ID == iPaymentID
select p).FirstOrDefault();
txtPaymentType.Text = query.PAYMENT_TYPE;
txtAmount.Text = query.PAYMENT_TYPE_AMOUNT.ToString();
if (query.PAYMENT_TYPE_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getPaymentdata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblPaymentTypes
orderby c.PAYMENT_TYPE_ID descending
select new
{
PAYMENT_TYPE_ID = c.PAYMENT_TYPE_ID,
PAYMENT_TYPE = c.PAYMENT_TYPE,
PAYMENT_TYPE_AMOUNT = c.PAYMENT_TYPE_AMOUNT,
PAYMENT_TYPE_STATUS = c.PAYMENT_TYPE_STATUS
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iClassID = int.Parse(hdnPKId.Value);
var query = (from p in entities.tblClasses
where p.CLASS_ID == iClassID
select p).FirstOrDefault();
txtDay.Text = query.CLASS_DAY;
txtTime.Text = query.CLASS_TIME;
ddlClassType.SelectedValue = query.CLASS_LEVEL_ID.ToString();
if (query.CLASS_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iRankTypeID = int.Parse(hdnPKId.Value);
var query = (from p in entities.tblRanks
where p.RANK_ID == iRankTypeID
select p).FirstOrDefault();
txtBeltColor.Text = query.RANK_BELT_COLOR;
txtRequirements.Text = query.RANK_REQUIREMENTS;
if (query.RANK_IS_DEFAULT == true)
{
chkIsDefault.Checked = true;
}
else
{
chkIsDefault.Checked = false;
}
if (query.RANK_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getStudentProgressData(string strStudentID)
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int sid = int.Parse(strStudentID);
var studentID = (from s in entities.tblStudents
join sp in entities.tblStudentProgresses on s.STU_ID equals sp.STU_ID
join r in entities.tblRanks on sp.RANK_ID equals r.RANK_ID
where s.STU_ID == sid
orderby sp.STU_PROG_RANK_DATE descending
select new
{
STU_PROG_RANK_DATE = sp.STU_PROG_RANK_DATE,
STU_ID = s.STU_ID,
STU_NUM = s.STU_NUM,
RANK_BELT_COLOR = r.RANK_BELT_COLOR
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getStudentData()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from s in entities.tblStudents
join sp in entities.tblStudentProgresses on s.STU_ID equals sp.STU_ID
join r in entities.tblRanks on sp.RANK_ID equals r.RANK_ID
orderby s.STU_ID descending
select new
{
STU_ID = s.STU_ID,
STU_NUM = s.STU_NUM
}).ToList().Distinct();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iPaymentID = int.Parse(hdnPKId.Value);
var query = (from c in entities.tblPayments
where c.PAYMENT_ID == iPaymentID
select c).FirstOrDefault();
txtAmount.Text = query.PAYMENT_AMOUNT.ToString();
string date = query.PAYMENT_DATE.ToString();
DateTime dt = DateTime.ParseExact(date, "dd-MM-yyyy hh:mm:ss tt", null);
txtDOP.Text = dt.ToString("MM/dd/yyyy");
var objStudent = entities.tblStudents.Where(s => s.STU_ID == query.STU_ID).OrderByDescending(s => s.STU_NUM).FirstOrDefault();
txtStudentNumber.Text = objStudent.STU_NUM;
ddlPaymentType.SelectedValue = query.PAYMENT_TYPE_ID.ToString();
if (query.PAYMENT_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string ChangeStatus(string strClassTypeID)
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iClassTypeID = int.Parse(strClassTypeID);
var query = (from c in entities.tblClassLevels
where c.CLASS_LEVEL_ID == iClassTypeID
select c).Single();
if (query.CLASS_STATUS == true)
{
query.CLASS_STATUS = false;
}
else
{
query.CLASS_STATUS = true;
}
entities.SaveChanges();
}
return("True");
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iParentID = int.Parse(hdnPKId.Value);
var query = (from p in entities.tblParents
where p.PARENT_ID == iParentID
select p).FirstOrDefault();
txtFName.Text = query.PARENT_FNAME;
txtMName.Text = query.PARENT_MNAME;
txtLName.Text = query.PARENT_LNAME;
txtEmail.Text = query.PARENT_EMAIL;
txtMobileNumber.Text = query.PARENT_MNUM;
var objStudent = entities.tblStudents.Where(s => s.STU_ID == query.STU_ID).OrderByDescending(s => s.STU_NUM).FirstOrDefault();
txtStudentNumber.Text = objStudent.STU_NUM;
if (query.PARENT_GENDER == true)
{
rbtnMale.Checked = true;
rbtnFemale.Checked = false;
}
else
{
rbtnMale.Checked = false;
rbtnFemale.Checked = true;
}
if (query.PARENT_IS_STUDENT == true)
{
chkIsStudent.Checked = true;
}
else
{
chkIsStudent.Checked = false;
}
if (query.PARENT_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iStuID = int.Parse(hdnPKId.Value);
var query = (from c in entities.tblStudents
where c.STU_ID == iStuID
select c).FirstOrDefault();
txtFName.Text = query.STU_FNAME;
txtMName.Text = query.STU_MNAME;
txtLName.Text = query.STU_LNAME;
txtEmail.Text = query.STU_EMAIL;
txtMobileNumber.Text = query.STU_MNUM;
rbtnMale.Checked = true;
rbtnFemale.Checked = false;
string date = query.STU_DOB.ToString();
DateTime dt = DateTime.ParseExact(date, "dd-MM-yyyy hh:mm:ss tt", null);
txtDOB.Text = dt.ToString("MM/dd/yyyy");
string date2 = query.STU_DOJ.ToString();
DateTime dt2 = DateTime.ParseExact(date2, "dd-MM-yyyy hh:mm:ss tt", null);
txtDOJ.Text = dt2.ToString("MM/dd/yyyy");
txtStreet.Text = query.STU_STREET;
txtCity.Text = query.STU_CITY;
txtState.Text = query.STU_STATE;
txtZIP.Text = query.STU_ZIP;
if (query.STU_STATUS == true)
{
chkIsApprove.Checked = true;
}
else
{
chkIsApprove.Checked = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getStudentData()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblStudents
// where (c.STU_DOB >= strFromDate1 && c.STU_DOB <= strToDate1)
orderby c.STU_ID descending
select new
{
STU_ID = c.STU_ID,
STU_FNAME = c.STU_FNAME,
STU_MNAME = c.STU_MNAME,
STU_LNAME = c.STU_LNAME,
STU_NUM = c.STU_NUM,
STU_DOB = c.STU_DOB,
STU_DOJ = c.STU_DOJ,
STU_MNUM = c.STU_MNUM,
STU_EMAIL = c.STU_EMAIL,
STU_STREET = c.STU_STREET,
STU_CITY = c.STU_CITY,
STU_STATE = c.STU_STATE,
STU_ZIP = c.STU_ZIP,
STU_STATUS = c.STU_STATUS
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getParentsdata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from c in entities.tblParents
join s in entities.tblStudents on c.STU_ID equals s.STU_ID
orderby c.PARENT_ID descending
select new
{
PARENT_ID = c.PARENT_ID,
STU_NUM = s.STU_NUM,
PARENT_FNAME = c.PARENT_FNAME,
PARENT_MNAME = c.PARENT_MNAME,
PARENT_LNAME = c.PARENT_LNAME,
PARENT_MNUM = c.PARENT_MNUM,
PARENT_EMAIL = c.PARENT_EMAIL,
PARENT_GENDER = c.PARENT_GENDER,
PARENT_STATUS = c.PARENT_STATUS,
PARENT_IS_STUDENT = c.PARENT_IS_STUDENT
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string getStudentData()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from p in entities.tblPayments
join s in entities.tblStudents on p.STU_ID equals s.STU_ID
group p by new { p.STU_ID, s.STU_NUM } into g
orderby g.Key.STU_ID descending
select new
{
STU_ID = g.Key.STU_ID,
STU_NUM = g.Key.STU_NUM,
TotalAmount = g.Sum(p => p.PAYMENT_AMOUNT),
TotalPaidAmount = g.Where(p => p.PAYMENT_STATUS == true).Sum(d => (Int32?)d.PAYMENT_AMOUNT),
TotalAmountToBePaid = g.Where(p => p.PAYMENT_STATUS == false).Sum(d => (Int32?)d.PAYMENT_AMOUNT),
}).ToList().Select(x => new {
STU_NUM = x.STU_NUM,
TotalAmount = x.TotalAmount == null? 0 : x.TotalAmount.Value,
TotalPaidAmount = x.TotalPaidAmount == null ? 0 : x.TotalPaidAmount.Value,
TotalAmountToBePaid = x.TotalAmountToBePaid == null ? 0 : x.TotalAmountToBePaid.Value,
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void setValuesToControls()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int iAttID = int.Parse(hdnPKId.Value);
var query = (from c in entities.tblAttendences
where c.ATT_ID == iAttID
select c).FirstOrDefault();
var objStudent = entities.tblStudents.Where(s => s.STU_ID == query.STU_ID).OrderByDescending(s => s.STU_NUM).FirstOrDefault();
txtStudentNumber.Text = objStudent.STU_NUM;
string date = query.ATT_DATE.ToString();
DateTime dt = DateTime.ParseExact(date, "dd-MM-yyyy hh:mm:ss tt", null);
txtDate.Text = dt.ToString("MM/dd/yyyy");
if (query.ATT_STATUS == true)
{
chkIsPresent.Checked = true;
}
else
{
chkIsPresent.Checked = false;
}
ddlClassLevel.SelectedValue = query.tblClass.CLASS_LEVEL_ID.ToString();
fillClassTypeddl();
ddlClassType.SelectedValue = query.CLASS_ID.ToString();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void fillClassLevelddl()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var category = (from c in entities.tblClassLevels
where c.CLASS_STATUS == true
select new { c.CLASS_LEVEL_ID, c.CLASS_LEVEL_NAME }).ToList();
ddlClassType.DataValueField = "CLASS_LEVEL_ID";
ddlClassType.DataTextField = "CLASS_LEVEL_NAME";
ddlClassType.DataSource = category;
ddlClassType.DataBind();
// ddlPaymentType.Items.Add(new ListItem("Select Payment Type", "0"));
ddlClassType.Items.Insert(0, new ListItem("--Select Class Level--"));
}
}
catch (Exception ex)
{
}
}
public void fillClassTypeddl()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var classLevelID = int.Parse(ddlClassLevel.SelectedValue);
var category = (from c in entities.tblClasses
where c.CLASS_STATUS == true && c.CLASS_LEVEL_ID == classLevelID
select new { CLASS_ID = c.CLASS_ID, Class_Name = c.CLASS_DAY + " (" + c.CLASS_TIME + ") " }).ToList();
ddlClassType.DataValueField = "CLASS_ID";
ddlClassType.DataTextField = "Class_Name";
ddlClassType.DataSource = category;
ddlClassType.DataBind();
ddlClassType.Items.Insert(0, new ListItem("--Select Class--"));
}
}
catch (Exception ex)
{
}
}
public void fillPaymentTypeddl()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var category = (from c in entities.tblPaymentTypes
where c.PAYMENT_TYPE_STATUS == true
select new { c.PAYMENT_TYPE_ID, c.PAYMENT_TYPE }).ToList();
ddlPaymentType.DataValueField = "PAYMENT_TYPE_ID";
ddlPaymentType.DataTextField = "PAYMENT_TYPE";
ddlPaymentType.DataSource = category;
ddlPaymentType.DataBind();
// ddlPaymentType.Items.Add(new ListItem("Select Payment Type", "0"));
ddlPaymentType.Items.Insert(0, new ListItem("--Select Payment Type--"));
}
}
catch (Exception ex)
{
}
}
public static string getAttendancedata()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from s in entities.tblStudents
join a in entities.tblAttendences on s.STU_ID equals a.STU_ID
join c in entities.tblClasses on a.CLASS_ID equals c.CLASS_ID
join cl in entities.tblClassLevels on c.CLASS_LEVEL_ID equals cl.CLASS_LEVEL_ID
orderby a.ATT_ID descending
select new
{
ATT_DATE = a.ATT_DATE,
STU_NUM = s.STU_NUM,
ATT_STATUS = a.ATT_STATUS,
CLASS_DAY = c.CLASS_DAY,
CLASS_TIME = c.CLASS_TIME,
CLASS_LEVEL_NAME = cl.CLASS_LEVEL_NAME,
ATT_ID = a.ATT_ID
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(studentID,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void CheckLogin()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var InstructorID = (from obj in entities.tblInstructors
where obj.INSTRUCTOR_NAME == txtUserName.Text && obj.INSTRUCTOR_PASSWORD == txtPassword.Text
select obj.INSTRUCTOR_ID).FirstOrDefault();
if (InstructorID != 0)
{
Response.Redirect("StudentReport.aspx");
}
else
{
divErrorMsg.Visible = true;
return;
}
}
}
catch (Exception ex)
{
}
}
public static string getStudentParentData(string strStudentID)
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var StudentID = int.Parse(strStudentID);
var parent = (from p in entities.tblParents
where p.STU_ID == StudentID
orderby p.PARENT_ID descending
select new
{
PARENT_NAME = p.PARENT_FNAME + " " + p.PARENT_MNAME + " " + p.PARENT_LNAME,
PARENT_GENDER = p.PARENT_GENDER,
PARENT_EMAIL = p.PARENT_EMAIL,
PARENT_IS_STUDENT = p.PARENT_IS_STUDENT,
PARENT_MNUM = p.PARENT_MNUM,
PARENT_ID = p.PARENT_ID
}).ToList();
JavaScriptSerializer jss = new JavaScriptSerializer();
var list = JsonConvert.SerializeObject(parent,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
//return Content(list, "application/json");
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertBeltType()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int ihdnPKID = int.Parse(hdnPKId.Value);
Int32 beltColorID = 0;
if (ihdnPKID == 0)
{
beltColorID = (from obj in entities.tblRanks
where obj.RANK_BELT_COLOR == txtBeltColor.Text
select obj.RANK_ID).FirstOrDefault();
}
else
{
beltColorID = (from obj in entities.tblRanks
where obj.RANK_BELT_COLOR == txtBeltColor.Text && obj.RANK_ID != ihdnPKID
select obj.RANK_ID).FirstOrDefault();
}
if (beltColorID == 0)
{
var objRank = entities.tblRanks.Where(s => s.RANK_ID == ihdnPKID).OrderByDescending(s => s.RANK_ID).FirstOrDefault();
if (objRank == null)
{
objRank = new tblRank();
}
objRank.RANK_BELT_COLOR = txtBeltColor.Text;
objRank.RANK_REQUIREMENTS = txtRequirements.Text;
objRank.RANK_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objRank.RANK_CREATED_DATE = DateTime.Now;
objRank.RANK_STATUS = chkIsApprove.Checked;
if (chkIsDefault.Checked)
{
(from x in entities.tblRanks
select x).ToList().ForEach(xx => xx.RANK_IS_DEFAULT = false);
entities.SaveChanges();
}
objRank.RANK_IS_DEFAULT = chkIsDefault.Checked;
if (objRank.RANK_ID == 0)
{
entities.tblRanks.Add(objRank);
}
else
{
objRank.RANK_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objRank.RANK_MODIFIED_DATE = DateTime.Now;
entities.Entry(objRank).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objRank = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("RankTypeList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}
public void InsertClass()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var classTypeID = int.Parse(ddlClassType.SelectedValue);
int ihdnPKID = int.Parse(hdnPKId.Value);
Int32 ClassID = 0;
if (ihdnPKID == 0)
{
ClassID = (from obj in entities.tblClasses
where obj.CLASS_LEVEL_ID == classTypeID && obj.CLASS_DAY == txtDay.Text && obj.CLASS_TIME == txtTime.Text
select obj.CLASS_ID).FirstOrDefault();
}
else
{
ClassID = (from obj in entities.tblClasses
where obj.CLASS_LEVEL_ID == classTypeID && obj.CLASS_DAY == txtDay.Text && obj.CLASS_TIME == txtTime.Text && obj.CLASS_ID != ihdnPKID
select obj.CLASS_ID).FirstOrDefault();
}
if (ClassID == 0)
{
var objClass = entities.tblClasses.Where(s => s.CLASS_ID == ihdnPKID).OrderByDescending(s => s.CLASS_ID).FirstOrDefault();
if (objClass == null)
{
objClass = new tblClass();
}
objClass.CLASS_LEVEL_ID = Convert.ToInt32(ddlClassType.SelectedValue);
objClass.CLASS_DAY = txtDay.Text;
objClass.CLASS_TIME = txtTime.Text;
objClass.CLASS_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objClass.CLASS_CREATED_DATE = DateTime.Now;
objClass.CLASS_STATUS = chkIsApprove.Checked;
if (objClass.CLASS_ID == 0)
{
entities.tblClasses.Add(objClass);
}
else
{
objClass.CLASS_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objClass.CLASS_MODIFIED_DATE = DateTime.Now;
entities.Entry(objClass).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objClass = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("ClassList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}
public void InsertPayment()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from obj in entities.tblStudents
where obj.STU_NUM == txtStudentNumber.Text
select obj.STU_ID).FirstOrDefault();
//var query = entities.tblStudents.AsEnumerable().Where(s => s.STU_NUM.Contains(txtStudentNumber.Text)).Select(s => s.STU_ID).Distinct();
if (studentID != 0)
{
int ihdnPKID = int.Parse(hdnPKId.Value);
var objPayment = entities.tblPayments.Where(s => s.PAYMENT_ID == ihdnPKID).OrderByDescending(s => s.PAYMENT_ID).FirstOrDefault();
if (objPayment == null)
{
objPayment = new tblPayment();
}
objPayment.PAYMENT_AMOUNT = Convert.ToDecimal(txtAmount.Text);
objPayment.PAYMENT_DATE = DateTime.ParseExact(txtDOP.Text, "MM/dd/yyyy", null);
objPayment.PAYMENT_TYPE_ID = Convert.ToInt32(ddlPaymentType.SelectedValue);
objPayment.PAYMENT_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objPayment.PAYMENT_CREATED_DATE = DateTime.Now;
objPayment.STU_ID = Convert.ToInt32(studentID);
objPayment.PAYMENT_STATUS = chkIsApprove.Checked;
if (objPayment.PAYMENT_ID == 0)
{
entities.tblPayments.Add(objPayment);
}
else
{
objPayment.PAYMENT_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objPayment.PAYMENT_MODIFIED_DATE = DateTime.Now;
entities.Entry(objPayment).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objPayment = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("PaymentList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}
public void InsertAttendance()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
var studentID = (from obj in entities.tblStudents
where obj.STU_NUM == txtStudentNumber.Text
select obj.STU_ID).FirstOrDefault();
var classID = int.Parse(ddlClassType.SelectedValue);
//DateTime dtFrom = Convert.ToDateTime(txtDate.Text);
//var AttendanceID = (from obj in entities.tblAttendences
// where obj.CLASS_ID == ddlClassType.SelectedIndex && obj.STU_ID == studentID && obj.ATT_DATE == dtFrom
// select obj.ATT_ID).FirstOrDefault();
int ihdnPKID = int.Parse(hdnPKId.Value);
Int32 AttendanceID = 0;
if (ihdnPKID == 0)
{
AttendanceID = (from obj in entities.tblAttendences
where obj.CLASS_ID == classID && obj.STU_ID == studentID
select obj.ATT_ID).FirstOrDefault();
}
else
{
AttendanceID = (from obj in entities.tblAttendences
where obj.CLASS_ID == classID && obj.STU_ID == studentID && obj.ATT_ID != ihdnPKID
select obj.ATT_ID).FirstOrDefault();
}
if (studentID != 0 && AttendanceID == 0)
{
var objAttendence = entities.tblAttendences.Where(s => s.ATT_ID == ihdnPKID).OrderByDescending(s => s.ATT_ID).FirstOrDefault();
if (objAttendence == null)
{
objAttendence = new tblAttendence();
}
objAttendence.STU_ID = Convert.ToInt32(studentID);
objAttendence.ATT_DATE = DateTime.ParseExact(txtDate.Text, "MM/dd/yyyy", null);
objAttendence.CLASS_ID = Convert.ToInt32(ddlClassType.SelectedValue);
objAttendence.ATT_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objAttendence.ATT_CREATED_DATE = DateTime.Now;
objAttendence.STU_ID = Convert.ToInt32(studentID);
objAttendence.ATT_STATUS = chkIsPresent.Checked;
if (objAttendence.ATT_ID == 0)
{
entities.tblAttendences.Add(objAttendence);
}
else
{
objAttendence.ATT_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objAttendence.ATT_MODIFIED_DATE = DateTime.Now;
entities.Entry(objAttendence).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objAttendence = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("AttendanceList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
if (studentID == 0)
{
divErrorMsg.InnerHtml = "";
divErrorMsg.InnerText = "Student does not exist with this number.";
}
else
{
divErrorMsg.InnerHtml = "";
divErrorMsg.InnerText = "Attendance for this student with class time and date already exist.";
}
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}
