public void UpdateStudent(BCStudent student)
{
using (var dbContext = new AttendanceSystemDB(_connectionString))
{
dbContext.Entry <BCStudent>(student).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public int AddStudent(BCStudent student)
{
using (var dbContext = new AttendanceSystemDB(_connectionString))
{
dbContext.BCStudents.Add(student);
dbContext.SaveChanges();
return(student.BCStudentId);
}
}
public void EditStudent(BCStudent student, List <BCStudentClass> classId)
{
classId = classId.Where(c => c.BCClassId != 0).ToList();
_adminRepo.UpdateStudent(student);
_adminRepo.MarkStudentClassesInactive(student.BCStudentId);
foreach (var c in classId)
{
_adminRepo.UpdateStudentClass(student.BCStudentId, c);
}
}
public void AddStudent(BCStudent student, List <BCStudentClass> classIds)
{
classIds = classIds.Where(c => c.BCClassId != 0).ToList();
var studentId = _adminRepo.AddStudent(student);
foreach (var c in classIds)
{
c.BCStudentId = studentId;
c.IsActive = true;
_adminRepo.AddStudentClass(c);
}
}
public void GetData(int classId, string Action, Int32 userId, Int32 userRoleId)
{
DataTable dt = new DataTable();
BCStudent student = new BCStudent();
dt = student.GetScoreBoard(classId, Action, userId, userRoleId);
if (dt.Rows.Count > 0)
{
dlScoreBoard.DataSource = dt;
dlScoreBoard.DataBind();
}
else
{
dlScoreBoard.DataSource = null;
dlScoreBoard.DataBind();
}
}
public virtual BCStudent GetAssociatedStudent()
{
BCStudent result = new BCStudent();
result.Id = IdStudent;
result.loadData();
return result;
}
public virtual void ComputeDynamicFields(PaymentAdvice parent)
{
ApasConfigurationManager cfg = new ApasConfigurationManager();
decimal deviationTotal = 0;
PayableFee=Amount;
foreach (FeeDeviationPayableFee objFD in FeeDeviations.Values)
{
//objFD returns exact amount. round it before adding to total
deviationTotal += MyUtils.FormatCurrencyWithRounding(objFD.ComputeNetDeviation(0));//dummy zero, type is "fixed"
}
PayableFee += deviationTotal;
BCStudent student = new BCStudent();
student.Id = parent.IdStudent ;
student.loadData();
PaymentAdviceText = cfg.getConfigValue("PaymentAdviceTemplateOFee");
//get Config paymentadvice Text template and fill PaymentAdviceText
PaymentAdviceText =
PaymentAdviceText
.Replace("[Name]", student.FullName)
.Replace("[Amount]", String.Format("{0:C}", Amount))
.Replace("[Payable Fee]", String.Format("{0:C}", PayableFee))
.Replace("[Fee Deviation Total]", String.Format("{0:C}", deviationTotal))
.Replace("[Private Remarks]", PrivateRemark)
.Replace("[Public Remarks]", PublicRemark)
.Replace("[Month]", parent.GetParentPAList().Month.ToString("MMMM"))
.Replace("[Year]", parent.GetParentPAList().Month.ToString("yyyy"))
.Replace("[Type]", OtherFeeType.Name);
}
public ActionResult UpdateStudent(BCStudent student, List <BCStudentClass> classId)
{
_adminService.EditStudent(student, classId);
return(Redirect("/admin/students"));
}
static void Main(string[] args)
{
try
{
// variable declaration
BCStudent objStudent = new BCStudent();
int studentId = 0;
int UserRoleId = 5;
int stagePlanId = 0;
double stageDistance = 0;
double distCovered = 0;
Int32 UserId = 0;
DataTable studInfo = null;
string UserName = string.Empty;
Int32 schoolId = 0;
Int32 classId = 0;
Int32 cityId = 0;
// end variable declaration
// Get student info
StringBuilder sqlString = new StringBuilder();
sqlString.Append("select * from LoginDtls where LoginName='");
sqlString.Append(args[0]);
sqlString.Append("' and cast(Password as varbinary(20))=cast('");
sqlString.Append(args[1]);
sqlString.Append("' as varbinary(50)) and IsActive=1");
var login = DataAccessLayer.ReturnDataTable(sqlString.ToString());
if (login != null)
{
UserRoleId = Convert.ToInt32(login.Rows[0]["RoleId"]);
UserId = Convert.ToInt32(login.Rows[0]["LoginId"]);
UserName = Convert.ToString(login.Rows[0]["LoginName"]);
if (UserRoleId == 5)
{
sqlString = new StringBuilder();
sqlString.Append("Select * FROM StudentMaster Where LoginId = ");
sqlString.Append(UserId);
var student = DataAccessLayer.ReturnDataTable(sqlString.ToString());
if (student != null && student.Rows.Count > 0)
{
schoolId = Convert.ToInt32(student.Rows[0]["SchoolId"]);
classId = Convert.ToInt32(student.Rows[0]["ClassId"]);
cityId = Convert.ToInt32(student.Rows[0]["CityId"]);
studentId = Convert.ToInt32(student.Rows[0]["StudentId"]);
}
}
studInfo = objStudent.GetMyProfileInfo(studentId);
schoolId = Convert.ToInt32(studInfo.Rows[0]["SchoolId"]);
classId = Convert.ToInt32(studInfo.Rows[0]["ClassId"]);
DataSet _dtStage = objStudent.GetCurrentStageInfo((studentId > 0 ? studentId : UserId),
UserRoleId, classId);
if (_dtStage.Tables[0].Rows.Count > 0)
{
stagePlanId = Convert.ToInt32(_dtStage.Tables[0].Rows[0]["StagePlanId"]);
stageDistance = Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance"]);
distCovered = double.Parse(_dtStage.Tables[0].Rows[0]["Distance_Covered"].ToString(), System.Globalization.CultureInfo.InvariantCulture);
//Convert.ToDouble(_dtStage.Tables[0].Rows[0]["Distance_Covered"]);
}
int res = objStudent.StudentsDeleteLastUpload(
UserRoleId, UserId,
0, studentId,
stagePlanId, stageDistance, distCovered, classId, 1);
}
else
{
Console.WriteLine("Incorrect Username or Password");
}
}
catch (Exception ex)
{
Console.WriteLine("No last file found or internal server error occured, following are details : \n\n" + ex.Message);
}
}
public virtual void ComputeDynamicFields(PaymentAdvice parent)
{
ApasConfigurationManager cfg=new ApasConfigurationManager();
decimal deviationTotal=0;
PayableCredit=NextMonthCredit -Credit +CreditAdjustment;
PayableFee=PerLessonFee*PayableCredit;
foreach(FeeDeviationPayableFee objFD in FeeDeviations.Values)
{
//objFD returns exact amount. round it before adding to total
deviationTotal += MyUtils.FormatCurrencyWithRounding(objFD.ComputeNetDeviation(PayableFee));
}
PayableFee += deviationTotal;
PayableFee = MyUtils.FormatCurrencyWithRounding(PayableFee);
//get Config paymentadvice Text template and fill PaymentAdviceText
PaymentAdviceText = cfg.getConfigValue("PaymentAdviceTemplateCFee");
BCStudent student = new BCStudent();
student.Id = parent.IdStudent;
student.loadData();
ApasRegular regClass = GetAssociatedClass();
PaymentAdviceText =
PaymentAdviceText
.Replace("[Name]", student.FullName)
.Replace("[Subject]", regClass.GetSubject().name)
.Replace("[Level]", regClass.getLevel().Name)
.Replace("[Time Start]", regClass.TimeStart.ToString("hh:mm tt"))
.Replace("[Time End]", regClass.TimeEnd.ToString("hh:mm tt"))
.Replace("[Day]", regClass.Day)
.Replace("[Absence]", Convert.ToString(Absence))
.Replace("[Prorate]", Convert.ToString(Prorate))
.Replace("[Makeup]", Convert.ToString(Makeup))
.Replace("[Forfeit]", Convert.ToString(Forfeit))
.Replace("[Credit]", Convert.ToString(Credit))
.Replace("[Payable Credit]", Convert.ToString(PayableCredit))
.Replace("[Next Mth Lessons]", Convert.ToString(NextMonthCredit))
.Replace("[Credit Adjustment]", Convert.ToString(CreditAdjustment))
.Replace("[Per Lesson Fee]", String.Format("{0:C}", PerLessonFee))
.Replace("[Fee Deviation Total]", String.Format("{0:C}", deviationTotal))
.Replace("[Payable Fee]", String.Format("{0:C}", PayableFee))
.Replace("[Private Remarks]", PrivateRemark)
.Replace("[Public Remarks]", PublicRemark)
.Replace("[Month]", parent.GetParentPAList().Month.ToString("MMMM"))
.Replace("[Year]", parent.GetParentPAList().Month.ToString("yyyy"));
}
protected void rptBreakdown_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
int clsId = ((BCClassSchedule)(e.Item.DataItem)).Id;
string temp;
BCRegular objRegular = new BCRegular();
objRegular.Id = clsId;
try
{
objRegular.LoadData();
}
catch (WebServiceException ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, "GenericPolicy");
if (rethrow) throw;
return;
}
//class description label
//S4 P Chem Sun 1300 - 1430 (sample)
Label lblClassDescription = (Label)(e.Item.FindControl("lblClassDescription"));
temp = "{0} {1} {2} {3} - {4}";
lblClassDescription.Text =
String.Format(temp, objRegular.GetSubject().name, objRegular.getLevel().Name,
objRegular.Day, objRegular.TimeStart.ToString("hh:mm tt"), objRegular.TimeEnd.ToString("hh:mm tt")
);
GridView grdPaymentHistory = (GridView)(e.Item.FindControl("grdPaymentHistory"));
grdPaymentHistory.RowDataBound +=
new GridViewRowEventHandler(grdPaymentHistory_RowDataBound);
grdPaymentHistory.RowCreated +=
new GridViewRowEventHandler(grdPaymentHistory_RowCreated);
BCPayment[] aryBCPayment = BCPayment.getPaymentByStudentClass(
Convert.ToInt32(hdnStudentId.Value),
clsId);
grdPaymentHistory.DataSource = aryBCPayment;
grdPaymentHistory.DataBind();
Label lblEmptyPH = (Label)(e.Item.FindControl("lblEmptyPaymentHistory"));
lblEmptyPH.Visible = (aryBCPayment == null || aryBCPayment.Length == 0);
GridView grdAttendanceHistory = (GridView)(e.Item.FindControl("grdAttendanceHistory"));
grdAttendanceHistory.RowDataBound +=
new GridViewRowEventHandler(grdAttendanceHistory_RowDataBound);
grdAttendanceHistory.RowCreated +=
new GridViewRowEventHandler(grdAttendanceHistory_RowCreated);
wsvAttendanceLn.AttendanceLn dbAttln =
new wsvAttendanceLn.AttendanceLn();
wsvAttendanceLn.CAttendanceLn[] aryAttln =
dbAttln.GetAttendanceByStudentClass(
Convert.ToInt32(hdnStudentId.Value),
clsId);
grdAttendanceHistory.DataSource = aryAttln;
grdAttendanceHistory.DataBind();
Label lblEmptyAH = (Label)(e.Item.FindControl("lblEmptyAttendanceHistory"));
lblEmptyAH.Visible = (aryAttln == null || aryAttln.Length == 0);
GridView grdAbsenceSummary = (GridView)(e.Item.FindControl("grdAbsenceSummary"));
grdAbsenceSummary.RowDataBound +=
new GridViewRowEventHandler(grdAbsenceSummary_RowDataBound);
grdAbsenceSummary.RowCreated +=
new GridViewRowEventHandler(grdAbsenceSummary_RowCreated);
BCStudent objStud = new BCStudent();
objStud.Id = Convert.ToInt32(hdnStudentId.Value);
DataSet dsReport = objStud.GenerateAttendanceSummaryReport(clsId, 2);
grdAbsenceSummary.DataSource = dsReport;
grdAbsenceSummary.DataBind();
Label lblEmptyAS = (Label)(e.Item.FindControl("lblEmptyAbsenceSummary"));
lblEmptyAS.Visible =
(dsReport == null ||
dsReport.Tables.Count == 0 ||
dsReport.Tables[0].Rows.Count == 0);
}
protected void Page_Load(object sender, EventArgs e)
{
/**
* Access Control code
* */
//first time loading only
if (Page.IsPostBack)
{
return;
}
//Mandatory query string
if (String.IsNullOrEmpty(Request.QueryString["StudentID"]))
{
return;
}
//load student data
hdnStudentId.Value = Request.QueryString["StudentID"];
BCStudent objStudent = new BCStudent();
try
{
objStudent.Id = Convert.ToInt32(hdnStudentId.Value);
objStudent.loadData();
}
catch (WebServiceException ex)
{
/* error logging here */
Response.Redirect("ManageStudentSearch.aspx");
bool rethrow = ExceptionPolicy.HandleException(ex, "GenericPolicy");
if (rethrow) throw;
return;
}
//populate headers
lblNRIC.Text = objStudent.NRIC;
lblStudentName.Text = objStudent.FullName;
lblDateofReport.Text = DateTime.Today.ToString("dd MMMM yyyy");
//populate Summary gridview: grdSummary
int[] clsIDs = retrieveClassIDsFromQueryString();
List<BCClassSchedule> aryCls = new List<BCClassSchedule>();
if (clsIDs != null)
{
foreach (int clsID in clsIDs)
{
BCClassSchedule objCls = new BCClassSchedule();
objCls.Id = clsID;
if (objStudent.hasThisClassSchedule(objCls,true))
{
objCls.LoadData();
aryCls.Add(objCls);
}
}
}
grdSummary.DataSource = aryCls; //bind grdSummary
grdSummary.DataBind();
rptBreakdown.DataSource = aryCls; //bind detail breakdown
rptBreakdown.DataBind();
//populate DepositFee gridview
wsvDepositFee.DepositFee dbDF = new wsvDepositFee.DepositFee();
wsvDepositFee.CDepositFee[] aryDF =
dbDF.GetDepositFeeByStudent(Convert.ToInt32(hdnStudentId.Value), wsvDepositFeePart.DFOption.OnlyUnDeleted);
grdDesposits.DataSource = aryDF;
grdDesposits.DataBind();
}
public ApasStudentView ConvertStudent(BCStudent input)
{
ApasStudentView output = new ApasStudentView();
output.BirthDate = input.BirthDate;
output.ContactHome = input.ContactHome;
output.ContactMobile = input.ContactMobile;
try
{
output.Country = input.GetCountry().Name;
}
catch (WebServiceException ex)
{
output.Country = "";
bool rethrow = ExceptionPolicy.HandleException(ex, "GenericPolicy");
if (rethrow) throw;
}
output.DateTerminated = input.DateTerminated;
output.Email = input.Email;
output.EnrolmentDate = input.EnrolmentDate;
output.Friendster = input.Friendster;
output.FullName = input.FullName;
output.Gender = input.Gender;
output.Guardian =
ConvertGuardian(input.GetGuardian());
output.Id = input.Id;
output.IsActive = input.IsActive;
output.MailingAddress = input.MailingAddress;
output.NRIC = input.MailingAddress;
output.PersonalURL = input.PersonalURL;
output.PostalCode = input.PostalCode;
output.Remark = input.Remark;
try
{
output.School = input.GetSchool().Name;
}
catch (WebServiceException ex)
{
output.School = "";
bool rethrow = ExceptionPolicy.HandleException(ex, "GenericPolicy");
if (rethrow) throw;
}
return output;
}
