protected void firstButton_Click(object sender, EventArgs e) { PaperOrder paperOrder = paperOrderManager.GetPaperOrder(0); GetData(paperOrder); Session["active"] = 0; }
public string Save(PaperOrder paperOrder) { if (paperOrderGateway.Insert(paperOrder) > 0) { return("Saved Successfully!!"); } return("Could Not Save data in Database!!"); }
protected void lastButton_Click(object sender, EventArgs e) { List <PaperOrder> paperOrderList = (List <PaperOrder>)(Session["paperOrder"]); int x = paperOrderList.Count - 1; PaperOrder paperOrder = paperOrderManager.GetPaperOrder(x); GetData(paperOrder); Session["active"] = x; }
private void GetData(PaperOrder paperOrder) { dateTextBox.Value = paperOrder.Date; supplierNameDropDownList.Text = paperOrder.SupplierName; slipNoTextBox.Text = paperOrder.SlipNo; pressCodeDropDownList.Text = paperOrder.PressCode; paperNameDropDownList.Text = paperOrder.PaperName; paperTypeDropDownList.Text = paperOrder.PaperType; quantityTextBox.Text = paperOrder.Quantity.ToString(); }
private static void GetValueFromDatabase(PaperOrder paperOrder, SqlDataReader reader) { paperOrder.PaperOrderId = int.Parse(reader["id"].ToString()); paperOrder.Date = reader["date"].ToString(); paperOrder.SupplierName = reader["supplier_id"].ToString(); paperOrder.SlipNo = reader["slip_no"].ToString(); paperOrder.PressCode = reader["press_id"].ToString(); paperOrder.PaperName = reader["paper_id"].ToString(); paperOrder.PaperType = reader["paper_type"].ToString(); paperOrder.Quantity = Convert.ToDouble(reader["quantity"].ToString()); }
public int Insert(PaperOrder paperOrder) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_paperOrder VALUES('" + paperOrder.Date + "','" + paperOrder.SupplierId + "','" + paperOrder.SlipNo + "','" + paperOrder.PressId + "','" + paperOrder.PaperId + "','" + paperOrder.PaperType + "','" + paperOrder.Quantity + "')"; 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 <PaperOrder> paperOrderList = (List <PaperOrder>)(Session["paperOrder"]); if (active <= -1) { active = paperOrderList.Count - 1; } PaperOrder paperOrder = paperOrderManager.GetPaperOrder(active); GetData(paperOrder); Session["active"] = active; }
protected void nextButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active++; List <PaperOrder> paperOrderList = (List <PaperOrder>)(Session["paperOrder"]); if (active >= paperOrderList.Count) { active = 0; } PaperOrder paperOrder = paperOrderManager.GetPaperOrder(active); GetData(paperOrder); Session["active"] = active; }
public PaperOrder GetPaperOrder(int i) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_paperOrder ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); PaperOrder paperOrder = new PaperOrder(); while (reader.Read()) { GetValueFromDatabase(paperOrder, reader); } reader.Close(); connection.Close(); return(paperOrder); }
public PaperOrder GetNextSlipNo() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_paperOrder ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); PaperOrder paperOrder = new PaperOrder(); while (reader.Read()) { paperOrder.PaperOrderId = int.Parse(reader["id"].ToString()); paperOrder.SlipNo = reader["slip_no"].ToString(); } reader.Close(); connection.Close(); return(paperOrder); }
private string LoadNextSlipNo() { PaperOrder paperOrder = paperOrderManager.GetNextSlipNo(); string slipNo = paperOrder.SlipNo; int count; if (slipNo == null) { count = 1; } else { count = (slipNo[4] - '0') * 10 + (slipNo[5] - '0') + 1; } string nextSlipNo = "Sl-0" + count.ToString("00"); return(nextSlipNo); }
public List <PaperOrder> GetAllPaperOrder() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_paperOrder"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <PaperOrder> paperOrderList = new List <PaperOrder>(); while (reader.Read()) { PaperOrder paperOrder = new PaperOrder(); GetValueFromDatabase(paperOrder, reader); paperOrderList.Add(paperOrder); } reader.Close(); connection.Close(); return(paperOrderList); }
protected void saveButton_Click(object sender, EventArgs e) { PaperOrder paperOrder = new PaperOrder(); paperOrder.Date = dateTextBox.Value; paperOrder.SupplierId = int.Parse(supplierNameDropDownList.SelectedValue); paperOrder.SlipNo = slipNoTextBox.Text; paperOrder.PressId = int.Parse(pressCodeDropDownList.SelectedValue); paperOrder.PaperId = int.Parse(paperNameDropDownList.SelectedValue); paperOrder.PaperType = paperTypeDropDownList.SelectedValue; string quantity = quantityTextBox.Text; if (dateTextBox.Value == "" || slipNoTextBox.Text == "" || paperTypeDropDownList.Text == "" || quantityTextBox.Text == "") { messageLabel.InnerText = "All Fields are Required!!"; } else { paperOrder.Quantity = Convert.ToDouble(quantity); messageLabel.InnerText = paperOrderManager.Save(paperOrder); } ClearTextBoxes(); }