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