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