protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
obj = new clsSoftware();
objPrp = new clsSoftwarePrp();
objPrp.Psoftware_id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex][0]);
obj.del_rec(objPrp);
Free_Memory();
grid_bind();
}
protected void Btn_Submit_Update_Click(object sender, EventArgs e)
{
obj = new clsSoftware();
objPrp = new clsSoftwarePrp();
objPrp.Psoftware_name = TextBox1.Text;
objPrp.Psoftware_manufacturer = TextBox2.Text;
objPrp.Psoftware_version = TextBox3.Text;
objPrp.Psoftware_purchase_date = Convert.ToDateTime(TextBox4.Text);
objPrp.Psoftware_purchase_file_number = TextBox5.Text;
if (TextBox6.Text != "" && TextBox7.Text != "")
{
objPrp.Psoftware_warrenty_from = Convert.ToDateTime(TextBox6.Text);
objPrp.Psoftware_warrenty_to = Convert.ToDateTime(TextBox7.Text);
}
if (TextBox8.Text != "" && TextBox9.Text != "")
{
objPrp.Psoftware_annual_maintenance_contract_from = Convert.ToDateTime(TextBox8.Text);
objPrp.Psoftware_annual_maintenance_contract_to = Convert.ToDateTime(TextBox9.Text);
}
objPrp.Psoftware_annual_maintenance_contract_detail = TextArea1.Value;
objPrp.Psoftware_annual_maintenance_contract_number = TextBox10.Text;
objPrp.Psoftware_serial_number_or_service_tag_number = TextBox11.Text;
objPrp.Psoftware_emp_id = Convert.ToInt32(DropDownList1.SelectedValue);
if (Btn_Submit_Update.Text == "Save")
{
obj.save_rec(objPrp);
TextBox1.Focus();
}
else if (Btn_Submit_Update.Text == "Update")
{
objPrp.Psoftware_id = Convert.ToInt32(ViewState["Index_Of_Editing_Row"]);
obj.upd_rec(objPrp);
Btn_Submit_Update.Text = "Save";
Btn_Reset_Cancel.Text = "Reset";
Label1.Visible = false; //ID text
Label2.Visible = false; //ID value
}
clear_rec();
grid_bind();
Free_Memory();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
obj = new clsSoftware();
objPrp = new clsSoftwarePrp();
//e.Cancel = true;
Label1.Visible = true; //ID text
Label2.Visible = true; //ID value
//ViewState["Index_Of_Editing_Row"] = Convert.ToInt32(GridView1.DataKeys[e.NewEditIndex][0]);
ViewState["Index_Of_Editing_Row"] = objPrp.Psoftware_id = Convert.ToInt32(GridView1.DataKeys[e.NewEditIndex][0]);
objPrp = obj.find_rec(objPrp);
Label1.Text = "ID";
Label2.Text = Convert.ToString(objPrp.Psoftware_id);
TextBox1.Text = objPrp.Psoftware_name;
TextBox2.Text = objPrp.Psoftware_manufacturer;
TextBox3.Text = objPrp.Psoftware_version;
TextBox4.Text = Convert.ToString(objPrp.Psoftware_purchase_date).Substring(0, 10);
TextBox5.Text = objPrp.Psoftware_purchase_file_number;
TextBox6.Text = Convert.ToString(objPrp.Psoftware_warrenty_from).Substring(0, 10);
TextBox7.Text = Convert.ToString(objPrp.Psoftware_warrenty_to).Substring(0, 10);
TextBox8.Text = Convert.ToString(objPrp.Psoftware_annual_maintenance_contract_from).Substring(0, 10);
TextBox9.Text = Convert.ToString(objPrp.Psoftware_annual_maintenance_contract_to).Substring(0, 10);
TextArea1.Value = objPrp.Psoftware_annual_maintenance_contract_detail;
TextBox10.Text = objPrp.Psoftware_annual_maintenance_contract_number;
TextBox11.Text = objPrp.Psoftware_serial_number_or_service_tag_number;
if (objPrp.Psoftware_emp_id != 0)
{
DropDownList1.SelectedValue = objPrp.Psoftware_emp_id.ToString();
//DropDownList1.Enabled = true;
}
//else
//{
// DropDownList1.Enabled = false;
//}
Btn_Submit_Update.Text = "Update";
Btn_Reset_Cancel.Text = "Cancel";
Free_Memory();
}
private void Free_Memory()
{
objPrp = null;
obj = null;
GC.Collect();
}
