protected void Page_Load(object sender, EventArgs e) { fund_utilizationBAL fundBAL = new fund_utilizationBAL(); fund_utilizationBO fundBO = new fund_utilizationBO(); fundBO = fundBAL.fund_info_retrive(); upper_desc.Text = fundBO.upper_detail; first_desc.Text = fundBO.first_utilization; second_desc.Text = fundBO.second_utilization; third_desc.Text = fundBO.third_utilization; fourth_desc.Text = fundBO.fourth_utilization; }
public bool fund_info_save(fund_utilizationBO fundBO1) { try { return(fundDAL.fund_info_save(fundBO1)); } catch (Exception) { throw; } }
// fund utilisation public fund_utilizationBO fund_info_retrive() { fund_utilizationBO fundBO = new fund_utilizationBO(); try { if (newcon.State == ConnectionState.Closed) { newcon.Open(); } String query = "Select * from fund_utilization"; command = new SqlCommand(query, newcon); reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); { fundBO.upper_detail = reader[0].ToString(); fundBO.first_utilization = reader[1].ToString(); fundBO.second_utilization = reader[2].ToString(); fundBO.third_utilization = reader[3].ToString(); fundBO.fourth_utilization = reader[4].ToString(); } } else { fundBO = null; } command.Dispose(); reader.Dispose(); return(fundBO); } catch { throw; } finally { if (newcon.State == ConnectionState.Open) { newcon.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin_id"] == null) { Response.Redirect("AdminLogin.aspx"); } else { if (!IsPostBack) { fundBO = fundBAL.fund_info_retrive(); upper_desc.Value = fundBO.upper_detail; first_desc.Value = fundBO.first_utilization; second_desc.Value = fundBO.second_utilization; third_desc.Value = fundBO.third_utilization; fourth_desc.Value = fundBO.fourth_utilization; } } }
public bool fund_info_save(fund_utilizationBO fundBO) { try { if (newcon.State == ConnectionState.Closed) { newcon.Open(); } String query = "Update fund_utilization set upper_detail=@upper_detail,first_utilization=@first_utilization,second_utilization=@second_utilization,third_utilization=@third_utilization,fourth_utilization=@fourth_utilization"; command = new SqlCommand(query, newcon); command.Parameters.AddWithValue("@upper_detail", fundBO.upper_detail); command.Parameters.AddWithValue("@first_utilization", fundBO.first_utilization); command.Parameters.AddWithValue("@second_utilization", fundBO.second_utilization); command.Parameters.AddWithValue("@third_utilization", fundBO.third_utilization); command.Parameters.AddWithValue("@fourth_utilization", fundBO.fourth_utilization); command.ExecuteNonQuery(); command.Dispose(); newcon.Close(); return(true); } catch { throw; } finally { if (newcon.State == ConnectionState.Open) { newcon.Close(); } } }