public string insertRR(ReceiveOrdersFinger drsi) { string Message = string.Empty; int result = 0; SqlTransaction transaction; con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].ReceiveOrdersFingerlings ([SupplierID],[CreatedById],[CreationDate],[IsCompleted],[IsSubmitted],[IsNew],[PurchaseOrderID],DateofShipment ,DateofArrival ,DateReceive ,TimeofShipment ,TimeofArrival ,TimeReceive ,ReoxygenationStart ,ReoxygenationEnd ,SalinityInsideTheBag ,TemperatureInsideTheBag ,TimeAfterReceiptFromAirport ,Mortality ,TimeofArrival1 ,TimeofStocking ,Mortality1 ,Deformed ,Injured ,Missing ) VALUES (@SupplierID,@CreatedById,getdate(),@IsCompleted,@IsSubmitted,@IsNew,@PurchaseOrderID,@DateofShipment ,@DateofArrival ,@DateReceive ,@TimeofShipment ,@TimeofArrival ,@TimeReceive ,@ReoxygenationStart ,@ReoxygenationEnd ,@SalinityInsideTheBag ,@TemperatureInsideTheBag ,@TimeAfterReceiptFromAirport ,@Mortality ,@TimeofArrival1 ,@TimeofStocking ,@Mortality1 ,@Deformed ,@Injured ,@Missing )", con); //cmd.CommandText = "InsertRR"; cmd.Parameters.AddWithValue("@SupplierID", drsi.SupplierID); cmd.Parameters.AddWithValue("@CreatedById", drsi.CreatedById); //cmd.Parameters.AddWithValue("@ExpectedDate", drsi.ExpectedDate); //cmd.Parameters.AddWithValue("@PaymentAmount", drsi.PaymentAmount); cmd.Parameters.AddWithValue("@IsCompleted", 1); cmd.Parameters.AddWithValue("@IsSubmitted", 1); cmd.Parameters.AddWithValue("@IsNew", 1); cmd.Parameters.AddWithValue("@PurchaseOrderID", drsi.PurchaseOrderID); cmd.Parameters.AddWithValue("@DateofShipment", drsi.DateofShipment); cmd.Parameters.AddWithValue("@DateofArrival", drsi.DateofArrival); cmd.Parameters.AddWithValue("@DateReceive", drsi.DateReceive); cmd.Parameters.AddWithValue("@TimeofShipment ", drsi.TimeofShipment); cmd.Parameters.AddWithValue("@TimeofArrival", drsi.TimeofArrival); cmd.Parameters.AddWithValue("@TimeReceive", drsi.TimeReceive); cmd.Parameters.AddWithValue("@ReoxygenationStart", drsi.ReoxygenationStart); cmd.Parameters.AddWithValue("@ReoxygenationEnd", drsi.ReoxygenationEnd); cmd.Parameters.AddWithValue("@SalinityInsideTheBag", drsi.SalinityInsideTheBag); cmd.Parameters.AddWithValue("@TemperatureInsideTheBag", drsi.TemperatureInsideTheBag); cmd.Parameters.AddWithValue("@TimeAfterReceiptFromAirport", drsi.TimeAfterReceiptFromAirport); cmd.Parameters.AddWithValue("@Mortality", drsi.Mortality); cmd.Parameters.AddWithValue("@TimeofArrival1", drsi.TimeofArrival1); cmd.Parameters.AddWithValue("@TimeofStocking", drsi.TimeofStocking); cmd.Parameters.AddWithValue("@Mortality1", drsi.Mortality1); cmd.Parameters.AddWithValue("@Deformed", drsi.Deformed); cmd.Parameters.AddWithValue("@Injured", drsi.Injured); cmd.Parameters.AddWithValue("@Missing", drsi.Missing); transaction = con.BeginTransaction(); cmd.Transaction = transaction; //cmd.Parameters.AddWithValue("@OrderBy", drsi.OrderBy); //cmd.Parameters.AddWithValue("@CheckBy", drsi.CheckBy != null ? drsi.CheckBy : string.Empty); try { result = cmd.ExecuteNonQuery(); transaction.Commit(); } catch (Exception ex) { try { transaction.Rollback(); } catch (Exception ex2) { // This catch block will handle any errors that may have occurred // on the server that would cause the rollback to fail, such as // a closed connection. Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType()); Console.WriteLine(" Message: {0}", ex2.Message); } } string query = "select top 1 ID from [ReceiveOrdersFingerlings] order by id desc"; DataTable dt = new DataTable("Customer"); dt.Clear(); dt = DataAccess.DBAdapter.GetRecordSet(query); if (dt.Rows.Count > 0) { Message = dt.Rows[0]["ID"].ToString(); } con.Close(); return Message; }
protected void btnSave1_Click(object sender, EventArgs e) { dtgridList = (DataTable)ViewState["dtgridList"]; dtgridList1 = (DataTable)ViewState["dtgridList1"]; string users = Session["id"].ToString(); decimal totalamt = 0; try { FrameWork.ReceiveOrdersFinger RRO = new FrameWork.ReceiveOrdersFinger(); FrameWork.ReceiveOrdersFingerDetails PROsub = new ReceiveOrdersFingerDetails(); FrameWork.ReceiveOrdersFingerDetails2 PROsub2 = new ReceiveOrdersFingerDetails2(); busReceivedOrderFingerLings busPRO = new busReceivedOrderFingerLings(); RRO.SupplierID = int.Parse(this.drpSupplier.SelectedValue); RRO.CreatedById = int.Parse(users); RRO.PurchaseOrderID = int.Parse(this.txtPro.Text); RRO.DateofShipment =DateTime.Parse (this.txtDateShipment.Text); RRO.DateofArrival = DateTime.Parse(this.txtDateArrival.Text); RRO.DateReceive = DateTime.Parse(this.txtDateReceive.Text); RRO.TimeofShipment = DateTime.Parse(this.txtTimeShipment.Text).TimeOfDay; RRO.TimeofArrival = DateTime.Parse(this.txtTimeArrival.Text).TimeOfDay; RRO.TimeReceive = DateTime.Parse(this.txtTimeReceive.Text).TimeOfDay; RRO.ReoxygenationStart = DateTime.Parse(this.txtReoxygen.Text).TimeOfDay; RRO.ReoxygenationEnd = DateTime.Parse(this.txtFinish.Text).TimeOfDay; RRO.SalinityInsideTheBag =int.Parse(this.txtSalinity.Text); RRO.TemperatureInsideTheBag = int.Parse(this.txtTemp.Text); RRO.TimeAfterReceiptFromAirport = DateTime.Parse(this.txtTimeReceiveAirport.Text).TimeOfDay; RRO.Mortality = int.Parse(this.txtMortality.Text); RRO.TimeofArrival1 = DateTime.Parse(this.txtTimeArrival1.Text).TimeOfDay; RRO.TimeofStocking = DateTime.Parse(this.txtTimeStocking.Text).TimeOfDay; RRO.Mortality1 = int.Parse(this.txtMortality1.Text); RRO.Deformed = int.Parse(this.txtDeformed.Text); RRO.Injured = int.Parse(this.txtInjured.Text); RRO.Missing = int.Parse(this.txtMissing.Text); string x = busPRO.insertRR(RRO); foreach (DataRow dr in dtgridList.Rows) { PROsub.ReceiveOrderID = int.Parse(x); PROsub.Quantity = Single.Parse(dr["Quantity"].ToString()); PROsub.ProductID = int.Parse(dr["ProductID"].ToString()); busPRO.insertReceiveOrderDetails(PROsub); } foreach (DataRow dr1 in dtgridList1.Rows) { PROsub2.ReceiveOrderID = int.Parse(x); PROsub2.ModuleNum = int.Parse(dr1["ModuleNum"].ToString()); PROsub2.CageNum = int.Parse(dr1["CageNum"].ToString()); PROsub2.Salinity = int.Parse(dr1["Salinity"].ToString()); PROsub2.Temp = int.Parse(dr1["Temp"].ToString()); busPRO.insertReceiveOrderDetails2(PROsub2); } } catch (Exception ex) { } finally { this.txtQuantity.Text = string.Empty; this.txtUOM.Text = string.Empty; this.drpProduct.SelectedValue = "0"; this.lblDescription.Text = string.Empty; //this.txtUnitPrice.Text = string.Empty; this.drpSupplier.SelectedValue = "0"; // this.txtTerms.Text = string.Empty; DataTable ds = new DataTable(); ds = null; this.grdList.DataSource = ds; grdList.DataBind(); } }