public static int Add(StudentAttendanceRecords studentAttendanceRecords)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procStudentAttendanceRecords_AddStudentAttendanceRecords";
db.cmd.Parameters.AddWithValue("@Date", studentAttendanceRecords.Date);
db.cmd.Parameters.AddWithValue("@Student_ID", studentAttendanceRecords.StudentsId);
db.cmd.Parameters.AddWithValue("@StudentAttendanceStatus_ID", studentAttendanceRecords.StudentAttendanceStatusesId);
db.cmd.Parameters.Add("@id", SqlDbType.Int);
db.cmd.Parameters["@id"].Direction = ParameterDirection.Output;
db.con.Open();
db.cmd.ExecuteNonQuery();
retvalue = Convert.ToInt32(db.cmd.Parameters["@id"].Value);
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
return(retvalue);
}
public static void Update(int id, StudentAttendanceRecords stdattrecord)
{
try
{
db.cmd.CommandText = @"UPDATE [dbo].[tblStudentAttendanceRecords]
SET [Date] =@dte
,[Student_ID] = @stdid
,[StudentAttendanceStatus_ID] = @stdstatid
WHERE Id=id";
db.cmd.Parameters.AddWithValue("@dte", stdattrecord.Date);
db.cmd.Parameters.AddWithValue("@stdid", stdattrecord.StudentsId);
db.cmd.Parameters.AddWithValue("@stdstatid", stdattrecord.StudentAttendanceStatusesId);
db.cmd.Parameters.AddWithValue("@id", id);
db.con.Open();
db.cmd.ExecuteNonQuery();
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.CloseDb(db.con, db.cmd);
}
}
public static int Add(StudentAttendanceRecords studentAttendanceRecords, StudentAttendanceStatuses studentAttendanceStatuses)
{
int retvalue = -1;
studentAttendanceRecords.StudentAttendanceStatusesId = StudentAttendanceStatuses.Add(studentAttendanceStatuses);
retvalue = StudentAttendanceRecords.Add(studentAttendanceRecords);
return(retvalue);
}
private static List <StudentAttendanceRecords> _GetStudentAttendanceRecords()
{
List <StudentAttendanceRecords> StudentAttendanceRecords = new List <StudentAttendanceRecords>();
try
{
Command = "select * from tblStudentAttendanceRecords";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
StudentAttendanceRecords singleStudentAttendanceRecords = new StudentAttendanceRecords();
singleStudentAttendanceRecords.Id = (int)rdr[0];
singleStudentAttendanceRecords.Date = rdr[1].ToString();
singleStudentAttendanceRecords.StudentsId = (int)rdr[2];
singleStudentAttendanceRecords.StudentAttendanceStatusesId = (int)rdr[3];
var student = new Students();
singleStudentAttendanceRecords.Students = Students.ListOfStudents.SingleOrDefault(s => s.Id == singleStudentAttendanceRecords.StudentsId);
var Sas = new StudentAttendanceStatuses();
singleStudentAttendanceRecords.StudentAttendanceStatuses = Sas.ListOfStudentAttendanceStatuses.SingleOrDefault(s => s.Id == singleStudentAttendanceRecords.StudentAttendanceStatusesId);
StudentAttendanceRecords.Add(singleStudentAttendanceRecords);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(StudentAttendanceRecords);
}
static void Main(string[] args)
{
//SalaryRecords s = new SalaryRecords();
//s.DateTime = DateTime.Now;
//s.Paid = true;
//s.PayableAmount = 1000;
//s.EmployeesId = 1;
//s.AddedByEmployesId = 2;
//s.Employees = Employees.ListOfEmployees[0];
//s.AddedByEmployees = Employees.ListOfEmployees[1];
//SalaryRecords.Add(s);
#region OBJECTS
//Classes classes = new Classes();
//ClassSchedules classschedules = new ClassSchedules();
//ClassTimings classtimings = new ClassTimings();
//Designations designations = new Designations();
//DocumentUrls documenturls = new DocumentUrls();
//EmployeeAttendanceRecords employeeattandancerecord = new EmployeeAttendanceRecords();
//EmployeeAttendanceStatuses employeeattendancestatuses = new EmployeeAttendanceStatuses();
//EmployeeDocuments employeedocuments = new EmployeeDocuments();
//EmployeeFines employeefines = new EmployeeFines();
//EmployeeQualifications employeequalification = new EmployeeQualifications();
//Employees empoyees = new Employees();
//EmployeeSkills employeeskills = new EmployeeSkills();
//EmployeeTypes employeetypes = new EmployeeTypes();
//Exams exams = new Exams();
//ExamTypes examtypes = new ExamTypes();
//ExpenseRecords expenserecords = new ExpenseRecords();
//ExpenseTypes expensetypes = new ExpenseTypes();
//FeeRecords feerecords = new FeeRecords();
//FeeSchedules feeschedules = new FeeSchedules();
//FeeTypes feetypes = new FeeTypes();
//FineStatuses finestatuses = new FineStatuses();
//Genders genders = new Genders();
//Grades grades = new Grades();
//LoginDetails logindetails = new LoginDetails();
//Parents parents = new Parents();
//Persons persons = new Persons();
//Qualifications qualifications = new Qualifications();
//SalaryRecords salaryrecords = new SalaryRecords();
//Skills skills = new Skills();
//StudentAttendanceRecords studentattendancerecords = new StudentAttendanceRecords();
//StudentAttendanceStatuses studentattendancestatuses = new StudentAttendanceStatuses();
//StudentDocuments studentdocuments = new StudentDocuments();
//StudentFines studentfines = new StudentFines();
//Students students = new Students();
//Subjects subjects = new Subjects();
//Teachers teacher = new Teachers();
#endregion
#region DELTED
//classes.Delete(1);
//classschedules.Delete(1);
//classtimings.Delete(1);
//designations.Delete(1);
//documenturls.Delete(1);
//employeeattandancerecord.Delete(1);
//employeeattendancestatuses.Delete(1);
//employeedocuments.Delete(1);
//employeefines.Delete(1);
//employeequalification.Delete(1);
//empoyees.Delete(1);
//employeeskills.Delete(1);
//employeetypes.Delete(1);
//exams.Delete(1);
//examtypes.Delete(1);
//expenserecords.Delete(1);
//expensetypes.Delete(1);
//feerecords.Delete(1);
//feeschedules.Delete(1);
//feetypes.Delete(1);
//finestatuses.Delete(1);
//genders.Delete(1);
//grades.Delete(1);
////logindetails.Delete(1);
//parents.Delete(1);
////persons.PersonDelete(1);
//qualifications.Delete(1);
//salaryrecords.Delete(1);
//skills.Delete(1);
//studentattendancerecords.Delete(1);
//studentattendancestatuses.Delete(1);
//studentdocuments.Delete(1);
//studentfines.Delete(1);
//students.Delete(1);
//subjects.Delete(1);
//teacher.Delete(1);
#endregion
#region GENDER
//Genders addgender = new Genders { GenderName = "Maleee" };
//Genders.Add(addgender);
//Genders.ListOfGenders.ForEach(Console.WriteLine);
//addgender = Genders.ListOfGenders[2];
//addgender.GenderName = "testtt";
//Genders.Update(addgender.Id, addgender);
//Genders.ListOfGenders.ForEach(Console.WriteLine);
#endregion
#region FineStatuses
//FineStatuses testfinestatuses = new FineStatuses();
//testfinestatuses.FineStatusName = "testfine";
//FineStatuses.Add(testfinestatuses);
//FineStatuses.ListOfFineStatuses.ForEach(Console.WriteLine);
// testfinestatuses = FineStatuses.ListOfFineStatuses[0];
//testfinestatuses.FineStatusName = "testttt";
//FineStatuses.Update(testfinestatuses.Id,testfinestatuses);
//FineStatuses.ListOfFineStatuses.ForEach(Console.WriteLine);
#endregion
#region SKILLS
//var skills = new Skills();
//skills.SkillName = "C#";
//Skills.Add(skills);
//Skills.ListOfSkills.ForEach(Console.WriteLine);
//skills = Skills.ListOfSkills[0];
//skills.SkillName = "C##";
//Skills.Update(skills.Id, skills);
//Skills.ListOfSkills.ForEach(Console.WriteLine);
#endregion
#region QUALIFICATIONS
//var qualif = new Qualifications();
//qualif.QualificationName = "postergra";
//Qualifications.Add(qualif);
//Qualifications.ListOfQualifications.ForEach(Console.WriteLine);
//qualif = Qualifications.ListOfQualifications[0];
//qualif.QualificationName = "posterrrr";
//Qualifications.Update(qualif.Id,qualif);
//Qualifications.ListOfQualifications.ForEach(Console.WriteLine);
#endregion
#region CLASSTIMINGS
//var clstime = new ClassTimings ();
//clstime.Name = "testtimee";
//clstime.EndTime = DateTime.Now;
//clstime.StartTime = DateTime.Now;
//ClassTimings.Add(clstime);
//ClassTimings.ListOfClassTimings.ForEach(Console.WriteLine);
//clstime = ClassTimings.ListOfClassTimings[0];
//clstime.Name = "testtimexxx";
//clstime.EndTime = DateTime.Now;
//clstime.StartTime = DateTime.Now;
//ClassTimings.Update(clstime.Id,clstime);
//ClassTimings.ListOfClassTimings.ForEach(Console.WriteLine);
#endregion
#region CLASSSCHEDULES
#endregion
var at = StudentAttendanceRecords.ListOfStudentAttendanceRecords[0];
Console.WriteLine(at.ToString());
at.StudentAttendanceStatusesId = 2;
StudentAttendanceRecords.Update(at.Id, at);
at = StudentAttendanceRecords.ListOfStudentAttendanceRecords[0];
Console.WriteLine(at.ToString());
//var st = Students.ListOfStudents[0];
//Console.WriteLine(st.ToString());
//st.LoginDetails.Username = "******";
//Students.Update(st.Id,st);
//st = Students.ListOfStudents[0];
//Console.WriteLine(st.ToString());
#region PARENTS
//var prt = Parents.ListOfParents[0];
//Console.WriteLine(prt.ToString());
//prt.FirstName = "talha";
//Parents.Update(prt.Id, prt);
//Console.WriteLine(prt.ToString());
//Console.Read();
//Parents addparent = new Parents
//{
// FirstName = "first",
// LastName = "last",
// DateOfBirth = "1998-12-03",
// CNIC = "cnic123",
// ImageUrlPath = "path/image",
// Phone1 = "phone1",
// Phone2 = "phone2",
// GendersId = 2
//};
//addparent.LoginDetails.Username = "******";
//addparent.LoginDetails.Password = "******";
//addparent.LoginDetails.AllowAccess = true;
//Parents.Update(3, addparent);
//addparent.Add(addparent);
// var updateparents = parents.ListOfParents.SingleOrDefault(p => p.Id == 2);
// Console.WriteLine($@"{updateparents.Id},
// {updateparents.LoginDetailsId}, {updateparents.LoginDetails.Id},
// {updateparents.PersonsId}, {updateparents.PersonId}");
// updateparents.FirstName = "update first name";
// updateparents.Update(updateparents.Id, updateparents);
#endregion
#region CLASSES
//Grades addclassgrade = new Grades();
//Classes addclasses = new Classes();
//addclassgrade.GradeName = "One1";
//addclasses.ClassesName = "One-A1";
//Classes.Add(addclasses, addclassgrade);
//Classes.ListOfClasses.ForEach(Console.WriteLine);
#endregion
#region FeeTypes
//var testfeetypes = new FeeTypes();
//testfeetypes.FeeTypeName = "testttttfeetype";
//FeeTypes.Add(testfeetypes);
//FeeTypes.ListOfFeeTypes.ForEach(Console.WriteLine);
//testfeetypes = FeeTypes.ListOfFeeTypes[0];
//testfeetypes.FeeTypeName = "testnamechagedddd";
//FeeTypes.Update(testfeetypes.Id, testfeetypes);
//FeeTypes.ListOfFeeTypes.ForEach(Console.WriteLine);
#endregion
#region EMPLOYEES
//EmployeeTypes addemployeEmployeetypes = new EmployeeTypes();
//Designations addemployeeDesignation = new Designations();
//Employees addemployees = new Employees
//{
// FirstName = "empFirst",
// LastName = "empLast",
// DateOfBirth = "1998-2-12",
// CNIC = "empcinc",
// ImageUrlPath = "emp/img/path",
// Phone1 = "ph1",
// Phone2 = "ph2",
// GendersId = 2,
// RegistrationID = "regId",
// Salary = 10000,
// IdentityCardUrl = "emp/identity/url",
// PostalAddress = "postal",
// ResidentialAddress = "residential",
// AggrementUrl = "agrrement/url",
//};
//addemployees.LoginDetails.Username = "******";
//addemployees.LoginDetails.Password = "******";
//addemployees.LoginDetails.AllowAccess = true;
//addemployeEmployeetypes.EmployeeTypeName = "empTestType";
//addemployeeDesignation.DesignationName = "empTestDesignation";
//addemployees.Add(addemployees, addemployeEmployeetypes, addemployeeDesignation);
#endregion
#region STUDENTS
//Students addstudents = new Students
//{
// FirstName="stdFirst",
// LastName="stdlast",
// DateOfBirth="2000-3-3",
// CNIC="stdBayform",
// ImageUrlPath="std/img/path",
// Phone1="ph1",
// Phone2="ph2",
// GendersId=2,
// RegistrationId="stdRegId",
// DiscountPercentage=10,
// IdentityCardUrl="std/idcar/url",
// PostalAddress="stdpostal",
// ResidentialAddress="stdRes",
// AdmissionCard="std/admcard/url",
//};
//addstudents.LoginDetails.Username = "******";
//addstudents.LoginDetails.Password = "******";
//addstudents.LoginDetails.AllowAccess = true;
//Classes addstudentsClasses = new Classes
//{
// ClassesName = "addstdClassname",
// GradesId = 1
//};
//Parents addstudentsParesnts = new Parents
//{
// FirstName = "stdFirst",
// LastName = "stdlast",
// DateOfBirth = "2000-3-3",
// CNIC = "stdBayform",
// ImageUrlPath = "std/img/path",
// Phone1 = "ph1",
// Phone2 = "ph2",
// GendersId = 2,
//};
//addstudentsParesnts.LoginDetails.Username = "******";
//addstudentsParesnts.LoginDetails.Password = "******";
//addstudentsParesnts.LoginDetails.AllowAccess = true;
//addstudents.Add(addstudents, addstudentsParesnts, addstudentsClasses);
#endregion
#region Grades
//var testgrades = new Grades();
//testgrades.GradeName = "testStaticGrade";
//Grades.Add(testgrades);
//Grades.ListOfGrades.ForEach(Console.WriteLine);
#endregion
//var a = feerecords.ListOfFeeRecords;
//a.ForEach(Console.WriteLine);
//(st.ListOfStudents).ForEach(Console.WriteLine);
// Console.Read();
}
