CNSA-212-Personal/Database3/frmEdit.cs
2024-02-15 12:04:47 -05:00

122 lines
3.0 KiB
C#

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