public void show_data(int ID) { A_Handler = new Book_Issue_ReturnHandler(); A1 = new Book_Issue_Return(); A1 = A_Handler.GetBook_Issue_ReturnDetails(ID); txtBir_id.Text = A1.Bir_id.ToString(); ddlReg_id.SelectedValue = A1.Reg_id.ToString(); ddlMem_id.SelectedValue = A1.Mem_id.ToString(); ddlAcc_id.SelectedValue = A1.Acc_id.ToString(); txtIssue_dt.Text = A1.Issue_dt.ToString(); txtIssue_days.Text = A1.Issue_days.ToString(); txtDue_dt.Text = A1.Due_dt.ToString(); txtReturn_dt.Text = A1.Return_dt.ToString(); txtDue_day.Text = A1.Due_day.ToString(); DropDownList1.SelectedValue = A1.Is_return.ToString(); DropDownList2.SelectedValue = A1.Is_fine.ToString(); // txtI.Text = A1.Is_return.ToString(); // txtIs_fine.Text = A1.Is_fine.ToString(); txtFine_rate.Text = A1.Fine_rate.ToString(); txtFine_amt.Text = A1.Fine_amt.ToString(); btnSubmit.Text = "Update"; btnReset.Text = "Cancel"; if (Request.QueryString["action"] == "del") { Label1.Text = "Are u Sure If U Want to Delete Record"; txtBir_id.ReadOnly = false; ddlReg_id.Enabled = false; ddlMem_id.Enabled = false; ddlAcc_id.Enabled = false; txtIssue_dt.ReadOnly = false; txtIssue_days.ReadOnly = false; txtDue_dt.ReadOnly = false; txtReturn_dt.ReadOnly = false; txtDue_day.ReadOnly = false; DropDownList1.Enabled = false; DropDownList2.Enabled = false; txtFine_rate.ReadOnly = false; txtFine_amt.ReadOnly = false; btnSubmit.Text = "Delete"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { A1 = new Book_Issue_Return(); int ID = Convert.ToInt32(Request.QueryString["id"]); show_data(ID); } } }
protected void Button1_Click(object sender, EventArgs e) { A_Handler = new Book_Issue_ReturnHandler(); A1 = new Book_Issue_Return(); A1.Bir_id = Convert.ToInt32(DropDownList1.SelectedValue.ToString()); A1.Reg_id = Convert.ToInt32(lblReg_ID.Text); A1.Mem_id = Convert.ToInt32(DropDownList2.SelectedValue.ToString()); A1.Acc_id = Convert.ToInt32(lblAccID.Text); A1.Issue_dt = Convert.ToDateTime(lblIssue_Dt.Text); A1.Issue_days = Int32.Parse(lblIssueDay.Text); A1.Due_dt = Convert.ToDateTime(lblDueDt.Text); A1.Return_dt = DateTime.Now;//DateTime.Parse(TextBox3.Text); TimeSpan t = A1.Return_dt - A1.Due_dt; int day = (int)t.TotalDays; lblTotDay.Text = "Total Days : " + day.ToString(); A1.Due_day = 0;//Int32.Parse(lblTotDay.Text); A1.Is_return = true; if (t.TotalDays <= 0) { A1.Is_fine = false; A1.Fine_rate = 0; A1.Fine_amt = 0; } else { A1.Is_fine = true; A1.Fine_rate = Decimal.Parse(lblFinePer_Day.Text); A1.Fine_amt = A1.Fine_rate * (decimal)t.TotalDays; } bool B = A_Handler.UpdateBook_Issue_Return(A1); if (B == true) { lblMsg.Text = "Book is Returned"; GridView1.DataBind(); } else { lblMsg.Text = "Book is Not Returned"; } }
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); }
// This fuction does not contain any business logic, it simply returns the // list of book_issue_returns, we can put some logic here if needed public bool AddNewBook_Issue_Return(Book_Issue_Return b1) { return(book_issue_returnDb.AddNewBook_Issue_Return(b1)); }
// This fuction does not contain any business logic, it simply returns the // list of book_issue_returns, we can put some logic here if needed public bool DeleteBook_Issue_Return(Book_Issue_Return b1) { return(book_issue_returnDb.DeleteBook_Issue_Return(b1)); }
// This fuction does not contain any business logic, it simply returns the // list of book_issue_returns, we can put some logic here if needed public bool UpdateBook_Issue_Return(Book_Issue_Return b1) { return(book_issue_returnDb.UpdateBook_Issue_Return(b1)); }