private void grid_bind() { obj = new clsMiscellaneous(); GridView1.DataSource = obj.disp_rec(); GridView1.DataBind(); Free_Memory(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { obj = new clsMiscellaneous(); objPrp = new clsMiscellaneousPrp(); objPrp.Pmiscellaneous_id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex][0]); obj.del_rec(objPrp); Free_Memory(); grid_bind(); }
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { obj = new clsMiscellaneous(); objPrp = new clsMiscellaneousPrp(); item_form.Visible = true; GridView1_heading.Visible = false; 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.Pmiscellaneous_id = Convert.ToInt32(GridView1.DataKeys[e.NewEditIndex][0]); objPrp = obj.find_rec(objPrp); Label1.Text = "ID"; Label2.Text = Convert.ToString(objPrp.Pmiscellaneous_id); TextBox1.Text = objPrp.Pmiscellaneous_product_name; TextBox2.Text = objPrp.Pmiscellaneous_manufacturer; if (objPrp.Pmiscellaneous_purchase_date != null) { TextBox3.Text = Convert.ToString(objPrp.Pmiscellaneous_purchase_date).Substring(0, 10); } TextBox4.Text = objPrp.Pmiscellaneous_purchase_file_number; if (objPrp.Pmiscellaneous_warrenty_from != null && objPrp.Pmiscellaneous_warrenty_from != null) { TextBox5.Text = Convert.ToString(objPrp.Pmiscellaneous_warrenty_from).Substring(0, 10); TextBox6.Text = Convert.ToString(objPrp.Pmiscellaneous_warrenty_to).Substring(0, 10); } if (objPrp.Pmiscellaneous_annual_maintenance_contract_from != null && objPrp.Pmiscellaneous_annual_maintenance_contract_to != null) { TextBox7.Text = Convert.ToString(objPrp.Pmiscellaneous_annual_maintenance_contract_from).Substring(0, 10); TextBox8.Text = Convert.ToString(objPrp.Pmiscellaneous_annual_maintenance_contract_to).Substring(0, 10); } TextArea1.Value = objPrp.Pmiscellaneous_annual_maintenance_contract_detail; TextBox9.Text = objPrp.Pmiscellaneous_annual_maintenance_contract_number; TextBox10.Text = objPrp.Pmiscellaneous_serial_no_or_service_tag_number; TextBox11.Text = objPrp.Pmiscellaneous_quantity.ToString(); if (objPrp.Pmiscellaneous_emp_id != 0) { DropDownList1.SelectedValue = objPrp.Pmiscellaneous_emp_id.ToString(); CheckBox1.Checked = false; DropDownList1.Enabled = true; } else { CheckBox1.Checked = true; DropDownList1.Enabled = false; } Btn_Submit_Update.Text = "Update"; //Btn_Cancel.Visible = true; Btn_Reset_Cancel.Text = "Cancel"; Free_Memory(); }
protected void Btn_Submit_Update_Click(object sender, EventArgs e) { obj = new clsMiscellaneous(); objPrp = new clsMiscellaneousPrp(); objPrp.Pmiscellaneous_product_name = TextBox1.Text; objPrp.Pmiscellaneous_manufacturer = TextBox2.Text; objPrp.Pmiscellaneous_purchase_date = Convert.ToDateTime(TextBox3.Text); objPrp.Pmiscellaneous_purchase_file_number = TextBox4.Text; if (TextBox5.Text != "" && TextBox6.Text != "") { objPrp.Pmiscellaneous_warrenty_from = Convert.ToDateTime(TextBox5.Text); objPrp.Pmiscellaneous_warrenty_to = Convert.ToDateTime(TextBox6.Text); } if (TextBox7.Text != "" && TextBox8.Text != "") { objPrp.Pmiscellaneous_annual_maintenance_contract_from = Convert.ToDateTime(TextBox7.Text); objPrp.Pmiscellaneous_annual_maintenance_contract_to = Convert.ToDateTime(TextBox8.Text); } objPrp.Pmiscellaneous_annual_maintenance_contract_detail = TextArea1.Value; objPrp.Pmiscellaneous_annual_maintenance_contract_number = TextBox9.Text; objPrp.Pmiscellaneous_serial_no_or_service_tag_number = TextBox10.Text; if (TextBox11.Text != "") { objPrp.Pmiscellaneous_quantity = Convert.ToInt32(TextBox11.Text); } else { objPrp.Pmiscellaneous_quantity = null; } if (CheckBox1.Checked == false) { objPrp.Pmiscellaneous_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.Pmiscellaneous_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(); }
private void common_grid_bind() { objHardware = new clsHardware(); GridView_hardware.DataSource = objHardware.disp_emp_HW_rec(Convert.ToString(Session["id"])); GridView_hardware.DataBind(); objSoftware = new clsSoftware(); GridView_software.DataSource = objSoftware.disp_emp_SW_rec(Convert.ToString(Session["id"])); GridView_software.DataBind(); objMislaneous = new clsMiscellaneous(); GridView_miscellaneous.DataSource = objMislaneous.disp_emp_MIS_rec(Convert.ToString(Session["id"])); GridView_miscellaneous.DataBind(); objStationary = new clsStationary(); GridView_stationary.DataSource = objStationary.disp_emp_Stationary_rec(Convert.ToString(Session["id"])); GridView_stationary.DataBind(); }
private void Free_Memory() { objPrp = null; obj = null; GC.Collect(); }