protected void Button1_Click1(object sender, EventArgs e)
{
if (TextBox10.Text == "")
{
TextBox10.Text = "0";
}
int MyNo = Int32.Parse(TextBox10.Text);
if (Gridview1.Rows.Count >= MyNo)
{
Button1.Visible = false;
lblMax.Text = "Maximum Book Is Issuesed";
return;
}
A_Handler = new Book_Issue_ReturnHandler();
A1 = new Book_Issue_Return();
// A1.Bir_id = Convert.ToInt32(DropDownList1.SelectedValue.ToString());
A1.Reg_id = Int32.Parse(lblReg_ID.Text);
A1.Mem_id = Convert.ToInt32(lblMem_Id.Text);
A1.Acc_id = Convert.ToInt32(lblAcc_ID.Text);
A1.Issue_dt = Convert.ToDateTime(TextBox7.Text);
A1.Issue_days = Convert.ToInt32(TextBox8.Text);
A1.Due_dt = A1.Issue_dt.AddDays(A1.Issue_days);
A1.Return_dt = A1.Issue_dt;
A1.Due_day = 0;
A1.Is_return = false;
A1.Is_fine = false;
A1.Fine_amt = 0;
bool b = A_Handler.AddNewBook_Issue_Return(A1);
if (b == true)
{
lblMax.Text = "Book is Issued";
//GridView1.DataBind();
}
SqlDataSource3.SelectCommand = "SELECT Bir_id, Acc_code, Title, Author, Book_type, Issue_dt,due_dt, Photo FROM VBook_Issue_Return WHERE (Is_return = 0) AND (Mem_id = " + lblMem_Id.Text + ")";
SqlDataSource3.DataBind();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
A_Handler = new Book_Issue_ReturnHandler();
A1 = new Book_Issue_Return();
//A1.Bir_id = Convert.ToInt32(txtBir_id.Text);
A1.Reg_id = Convert.ToInt32(ddlReg_id.SelectedValue);
A1.Mem_id = Convert.ToInt32(ddlMem_id.SelectedValue);
A1.Acc_id = Convert.ToInt32(ddlAcc_id.SelectedValue);
A1.Issue_dt = Convert.ToDateTime(txtIssue_dt.Text);
A1.Issue_days = Convert.ToInt32(txtIssue_days.Text);
A1.Due_dt = Convert.ToDateTime(txtDue_dt.Text);
A1.Return_dt = Convert.ToDateTime(txtReturn_dt.Text);
A1.Due_day = Convert.ToInt32(txtDue_day.Text);
if (DropDownList1.SelectedValue.ToString() == "1")
{
A1.Is_return = true;
}
else
{
A1.Is_return = false;
}
if (DropDownList2.SelectedValue.ToString() == "1")
{
A1.Is_fine = true;
}
else
{
A1.Is_fine = false;
}
//A1.Is_fine = Convert.ToBoolean(DropDownList2.SelectedValue.ToString());
// A1.Fine_rate = Convert.ToDecimal(txtFine_rate.Text);
A1.Fine_amt = Convert.ToDecimal(txtFine_amt.Text);
if (btnSubmit.Text == "Submit")
{
bool B = A_Handler.AddNewBook_Issue_Return(A1);
if (B == true)
{
Label1.Text = "Record Inserted";
MSG = "Record Inserted";
}
else
{
Label1.Text = "Record Not Inserted";
MSG = "Record Not Inserted";
}
}
else if (btnSubmit.Text == "Update")
{
A1.Bir_id = Convert.ToInt32(txtBir_id.Text);
bool B = A_Handler.UpdateBook_Issue_Return(A1);
if (B == true)
{
Label1.Text = "Record Updated";
MSG = "Record Not Updated";
}
else
{
Label1.Text = "Record Not Updated";
MSG = "Record Not Updated";
}
}
else if (btnSubmit.Text == "Delete")
{
A1.Bir_id = Convert.ToInt32(txtBir_id.Text);
bool B = A_Handler.DeleteBook_Issue_Return(A1);
if (B == true)
{
Label1.Text = "Record Deleted";
MSG = "Record Deleted";
}
else
{
Label1.Text = "Record Not Deleted";
MSG = "Record Not Deleted";
}
}
// Response.Redirect("~/ADMIN/Book_Issue_Return_list.aspx?msg="+MSG);
}