public static string AjaxSendToIU(string remarks,string submissionID, string versionNo, string importID,string valuationID) { //string returnValue = ""; ValuationHeader valHeader = new ValuationHeader(); Valuation val = new Valuation(); try { valHeader.setSubmission(Convert.ToInt32(submissionID)); valHeader.PartitionDate = valHeaderPartittionDate; valHeader.ImportID = Convert.ToInt32(importID); valHeader.VersionNo = Convert.ToInt16(versionNo); valHeader.Remarks = remarks; valHeader.setValuationID(Convert.ToInt32(valuationID)); if (valHeader.SendToIU(Convert.ToInt16(GlobalFunctions.gLoginUserCode), remarks)) { val.errorMessage = "Saved"; } else { val.errorMessage = "Error"; } } catch(Exception ex) { val.errorMessage = ex.Message.ToString(); } return val.errorMessage; }
public bool SaveValuationItemsApplyToSel(string AssessedFreight, string assessedInsurance, string ValuationMethod, string TransID, string itemID, string DeclaredUnitFOB, string AssessedUnitFOB, string ValuationNotes) { Nullable<Decimal> AssFreight; Nullable<Decimal> AssInsurance; valHeader = new ValuationHeader(); //valItem = new ValuationItems(); if (AssessedFreight.Trim().Length == 0) AssFreight = null; else AssFreight = System.Convert.ToDecimal(AssessedFreight); if (assessedInsurance.Trim().Length == 0) AssInsurance = null; else AssInsurance = System.Convert.ToDecimal(assessedInsurance); if (ValuationMethod == null) { errorMessage = "Please, Select Valuation Method for Apply to Selection"; return false; } if (!((Convert.ToInt16(ValuationMethod) == 852) || (Convert.ToInt16(ValuationMethod) == 854))) { errorMessage = "Valuation Method not Allowed for Apply to Selection"; return false; } // if (MessageBox.Show("Are you sure you want to Apply to All?", "Confirm Apply to Selection", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) //{ try { valHeader.setValuationID(ValuationID); if (valHeader.ValuationID == null || valHeader.ValuationID == 0) { valHeader.ImportID = _ImportID; valHeader.PartitionDate = valHeaderPartittionDate; valHeader.FreightAssessed = AssFreight; valHeader.InsAssessed = AssInsurance; valHeader.Status = 1; valHeader.Pulled = false; valHeader.DraftUserID = GlobalFunctions.gLoginUserCode; valHeader.Create(GlobalFunctions.gLoginUserCode); } //foreach (DataGridViewRow row in dgvLineItems.SelectedRows) // { valItem = new ValuationItems(); if (string.IsNullOrEmpty(TransID.ToString().Trim())) { valItem.ValuationID = valHeader.ValuationID; valItem.ItemID = Convert.ToInt32(itemID); valItem.PartitionDate = valHeaderPartittionDate; valItem.ValMethod = System.Convert.ToInt32(ValuationMethod); valItem.AssessedUnitFOB = System.Convert.ToDecimal(DeclaredUnitFOB); valItem.DraftUserID = GlobalFunctions.gLoginUserCode; valItem.Notes = ValuationNotes; valItem.Create(GlobalFunctions.gLoginUserCode); //row.Cells["TransID"].Value = valItem.TransID; errorMessage = valItem.TransID.ToString(); } else { valItem.TransID = Convert.ToInt32(TransID); valItem.ValuationID = valHeader.ValuationID; valItem.ItemID = Convert.ToInt32(itemID); valItem.PartitionDate = valHeaderPartittionDate; valItem.ValMethod = System.Convert.ToInt32(ValuationMethod); valItem.AssessedUnitFOB = System.Convert.ToDecimal(AssessedUnitFOB); valItem.DraftUserID = GlobalFunctions.gLoginUserCode; valItem.Notes = ValuationNotes; valItem.Update(GlobalFunctions.gLoginUserCode); errorMessage = valItem.TransID.ToString(); } // Update row here //row.Cells["ValMethod"].Value = cboValMethod.SelectedValue; //row.Cells["ValuationNotes"].Value = txtValNotes.Text; //row.Cells["AssessedUnitFOB"].Value = row.Cells["DeclUnitFOB"].Value; // } // Compute Total Assessed FOB and Total Assessed Value //ComputeTotalAssessedFOBandValue(); //Move to first item //dgvLineItems.CurrentCell = dgvLineItems.Rows[0].Cells["LineNo"]; return true; } catch (Exception ex) { errorMessage = ex.ToString() + "\n Could not Accept All Declared Values"; return false; } // } return false; }
//Button EventButtonRegister; protected void Page_Load(object sender, EventArgs e) { //EventButtonRegister.Click += new EventHandler(ButtonRegister_click); // does work //LabelErrorMsg.Text = "true"; if (IsPostBack) { //Button btn = (Button)sender; //EventButtonRegister.Click += new EventHandler(ButtonRegister_click); // does not work // LabelErrorMsg.Text = sender.ToString();// +btn.Text; } if (Request.QueryString["importid"] != null && Request.QueryString["versionNo"] != null) { _ImportID = Convert.ToInt64(Request.QueryString["importid"].ToString()); _VersionNo = Convert.ToInt16(Request.QueryString["versionNo"].ToString()); //GlobalFunctions.gLoginUserCode = Convert.ToInt16(Session["genFlux_login_UCode"].ToString()); //Query List } else { Response.Redirect("ValuationQueue.aspx"); } GlobalFunctions.ExecAndFillDataset("spGCICGetValuationMethods", GlobalFunctions.Initials, "ValuationMethods"); //DropDownListValMethod.DataSource = GlobalFunctions.ValuationMethodsDS("spGCICGetValuationMethods", "ValuationMethods"); DropDownListValMethod.DataSource = GlobalFunctions.Initials.Tables["ValuationMethods"]; DropDownListValMethod.DataTextField = "MethodName"; DropDownListValMethod.DataValueField = "MethodID"; DropDownListValMethod.DataBind(); DropDownListValMethod.SelectedIndex = -1; GlobalFunctions.ExecAndFillDataset("spGCICGetQueryType", GlobalFunctions.Initials, "QueryType"); DropDownListQuery.DataSource = GlobalFunctions.Initials.Tables["QueryType"]; DropDownListQuery.DataTextField = "QueryTypeDesc"; DropDownListQuery.DataValueField = "QueryTypeID"; DropDownListQuery.DataBind(); DropDownListQuery.SelectedIndex = -1; if (_ImportID > 0) { valHeader = new ValuationHeader(_ImportID, _VersionNo); PopulateData(); TextBoximportID.Text = _ImportID.ToString(); try { }catch(Exception ez) { } //LabelErrorMsg.Text += valHeader.Status.ToString();!string.IsNullOrEmpty(valHeader.Status.ToString()) || CalAssInsurance(); ComputeTotalAssessedFOBandValue(); ComputeItemsFreightInsPOR(); } //if (valHeader.Status == 1 || valHeader.Status == 2 || valHeader.Status == 4 || valHeader.Status == null) { Response.Redirect("ValuationQueue.aspx"); /*LabelErrorMsg.Text ="Inside "+ valHeader.Status.ToString();*/ } switch(valHeader.Status) { case null: // Drafting If a file status does not fall under any of the category send the user back to the Queue DeptPriorStatus = 0; break; case 1: // Drafting case 2: // Supervisor case 4:// RollBack DeptPriorStatus = (int)valHeader.Status; break; default: Response.Redirect("ValuationQueue.aspx"); break; } }
public static string ValuationSave(string ValuationMethod,string DeclaredUnitFOB,string AssessedUnitFOB, string AssessedFreight, string itemID, string assessedInsurance, string Remarks,string importID, string VersionNo,string TransID, string DeclareQuantity) { Valuation val = new Valuation(); ValuationHeader valHeader = new ValuationHeader(); ValuationItems valItem = new ValuationItems(); // string errorMessage = ""; try { // valHeader.ValuationID = ValuationID; valHeader.setValuationID(ValuationID); //GlobalFunctions.gLoginUserCode = Convert.ToInt16(Session["genFlux_login_UCode"].ToString()); if (val.SaveValidate(ValuationMethod, AssessedUnitFOB, DeclaredUnitFOB)) { long selectedItem; int dRowIndex; Nullable<Decimal> AssFreight; Nullable<Decimal> AssInsurance; //DataGridViewRow row = dgvLineItems.CurrentRow; selectedItem = Convert.ToInt32(itemID); //dRowIndex = row.Index; if (AssessedFreight.Length == 0) AssFreight = null; else AssFreight = System.Convert.ToDecimal(AssessedFreight); if (assessedInsurance.Length == 0) AssInsurance = null; else AssInsurance = System.Convert.ToDecimal(assessedInsurance); valHeader.Pulled = Pulled; valHeader.Status = Status; valHeader.ImportID = Convert.ToInt32(importID); valHeader.VersionNo = Convert.ToInt32(VersionNo); valHeader.FreightAssessed = AssFreight; valHeader.InsAssessed = AssInsurance; if (valHeader.ValuationID == null || valHeader.ValuationID == 0) { valHeader.ImportID = Convert.ToInt32(importID); valHeader.PartitionDate = valHeaderPartittionDate; valHeader.Status = 1; valHeader.Pulled = false; valHeader.Remarks = Remarks; valHeader.DraftUserID = GlobalFunctions.gLoginUserCode; valHeader.VersionNo = Convert.ToInt16(VersionNo); valHeader.Create(GlobalFunctions.gLoginUserCode) ; } else { //if (valHeader.FreightAssessed != AssFreight || (valHeader.InsAssessed != AssInsurance)) //{ //valHeader.FreightAssessed = AssFreight; //valHeader.InsAssessed = AssInsurance; //} valHeader.Remarks = Remarks; valHeader.Update(GlobalFunctions.gLoginUserCode); } valItem.VersionNo = Convert.ToInt16(VersionNo); if (string.IsNullOrEmpty(TransID.ToString().Trim())) { valItem.ValuationID = valHeader.ValuationID; valItem.ItemID = selectedItem; valItem.PartitionDate = valHeaderPartittionDate; valItem.ValMethod = System.Convert.ToInt32(ValuationMethod); if ((Convert.ToInt16(ValuationMethod) == 852/*Val Method 1*/) || (Convert.ToInt16(ValuationMethod) == 854 /*Val Method 1D*/)) { valItem.AssessedUnitFOB = System.Convert.ToDecimal(DeclaredUnitFOB); //val.errorMessage = "ValItem Save"; } else { valItem.AssessedUnitFOB = System.Convert.ToDecimal(AssessedUnitFOB); //val.errorMessage = "ValItem Save Not"; } valItem.DraftUserID = GlobalFunctions.gLoginUserCode; //valItem.Notes = txtValNotes.Text; valItem.Create(GlobalFunctions.gLoginUserCode); //row.Cells["TransID"].Value = valItem.TransID; val.errorMessage = valItem.TransID.ToString(); } else { valItem.TransID = Convert.ToInt32(TransID); valItem.ValuationID = valHeader.ValuationID; valItem.ItemID = selectedItem; valItem.PartitionDate = valHeaderPartittionDate; valItem.ValMethod = System.Convert.ToInt16(ValuationMethod); if ((Convert.ToInt16(ValuationMethod) == 852/*Val Method 1*/) || (Convert.ToInt16(ValuationMethod) == 854)) { valItem.AssessedUnitFOB = System.Convert.ToDecimal(DeclaredUnitFOB); val.errorMessage = "ValItem Update"; } else { valItem.AssessedUnitFOB = System.Convert.ToDecimal(AssessedUnitFOB); val.errorMessage = "ValItem Update"; } valItem.DraftUserID = GlobalFunctions.gLoginUserCode; // valItem.Notes = txtValNotes.Text; valItem.Update(GlobalFunctions.gLoginUserCode); val.errorMessage = valItem.TransID.ToString(); } // Update row here Decimal AssUnitFOB = (AssessedUnitFOB.Trim().Length == 0 ? 0 : System.Convert.ToDecimal(AssessedUnitFOB)); Decimal Qty = (DeclareQuantity.Trim().Length == 0 ? 0 : System.Convert.ToDecimal(DeclareQuantity)); Decimal AssFOB = AssUnitFOB * Qty; /* row.Cells["ValMethod"].Value = cboValMethod.SelectedValue; row.Cells["ValuationNotes"].Value = txtValNotes.Text; row.Cells["AssessedUnitFOB"].Value = valItem.AssessedUnitFOB.Value; dgvLineItems.UpdateCellValue(row.Cells["AssessedUnitFOB"].ColumnIndex, row.Cells["AssessedUnitFOB"].RowIndex); // Compute Total Assessed FOB and Total Assessed Value ComputeTotalAssessedFOBandValue(); // Move to next row available if (dRowIndex < dgvLineItems.Rows.Count - 1) { //dgvLineItems.CurrentCell = dgvLineItems.Rows[dRowIndex + 1].Cells["LineNo"]; } */ //val.errorMessage = "Saved".Trim(); //Debug: val.errorMessage = "ValMethod=> " + valItem.ValMethod + " DeclUnitFOB =>" + DeclaredUnitFOB + " AssessedUnitFOB=>" + valItem.AssessedUnitFOB + " AssFriehgt=> " + valHeader.FreightAssessed + " ItemID=>" + valItem.ItemID + " AssInsurance=>" + valHeader.InsAssessed + " Remarks=>" + valHeader.Remarks + " ImportID=>" + valHeader.ImportID + " VersionNo=>" + valHeader.VersionNo + " TransID=>" + valItem.TransID + " Valitem.ValID=>" + valItem.ValuationID + " User=>" + GlobalFunctions.gLoginUserCode + "error =>" + val.errorMessage; //val.populateGrid(); } //errorMessage = "ValMethod=> " + ValuationMethod + " DeclUnitFOB =>" + DeclaredUnitFOB + " AssessedUnitFOB=>" + AssessedUnitFOB + " AssFriehgt=> " + AssessedFreight + " ItemID=>" + itemID + " AssInsurance=>" + assessedInsurance + " Remarks=>" + Remarks + " ImportID=>" + importID + " VersionNo=>" + VersionNo + " TransID=>" + TransID + " DeclQtty=>" + DeclareQuantity + " User=>" + GlobalFunctions.gLoginUserCode; return val.errorMessage; } catch (Exception ex) { val. errorMessage += ex.Message.ToString(); return Status +" "+ val.errorMessage; } }