protected void firstButton_Click(object sender, EventArgs e)
{
CoverSupply coverSupply = coverSupplyManager.GetSupplier(0);
GetData(coverSupply);
Session["active"] = 0;
}
public string Save(CoverSupply coverSupply)
{
if (coverSupplyGateway.Insert(coverSupply) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save data in Database!!");
}
protected void lastButton_Click(object sender, EventArgs e)
{
List <CoverSupply> coverSupplyList = (List <CoverSupply>)(Session["coverSupply"]);
int x = coverSupplyList.Count - 1;
CoverSupply coverSupply = coverSupplyManager.GetSupplier(x);
GetData(coverSupply);
Session["active"] = x;
}
private void GetData(CoverSupply coverSupply)
{
dateTextBox.Value = coverSupply.Date;
supplyNoTextBox.Text = coverSupply.SupplyNo;
binderNameDropDownList.Text = coverSupply.BinderName;
groupNameDropDownList.Text = coverSupply.GroupName;
bookNameDropDownList.Text = coverSupply.BookName;
quantityTextBox.Text = coverSupply.Quantity.ToString();
}
private static void GetValueFromDatabase(CoverSupply coverSupply, SqlDataReader reader)
{
coverSupply.CoverSupplyId = int.Parse(reader["id"].ToString());
coverSupply.Date = reader["date"].ToString();
coverSupply.SupplyNo = reader["supply_no"].ToString();
coverSupply.BinderName = reader["binder_id"].ToString();
coverSupply.GroupName = reader["group_id"].ToString();
coverSupply.BookName = reader["book_id"].ToString();
coverSupply.Quantity = Convert.ToDouble(reader["quantity"].ToString());
}
public int Insert(CoverSupply coverSupply)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_coverSupply VALUES('" + coverSupply.Date + "','" + coverSupply.SupplyNo +
"','" + coverSupply.BinderId + "','" + coverSupply.GroupId + "','" + coverSupply.BookId +
"','" + coverSupply.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 = supplyTextBox.Value;
CoverSupply coverSupply = coverSupplyManager.GetSearchInfo(r);
if (coverSupply.SupplyNo == null)
{
message.InnerText = "Invalid Supply No!!";
}
else
{
GetData(coverSupply);
message.InnerText = "";
}
}
protected void previousButton_Click(object sender, EventArgs e)
{
int active = (int)Session["active"];
active--;
List <CoverSupply> coverSupplyList = (List <CoverSupply>)(Session["coverSupply"]);
if (active <= -1)
{
active = coverSupplyList.Count - 1;
}
CoverSupply coverSupply = coverSupplyManager.GetSupplier(active);
GetData(coverSupply);
Session["active"] = active;
}
public CoverSupply GetSearchInfo(string s)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_coverSupply WHERE supply_no='" + s + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
CoverSupply coverSupply = new CoverSupply();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GetValueFromDatabase(coverSupply, reader);
}
reader.Close();
connection.Close();
return(coverSupply);
}
public CoverSupply GetSupplier(int i)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_coverSupply ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CoverSupply coverSupply = new CoverSupply();
while (reader.Read())
{
GetValueFromDatabase(coverSupply, reader);
}
reader.Close();
connection.Close();
return(coverSupply);
}
public CoverSupply GetNextSupplyNo()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT TOP 1 * FROM tbl_coverSupply ORDER BY id DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
CoverSupply coverSupply = new CoverSupply();
while (reader.Read())
{
coverSupply.CoverSupplyId = int.Parse(reader["id"].ToString());
coverSupply.SupplyNo = reader["supply_no"].ToString();
}
reader.Close();
connection.Close();
return(coverSupply);
}
private string LoadNextSupplyNo()
{
CoverSupply coverSupply = coverSupplyManager.GetNextSupplyNo();
string supNo = coverSupply.SupplyNo;
int count;
if (supNo == null)
{
count = 1;
}
else
{
count = (supNo[6] - '0') * 10 + (supNo[7] - '0') + 1;
}
string nextSupplyNo = "Supp-0" + count.ToString("00");
return(nextSupplyNo);
}
public List <CoverSupply> GetAllCoverSupply()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_coverSupply";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <CoverSupply> coverSupplyList = new List <CoverSupply>();
while (reader.Read())
{
CoverSupply coverSupply = new CoverSupply();
GetValueFromDatabase(coverSupply, reader);
coverSupplyList.Add(coverSupply);
}
reader.Close();
connection.Close();
return(coverSupplyList);
}
protected void saveButton_Click(object sender, EventArgs e)
{
CoverSupply coverSupply = new CoverSupply();
coverSupply.Date = dateTextBox.Value;
coverSupply.SupplyNo = supplyNoTextBox.Text;
coverSupply.BinderId = int.Parse(binderNameDropDownList.SelectedValue);
coverSupply.GroupId = int.Parse(groupNameDropDownList.SelectedValue);
coverSupply.BookId = int.Parse(bookNameDropDownList.SelectedValue);
string quantity = quantityTextBox.Text;
if (dateTextBox.Value == "" || supplyNoTextBox.Text == "" || quantityTextBox.Text == "")
{
messageLabel.InnerText = "Saved Successfully!!";
}
else
{
coverSupply.Quantity = Convert.ToDouble(quantity);
messageLabel.InnerText = coverSupplyManager.Save(coverSupply);
}
ClearTextBoxes();
}
