public frmBatchDetails(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; Query = "select BatchId,BatchName,BatchSatus from tblBatch order by BatchSatus desc,BatchId desc"; Add_Details_to_Datagridview(); }
public frmSubjects(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; Query = "select SubjectId,subjectName,SubjectStatus from tblSubjects order by SubjectStatus desc,SubjectId desc"; Add_Details_to_Datagridview(); }
// 0-barcode 1-contact no 2-email public frmStudentsUpdates(frmMainPage MainPage, int StudentId, bool EditEnterSave, string editSession, bool new_student_mode) { InitializeComponent(); MainScreen = MainPage; _selectedStudentId = StudentId; _alreadyRegisterdSubjects = new List <string>(); _alreadyRegisterdBatchess = new List <string>(); AddBatches(); AddRegisteredSubjects(); this.editSession = editSession; this.EditEnterSave = EditEnterSave; this.new_student_mode = new_student_mode; if (new_student_mode == true) { button2.Text = @"Save"; } else { button2.Text = @"Update"; AddDetails(); } }
public frmAccounts(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; batch_id = new List <int>(); DgvQuery = "select A.AccountId,A.AccountDescription,A.PaymentMtd,A.Amount,A.Income,A.PaymentDate,A.Status,SUBSTRING(C.StafFirstName, 1, 1)+'.'+C.StafLastName from tblAccounts A inner join tblUser B on A.CreatedBy=B.UserId inner join tblStaffDetails C on C.StaffId=B.StaffId order by A.Status desc,A.AccountId desc"; Add_Details_to_Datagridview(DgvQuery); }
public frmBatches(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; batch_id = new List <int>(); Add_Batches_to_Combobox("select BatchId, BatchName from tblBatch where BatchSatus='True'"); DgvQuery = " select B.ClassId,(select SubjectName from tblSubjects where SubjectId = B.SubjectId),A.BatchName,(SELECT DATENAME(DW, CAST(B.ClassDay AS INT))),B.StartTime,B.EndTime,(select COUNT(C.studentid) from tblStudentBatchDetails C where C.batchid = A.BatchId and C.current_status = 'True' ),B.AutoGenerate,B.AutoAttendance,B.BatchId,B.SubjectId,B.TimeStatus from tblBatch A inner join tblClassTimes B on A.BatchId = B.BatchId where A.BatchSatus = 'True' order by TimeStatus desc,ClassId desc"; Add_Details_to_Datagridview(DgvQuery); }
public frmAddAccounts(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; subject_id = new List <int>(); batch_id = new List <int>(); comboBox1.SelectedIndex = 0; comboBox2.SelectedIndex = 0; txtAmount.Focus(); }
public frmExams(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; batch_id = new List <int>(); Add_Subjects_to_Combobox("select SubjectId, SubjectName from tblSubjects where SubjectStatus='True';"); DgvQuery = " select A.ExamId,(select SubjectName from tblSubjects where SubjectId = A.SubjectId),A.ExamPart,B.BatchName,A.ExamDay,A.StartTime,A.Duration,A.ExamStatus,A.BatchId,A.SubjectId,A.Status from tblExamDetails A inner join tblBatch B on A.BatchId=B.BatchId where B.BatchSatus ='True' order by A.Status desc,A.ExamId desc"; Add_Details_to_Datagridview(DgvQuery); }
public frmSubjectFees(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; subject_id = new List <int>(); batch_id = new List <int>(); AddDataToComboBox("select BatchId,BatchName from tblBatch where BatchSatus='true'", comboBox1, batch_id); AddDataToComboBox("select SubjectId,SubjectName from tblSubjects where SubjectStatus='true'", comboBox2, subject_id); Query = "select A.SubjectPaymentId,B.SubjectName,C.BatchName,A.Amount,A.AmountStatus,A.SubjectId,A.BatchId from tblSubjectAmount A inner join tblSubjects B on A.SubjectId=B.SubjectId inner join tblBatch C on A.BatchId=C.BatchId where B.SubjectStatus='True' and C.BatchSatus='True' order by A.AmountStatus desc,A.SubjectPaymentId desc"; Add_Details_to_Datagridview(); }
public frmStudents(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; batch_id = new List <int>(); Add_Batches_to_Combobox("select BatchId, BatchName from tblBatch where BatchSatus='True'"); // DgvQuery= "select StudentId,StudentFirstName,StudentLastName,StudentAddress,CONVERT(date, StudentJoinedDate),StudentStatus from tblStudentDetails order by StudentStatus desc"; setDgvQuery(); Add_Details_to_Datagridview(DgvQuery); }
public frmStudentView(frmMainPage MainPage, int StudentId) { InitializeComponent(); MainScreen = MainPage; selectedStudentId = StudentId; batch_ids = new List <int>(); AddDataToDetailsPanel(); AddRegisteredSubjects(); //AddPayments(); }
public frmMessageBox(String Type, String Title, String Message, Boolean Yes, frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; label2.Text = Title; label1.Text = Message; if (Yes == true) { button1.Visible = true; button1.Enabled = true; button2.Text = "No"; } else { button1.Visible = false; button1.Enabled = false; button2.Text = "OK"; } if (Type == "error") { panel2.BackColor = Color.Red; label2.BackColor = Color.Red; pictureBox1.BackgroundImage = imageList1.Images[3]; } else if (Type == "alert") { panel2.BackColor = Color.RoyalBlue; label2.BackColor = Color.RoyalBlue; pictureBox1.BackgroundImage = imageList1.Images[0]; } else if (Type == "question") { panel2.BackColor = Color.RoyalBlue; label2.BackColor = Color.RoyalBlue; pictureBox1.BackgroundImage = imageList1.Images[1]; } else { panel2.BackColor = Color.RoyalBlue; label2.BackColor = Color.RoyalBlue; pictureBox1.BackgroundImage = imageList1.Images[2]; } if (Message.Length >= 66) { label1.Font = new Font(label1.Font.Name, 10); } else { label1.Font = new Font(label1.Font.Name, 11); } }
public frmStudentSubjectRegister(frmMainPage MainPage, int StudentId, string name, String Batch, List <int> Batchid) { InitializeComponent(); MainScreen = MainPage; selectedStudentId = StudentId; //batch_ids = new List<int>(); alreadyRegisterdIds = new List <string>(); label4.Text = @"Name : " + name; batch_ids = Batchid; label1.Text = Batch; AddRegisteredSubjects(); Calculate_Total(true); }
public frmAddBatchTime(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; // if(SelectedClassId>-1) { button4.Text = "Update"; } // else { button4.Text = "Add"; } subject_id = new List <int>(); batch_id = new List <int>(); AddDataToComboBox("select SubjectId,SubjectName from tblSubjects where SubjectStatus='true'", comboBox1, subject_id); AddDataToComboBox("select BatchId,BatchName from tblBatch where BatchSatus='true'", comboBox2, batch_id); addWeeksDays(comboBox3); txtEnd.Focus(); }
public frmHome(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; }
// private String Query = ""; public frmReports(frmMainPage MainPage) { InitializeComponent(); MainScreen = MainPage; }