protected void firstButton_Click(object sender, EventArgs e) { CoverReceived coverReceived = coverReceivedManager.GetCovers(0); GetValue(coverReceived); Session["active"] = 0; }
public string Save(CoverReceived coverReceived) { if (coverReceivedGateway.Insert(coverReceived) > 0) { return "Saved Successfully!!"; } return "Could not Save Data in Database!!"; }
protected void lastButton_Click(object sender, EventArgs e) { List <CoverReceived> coverReceivedList = (List <CoverReceived>)(Session["coverReceived"]); int x = coverReceivedList.Count - 1; CoverReceived coverReceived = coverReceivedManager.GetCovers(x); GetValue(coverReceived); Session["active"] = x; }
private void GetValue(CoverReceived coverReceived) { dateTextBox.Value = coverReceived.Date; recvNoTextBox.Text = coverReceived.RecNo; yearTextBox.Text = coverReceived.Year; groupNameDropDownList.Text = coverReceived.GroupName; bookNameDropDownList.Text = coverReceived.BookName; quantityTextBox.Text = coverReceived.Quantity.ToString(); }
private static void GetValueFromDatabase(CoverReceived coverReceived, SqlDataReader reader) { coverReceived.CouerReceivedId = int.Parse(reader["id"].ToString()); coverReceived.Date = reader["date"].ToString(); coverReceived.RecNo = reader["receive_no"].ToString(); coverReceived.Year = reader["year"].ToString(); coverReceived.GroupName = reader["group_id"].ToString(); coverReceived.BookName = reader["book_id"].ToString(); coverReceived.Quantity = Convert.ToDouble(reader["quantity"].ToString()); }
public int Insert(CoverReceived coverReceived) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO tbl_coverReceived VALUES('" + coverReceived.Date + "','" + coverReceived.RecNo + "','" + coverReceived.Year + "','" + coverReceived.GroupId + "','" + coverReceived.BookId + "','" + coverReceived.Quantity + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
protected void searchButton_Click(object sender, EventArgs e) { var r = recvTextBox.Value; CoverReceived coverReceived = coverReceivedManager.GetSearchInfo(r); if (coverReceived.RecNo == null) { message.InnerText = "Invalid Receive No!!"; } else { GetValue(coverReceived); message.InnerText = ""; } }
protected void previousButton_Click(object sender, EventArgs e) { int active = (int)Session["active"]; active--; List <CoverReceived> coverReceivedList = (List <CoverReceived>)(Session["coverReceived"]); if (active <= -1) { active = coverReceivedList.Count - 1; } CoverReceived coverReceived = coverReceivedManager.GetCovers(active); GetValue(coverReceived); Session["active"] = active; }
public CoverReceived GetSearchInfo(string s) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_coverReceived WHERE receive_no='" + s + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); CoverReceived coverReceived = new CoverReceived(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { GetValueFromDatabase(coverReceived, reader); } reader.Close(); connection.Close(); return(coverReceived); }
public CoverReceived GetCovers(int i) { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_coverReceived ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CoverReceived coverReceived = new CoverReceived(); while (reader.Read()) { GetValueFromDatabase(coverReceived, reader); } reader.Close(); connection.Close(); return(coverReceived); }
private string LoadNextRecvNo() { CoverReceived coverReceived = coverReceivedManager.GetNextReceiveNo(); string recvNo = coverReceived.RecNo; int count; if (recvNo == null) { count = 1; } else { count = (recvNo[4] - '0') * 10 + (recvNo[5] - '0') + 1; } string nextRecvNo = "Rc-0" + count.ToString("00"); return(nextRecvNo); }
public CoverReceived GetNextReceiveNo() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT TOP 1 * FROM tbl_coverReceived ORDER BY id DESC"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CoverReceived coverReceived = new CoverReceived(); while (reader.Read()) { coverReceived.CouerReceivedId = int.Parse(reader["id"].ToString()); coverReceived.RecNo = reader["receive_no"].ToString(); } reader.Close(); connection.Close(); return(coverReceived); }
public List <CoverReceived> GetAllCoverReceived() { SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM tbl_coverReceived"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <CoverReceived> coverReceivedList = new List <CoverReceived>(); while (reader.Read()) { CoverReceived coverReceived = new CoverReceived(); GetValueFromDatabase(coverReceived, reader); coverReceivedList.Add(coverReceived); } reader.Close(); connection.Close(); return(coverReceivedList); }
protected void saveButton_Click(object sender, EventArgs e) { CoverReceived coverReceived = new CoverReceived(); coverReceived.Date = dateTextBox.Value; coverReceived.RecNo = recvNoTextBox.Text; coverReceived.Year = yearTextBox.Text; coverReceived.GroupId = int.Parse(groupNameDropDownList.SelectedValue); coverReceived.BookId = int.Parse(bookNameDropDownList.SelectedValue); string quantity = quantityTextBox.Text; if (dateTextBox.Value == "" || recvNoTextBox.Text == "" || yearTextBox.Text == "" || quantityTextBox.Text == "") { messageLabel.InnerText = "All Fields are Required!!"; } else { coverReceived.Quantity = Convert.ToDouble(quantity); messageLabel.InnerText = coverReceivedManager.Save(coverReceived); } ClearTextBoxes(); }