protected void btnNewRevision_Click(object sender, EventArgs e) { Procurement_CTableAdapters.VIEW_LATEST_BATCH_PLAN_REVTableAdapter batch_rev = new Procurement_CTableAdapters.VIEW_LATEST_BATCH_PLAN_REVTableAdapter(); try { string uname = Session["USER_NAME"].ToString().ToUpper(); string user_id = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'"); string batch_id = WebTools.GetExpr("BATCH_ID", "PIP_PO_BATCH_PLAN", " WHERE PO_ID='" + ddlPOList.SelectedValue + "' AND BATCH_NO='" + txtRevBatchNo.Text + "'"); if (batch_id == "" || batch_id == string.Empty) { RadWindowManager1.RadAlert("Please Create Batch First", 400, 150, "Warning", ""); return; } batch_rev.InsertQuery(decimal.Parse(batch_id), decimal.Parse(txtRevNo.Text), txtRevCreateDate.SelectedDate, decimal.Parse(user_id), txtPIMInitial.SelectedDate, txtPIMForecast.SelectedDate, txtPIMActual.SelectedDate, txtManuIntial.SelectedDate, txtManuForecast.SelectedDate, txtManuActual.SelectedDate, txtFATInitial.SelectedDate, txtFATForecast.SelectedDate, txtFATActual.SelectedDate, txtDeliveryBase.SelectedDate, txtDeliveryForecast.SelectedDate, txtDeliveryActual.SelectedDate, txtReceivedExworksInitial.SelectedDate, txtReceivedExworksForecast.SelectedDate, txtReceivedExworksActual.SelectedDate, txtReceivedPortInitial.SelectedDate, txtReceivedPortForecast.SelectedDate, txtReceivedPortActual.SelectedDate, txtReceivedSiteInitial.SelectedDate, txtReceivedSiteForecast.SelectedDate, txtReceivedSiteActual.SelectedDate, txtRevRemarks.Text, ddlRevStatus.SelectedText); Master.show_success("Batch No " + txtBatchNo.Text + "Revision Created Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } finally { batch_rev.Dispose(); GC.Collect(); } }
protected void btnSave_Click(object sender, EventArgs e) { Procurement_CTableAdapters.VIEW_LATEST_BATCH_PLAN_REVTableAdapter batch_rev = new Procurement_CTableAdapters.VIEW_LATEST_BATCH_PLAN_REVTableAdapter(); try { string uname = Session["USER_NAME"].ToString().ToUpper(); string user_id = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'"); batch_rev.InsertQuery(decimal.Parse(Request.QueryString["BATCH_ID"]), decimal.Parse(txtRevNo.Text), txtCreateDate.SelectedDate, decimal.Parse(user_id), txtPIMInitial.SelectedDate, txtPIMForecast.SelectedDate, txtPIMActual.SelectedDate, txtManuIntial.SelectedDate, txtManuForecast.SelectedDate, txtManuActual.SelectedDate, txtFATInitial.SelectedDate, txtFATForecast.SelectedDate, txtFATActual.SelectedDate, txtDeliveryBase.SelectedDate, txtDeliveryForecast.SelectedDate, txtDeliveryActual.SelectedDate, txtReceivedExworksInitial.SelectedDate, txtReceivedExworksForecast.SelectedDate, txtReceivedExworksActual.SelectedDate, txtReceivedPortInitial.SelectedDate, txtReceivedPortForecast.SelectedDate, txtReceivedPortActual.SelectedDate, txtReceivedSiteInitial.SelectedDate, txtReceivedSiteForecast.SelectedDate, txtReceivedSiteActual.SelectedDate, txtRevRemarks.Text, ddlRevStatus.SelectedText); Master.show_success("Batch No " + txtBatchNo.Text + "Revision Created Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } finally { batch_rev.Dispose(); GC.Collect(); } }