public string Save(PaperTransfer paperTransfer)
{
if (paperTransferGateway.Insert(paperTransfer) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save data in Database!!");
}
public int Insert(PaperTransfer paperTransfer)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_paperTransfer VALUES('" + paperTransfer.Date + "','" +
paperTransfer.TransferNo + "','" + paperTransfer.FromPressId + "','" + paperTransfer.ToPressId + "','" + paperTransfer.PaperId +
"','" + paperTransfer.PaperType + "','" + paperTransfer.Quantity + "')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public PaperTransfer GetNextTransferNo()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT TOP 1 * FROM tbl_paperTransfer ORDER BY id DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
PaperTransfer paperTransfer = new PaperTransfer();
while (reader.Read())
{
paperTransfer.PaperTransferId = int.Parse(reader["id"].ToString());
paperTransfer.TransferNo = reader["transfer_no"].ToString();
}
reader.Close();
connection.Close();
return(paperTransfer);
}
private string LoadNextTransferNo()
{
PaperTransfer paperTransfer = paperTransferManager.GetNextTransferNo();
string transferNo = paperTransfer.TransferNo;
int count;
if (transferNo == null)
{
count = 1;
}
else
{
count = (transferNo[4] - '0') * 10 + (transferNo[5] - '0') + 1;
}
string nextTransferNo = "Tr-0" + count.ToString("00");
return(nextTransferNo);
}
protected void saveButton_Click(object sender, EventArgs e)
{
PaperTransfer paperTransfer = new PaperTransfer();
paperTransfer.Date = dateTextBox.Value;
paperTransfer.TransferNo = transferNoTextBox.Text;
paperTransfer.FromPressId = int.Parse(fromPressNameDropDownList.SelectedValue);
paperTransfer.ToPressId = int.Parse(toPressNameDropDownList.SelectedValue);
paperTransfer.PaperId = int.Parse(paperNameDropDownList.SelectedValue);
paperTransfer.PaperType = paperTypeDropDownList.SelectedValue;
string quantity = quantityTextBox.Text;
if (dateTextBox.Value == "" || transferNoTextBox.Text == "" || paperTypeDropDownList.Text == "" ||
quantityTextBox.Text == "")
{
messageLabel.InnerText = "All Fields are Required!!";
}
else
{
paperTransfer.Quantity = Convert.ToDouble(quantity);
messageLabel.InnerText = paperTransferManager.Save(paperTransfer);
}
ClearTextBoxes();
}
