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