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();
}
}
}
