protected void Page_Load(object sender, EventArgs e)
{
DsPSMS.ST_EQUIPMENT_MSTDataTable equipMstDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
showGd(); // binding data to datagridview
// binding Equipment name to combo box
/* CoboEquipName.DataSource = null;
* CoboEquipName.Items.Clear();
* CoboEquipName.Items.Add(new ListItem(" ", " "));
* CoboEquipName.SelectedIndex = 0;*/
if (!IsPostBack)
{
equipMstDt = equipService.getAllEquipMST(out msg);
if (equipMstDt != null && equipMstDt.Rows.Count != 0)
{
CoboEquipName.DataSource = equipMstDt;
CoboEquipName.DataTextField = "EQUIPMENT_NAME";
CoboEquipName.DataValueField = "EQUIPMENT_ID";
CoboEquipName.DataBind();
}
}
if (Session["USER_ID"] != null)
{
userId = (string)(Session["USER_ID"] ?? " ");
}
}
// select all Equipment data from ST_EQUIPMENT_MST
public DsPSMS.ST_EQUIPMENT_MSTDataTable selectAllEquipMSt()
{
DsPSMS.ST_EQUIPMENT_MSTDataTable stuEquipMSTDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
Open();
query = "SELECT* FROM ST_EQUIPMENT_MST WHERE DEL_FLG = " + 0;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(stuEquipMSTDt);
Close();
return(stuEquipMSTDt);
}
// select Equipment data from ST_EQUIPMENT_MST by id
public DsPSMS.ST_EQUIPMENT_MSTDataTable selectEquipDataById(int id)
{
DsPSMS.ST_EQUIPMENT_MSTDataTable stuEquipMstDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
Open();
query = "SELECT* FROM ST_EQUIPMENT_MST WHERE DEL_FLG = " + 0 + " AND EQUIPMENT_ID='" + id + "'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(stuEquipMstDt);
Close();
return(stuEquipMstDt);
}
public DataSet.DsPSMS.ST_EQUIPMENT_MSTRow getEquipDataById(int id, out string msg)
{
DsPSMS.ST_EQUIPMENT_MSTDataTable EqMstDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
try
{
Open();
EqMstDt = equipDb.selectEquipDataById(id);
msg = "Have data";
}
catch
{
msg = "error occurs when selecting the equipment data";
return(null);
}
finally
{
Close();
}
return(EqMstDt[0]);
}
public DataSet.DsPSMS.ST_EQUIPMENT_MSTDataTable getAllEquipMST(out string msg)
{
DsPSMS.ST_EQUIPMENT_MSTDataTable EqMSTDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
try
{
Open();
EqMSTDt = equipDb.selectAllEquipMSt();
msg = "Have data";
}
catch
{
msg = "error occurs when selecting the equipment master";
return(null);
}
finally
{
Close();
}
return(EqMSTDt);
}
protected void save_Click(object sender, EventArgs e)
{
DsPSMS.ST_EQUIPMENT_MSTDataTable equipMstDt = new DsPSMS.ST_EQUIPMENT_MSTDataTable();
DsPSMS.ST_EQUIPMENT_MSTRow equipMstDr = new DsPSMS.ST_EQUIPMENT_MSTDataTable().NewST_EQUIPMENT_MSTRow();
if (CoboYear.Text.Trim().Length != 0)
{
equipMstDr.EDU_YEAR = CoboYear.Text;
if (TxtEquipID.Text.Trim().Length != 0)
{
equipMstDr.EQUIPMENT_ID = TxtEquipID.Text;
if (TxtEqpName.Text.Trim().Length != 0)
{
equipMstDr.EQUIPMENT_NAME = TxtEqpName.Text;
equipMstDr.CRT_DT_TM = DateTime.Now;
equipMstDr.CRT_USER_ID = this.userId;
equipMstDr.UPD_DT_TM = DateTime.Now;
equipMstDr.UPD_USER_ID = "";
equipService.SaveEquipmentMST(equipMstDr, out msg);
}
else
{
errName.Text = "Please Equipment Name";
}
}
else
{
errid.Text = "Enter Equipment ID";
}
}
else
{
errYY.Text = "Please choose the year";
}
}
