protected void saveButton_Click(object sender, EventArgs e)
{
BinderReceive binderReceive = new BinderReceive();
binderReceive.Date = dateTextBox.Value;
binderReceive.ReceiveNo = receiveNoTextBox.Text;
binderReceive.BinderId = int.Parse(binderNameDropDownList.SelectedValue);
binderReceive.OrderNo = orderNoTextBox.Text;
binderReceive.ChallanNo = challanNoTextBox.Text;
binderReceive.Year = yearTextBox.Text;
binderReceive.GroupId = int.Parse(groupNameDropDownList.SelectedValue);
binderReceive.BookId = int.Parse(bookNameDropDownList.SelectedValue);
string quantity = quantityTextBox.Text;
if (dateTextBox.Value == "" || receiveNoTextBox.Text == "" || orderNoTextBox.Text == "" ||
challanNoTextBox.Text == "" || yearTextBox.Text == "" || quantityTextBox.Text == "")
{
messageLabel.InnerText = "All Fields are Required!!";
}
else
{
binderReceive.Quantity = Convert.ToDouble(quantity);
messageLabel.InnerText = binderReceiveManager.Save(binderReceive);
}
ClearTextBoxes();
}
protected void firstButton_Click(object sender, EventArgs e)
{
BinderReceive binderReceive = binderReceiveManager.GetBinderReceive(0);
GetData(binderReceive);
Session["active"] = 0;
}
public string Save(BinderReceive binderReceive)
{
if (binderReceiveGateway.Insert(binderReceive) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save Data in Database!!");
}
protected void lastButton_Click(object sender, EventArgs e)
{
List <BinderReceive> binderReceiveList = (List <BinderReceive>)(Session["binderReceive"]);
int x = binderReceiveList.Count - 1;
BinderReceive binderReceive = binderReceiveManager.GetBinderReceive(x);
GetData(binderReceive);
Session["active"] = x;
}
private void GetData(BinderReceive binderReceive)
{
dateTextBox.Value = binderReceive.Date;
receiveNoTextBox.Text = binderReceive.ReceiveNo;
binderNameDropDownList.Text = binderReceive.BinderName;
orderNoTextBox.Text = binderReceive.OrderNo;
challanNoTextBox.Text = binderReceive.ChallanNo;
yearTextBox.Text = binderReceive.Year;
groupNameDropDownList.Text = binderReceive.GroupName;
bookNameDropDownList.Text = binderReceive.BookName;
quantityTextBox.Text = binderReceive.Quantity.ToString();
}
private static void GetValueFromDatabase(BinderReceive binderReceive, SqlDataReader reader)
{
binderReceive.BinderReceiveId = int.Parse(reader["id"].ToString());
binderReceive.Date = reader["date"].ToString();
binderReceive.ReceiveNo = reader["receive_no"].ToString();
binderReceive.BinderName = reader["binder_id"].ToString();
binderReceive.OrderNo = reader["order_no"].ToString();
binderReceive.ChallanNo = reader["challan_no"].ToString();
binderReceive.Year = reader["year"].ToString();
binderReceive.GroupName = reader["group_id"].ToString();
binderReceive.BookName = reader["book_id"].ToString();
binderReceive.Quantity = Convert.ToDouble(reader["quantity"].ToString());
}
public int Insert(BinderReceive binderReceive)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_binderReceive VALUES('" + binderReceive.Date + "','" +
binderReceive.ReceiveNo + "','" + binderReceive.BinderId + "','" + binderReceive.OrderNo +
"','" + binderReceive.ChallanNo + "','" + binderReceive.Year + "','" + binderReceive.GroupId +
"','" + binderReceive.BookId + "','" + binderReceive.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;
BinderReceive binderReceive = binderReceiveManager.GetSearchInfo(r);
if (binderReceive.ReceiveNo == null)
{
message.InnerText = "Invalid Receive No!!";
}
else
{
GetData(binderReceive);
message.InnerText = "";
}
}
protected void previousButton_Click(object sender, EventArgs e)
{
int active = (int)Session["active"];
active--;
List <BinderReceive> binderReceiveList = (List <BinderReceive>)(Session["binderReceive"]);
if (active <= -1)
{
active = binderReceiveList.Count - 1;
}
BinderReceive binderReceive = binderReceiveManager.GetBinderReceive(active);
GetData(binderReceive);
Session["active"] = active;
}
public BinderReceive GetSearchInfo(string s)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_binderReceive WHERE receive_no='" + s + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
BinderReceive binderReceive = new BinderReceive();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GetValueFromDatabase(binderReceive, reader);
}
reader.Close();
connection.Close();
return(binderReceive);
}
public BinderReceive GetBinderReceive(int i)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_binderReceive ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
BinderReceive binderReceive = new BinderReceive();
while (reader.Read())
{
GetValueFromDatabase(binderReceive, reader);
}
reader.Close();
connection.Close();
return(binderReceive);
}
public BinderReceive GetNextReceiveNo()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT TOP 1 * FROM tbl_binderReceive ORDER BY id DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
BinderReceive binderReceive = new BinderReceive();
while (reader.Read())
{
binderReceive.BinderReceiveId = int.Parse(reader["id"].ToString());
binderReceive.ReceiveNo = reader["receive_no"].ToString();
}
reader.Close();
connection.Close();
return(binderReceive);
}
private string LoadNextReceiveNo()
{
BinderReceive binderReceive = binderReceiveManager.GetNextReceiveNo();
string recvNo = binderReceive.ReceiveNo;
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 List <BinderReceive> GetAllBinderReceive()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_binderReceive";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <BinderReceive> binderReceiveList = new List <BinderReceive>();
while (reader.Read())
{
BinderReceive binderReceive = new BinderReceive();
GetValueFromDatabase(binderReceive, reader);
binderReceiveList.Add(binderReceive);
}
reader.Close();
connection.Close();
return(binderReceiveList);
}
