using System;
using System.Data;
using System.Windows.Forms;
using Traffic;

namespace Database3
{
    public partial class frmEdit : Form
    {

        private frmSearch forminstance;
        public frmEdit(frmSearch there)
        {
            InitializeComponent();
            forminstance = there;
        }

        private void Form_Closing(object sender, FormClosingEventArgs e)
        {

            forminstance.btnSearch_Click(sender, e);

        }
        
        private void frmEdit_Load(object sender, EventArgs e)
        {
            // txtStuID.Text = frmSearch.myID;

            try
            {

            
                DataSet ds = new DataSet();
                StudentDataTier stuDT = new StudentDataTier();

                ds = stuDT.GetStudents(frmSearch.myID.ToString());

                if (ds.Tables[0].Rows.Count > 0)
                {

                    txtStuID.Text = ds.Tables[0].Rows[0]["student_id"].ToString();
                    txtStuID.Enabled = false;
                    txtfname.Text = ds.Tables[0].Rows[0]["fname"].ToString();
                    txtlname.Text = ds.Tables[0].Rows[0]["lname"].ToString();

                }
            }
            catch (Exception exception)
            {
                // Do Nothing
            }

        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            string studid = "";
            string firstname = "";
            string lastname = "";
            DateTime dob = new DateTime(1/1/1111);
            decimal acctbal = 0;
            string gender = "";
            decimal credits = 0;
            string state = "";
            
            try
            {
                DataSet ds = new DataSet();
                StudentDataTier stuDT = new StudentDataTier();

                studid = txtStuID.Text.Trim();
                firstname = txtfname.Text.Trim();
                lastname = txtlname.Text.Trim();
                try
                {
                    dob = DateTime.Parse(txtDOB.Text.Trim());

                }
                catch (Exception exception)
                {
                }
                
                try
                {
                acctbal = decimal.Parse(txtSalary.Text.Trim());

                }
                catch (Exception exception)
                {
                }
                
                
                
                gender = cboGender.Text.Trim();
                if (gender != "MALE" && gender != "FEMALE")
                {

                    gender = "NA";

                }
                try
                {
                    
                credits = decimal.Parse(txtCredits.Text.Trim());

                }
                catch (Exception exception)
                {
                }
                state = cboState.Text.Trim();

                stuDT.UpdateStudent(studid, firstname, lastname, dob, acctbal, gender, credits, state);

            }
            catch
            {

            }
            
        }
    }
}