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