protected void saveButton_Click(object sender, EventArgs e) { BinderOrder binderOrder = new BinderOrder(); binderOrder.Date = dateTextBox.Value; binderOrder.Year = yearTextBox.Text; binderOrder.OrderNo = orderNoTextBox.Text; binderOrder.BinderId = int.Parse(binderNameDropDownList.SelectedValue); binderOrder.GroupId = int.Parse(groupCodeDropDownList.SelectedValue); binderOrder.BookId = int.Parse(bookCodeDropDownList.SelectedValue); string quantity = quantityTextBox.Text; string formaQuantity = formaQuantityTextBox.Text; binderOrder.PressId = int.Parse(pressNameDropDownList.SelectedValue); string forma = formaTextBox.Text; if (dateTextBox.Value == "" || yearTextBox.Text == "" || orderNoTextBox.Text == "" || quantityTextBox.Text == "" || formaQuantityTextBox.Text == "" || formaTextBox.Text == "") { messageLabel.InnerText = "All Fields are Required!!"; } else { binderOrder.Quantity = Convert.ToDouble(quantity); binderOrder.FormaQuantity = Convert.ToDouble(formaQuantity); binderOrder.Forma = Convert.ToDouble(forma); messageLabel.InnerText = binderOrderManager.Save(binderOrder); } ClearTextBoxes(); }
protected void firstButton_Click(object sender, EventArgs e) { BinderOrder binderOrder = binderOrderManager.GetBinderOrder(0); GetData(binderOrder); Session["active"] = 0; }
public string Save(BinderOrder binderOrder) { if (binderOrderGateway.Insert(binderOrder) > 0) { return("Saved Successfully!!"); } return("Could Not Save data in Database!!"); }
protected void lastButton_Click(object sender, EventArgs e) { List <BinderOrder> binderOrderList = (List <BinderOrder>)(Session["binderOrder"]); int x = binderOrderList.Count - 1; BinderOrder binderOrder = binderOrderManager.GetBinderOrder(x); GetData(binderOrder); Session["active"] = x; }
private void GetData(BinderOrder binderOrder) { dateTextBox.Value = binderOrder.Date; yearTextBox.Text = binderOrder.Year; orderNoTextBox.Text = binderOrder.OrderNo; binderNameDropDownList.Text = binderOrder.BinderName; groupCodeDropDownList.Text = binderOrder.GroupCode; bookCodeDropDownList.Text = binderOrder.BookCode; quantityTextBox.Text = binderOrder.Quantity.ToString(); formaQuantityTextBox.Text = binderOrder.FormaQuantity.ToString(); pressNameDropDownList.Text = binderOrder.PressName; formaTextBox.Text = binderOrder.Forma.ToString(); }
private static void GetValueFromDatabase(BinderOrder binderOrder, SqlDataReader reader) { binderOrder.BinderOrderId = int.Parse(reader["id"].ToString()); binderOrder.Date = reader["date"].ToString(); binderOrder.Year = reader["year"].ToString(); binderOrder.OrderNo = reader["order_no"].ToString(); binderOrder.BinderName = reader["binder_id"].ToString(); binderOrder.GroupCode = reader["group_id"].ToString(); binderOrder.BookCode = reader["book_id"].ToString(); binderOrder.Quantity = Convert.ToDouble(reader["quantity"].ToString()); binderOrder.FormaQuantity = Convert.ToDouble(reader["forma_quantity"].ToString()); binderOrder.PressName = reader["press_id"].ToString(); binderOrder.Forma = Convert.ToDouble(reader["forma"].ToString()); }
public int Insert(BinderOrder binderOrder) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_binderOrder VALUES('" + binderOrder.Date + "','" + binderOrder.Year + "','" + binderOrder.OrderNo + "','" + binderOrder.BinderId + "','" + binderOrder.GroupId + "','" + binderOrder.BookId + "','" + binderOrder.Quantity + "','" + binderOrder.FormaQuantity + "','" + binderOrder.PressId + "','" + binderOrder.Forma + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
protected void previousButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active--; List <BinderOrder> binderOrderList = (List <BinderOrder>)(Session["binderOrder"]); if (active <= -1) { active = binderOrderList.Count - 1; } BinderOrder binderOrder = binderOrderManager.GetBinderOrder(active); GetData(binderOrder); Session["active"] = active; }
protected void nextButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active++; List <BinderOrder> binderOrderList = (List <BinderOrder>)(Session["binderOrder"]); if (active >= binderOrderList.Count) { active = 0; } BinderOrder binderOrder = binderOrderManager.GetBinderOrder(active); GetData(binderOrder); Session["active"] = active; }
public BinderOrder GetBinderOrder(int i) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_binderOrder ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); BinderOrder binderOrder = new BinderOrder(); while (reader.Read()) { GetValueFromDatabase(binderOrder, reader); } reader.Close(); connection.Close(); return(binderOrder); }
public BinderOrder GetNextOrderNo() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_binderOrder ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); BinderOrder binderOrder = new BinderOrder(); while (reader.Read()) { binderOrder.BinderOrderId = int.Parse(reader["id"].ToString()); binderOrder.OrderNo = reader["order_no"].ToString(); } reader.Close(); connection.Close(); return(binderOrder); }
private string LoadNextOrderNo() { BinderOrder binderOrder = binderOrderManager.GetNextOrderNo(); string orderNo = binderOrder.OrderNo; int count; if (orderNo == null) { count = 1; } else { count = (orderNo[2] - '0') * 10 + (orderNo[3] - '0') + 1; } string nextOrderNo = "Or" + count.ToString("00"); return(nextOrderNo); }
public List <BinderOrder> GetAllBinderOrder() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_binderOrder"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <BinderOrder> binderOrderList = new List <BinderOrder>(); while (reader.Read()) { BinderOrder binderOrder = new BinderOrder(); GetValueFromDatabase(binderOrder, reader); binderOrderList.Add(binderOrder); } reader.Close(); connection.Close(); return(binderOrderList); }