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