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;
}
