protected void SaveButton_Click(object sender, ImageClickEventArgs e)
{
if (hidMode.Value == "Update")
{
#region Update Value
string _WhereClause = "LocID ='" + txtSearchCode.Text.ToString().Trim() + "'";
string _ColumnValues = "LocName='" + txtSearchName.Text.ToString().Trim() +
"',LocAdress1='" + txtAddress1.Text.ToString().Trim().Replace("'", "''") +
"',LocAdress2='" + txtAddress2.Text.ToString().Trim().Replace("'", "''") +
"',LocCity='" + txtCity.Text.ToString().Trim().Replace("'", "''") +
"',LocState='" + ddlState.SelectedValue.ToString().Trim().Replace("'", "''") +
"',LocPostCode='" + txtPostalCode.Text.ToString().Trim().Replace("'", "''") +
"',LocCountry='" + ddlCountry.SelectedValue.ToString().Trim().Replace("'", "''") +
"',LocTimeZone='" + ddlTimeZone.SelectedValue.ToString().Trim().Replace("'", "''") +
"',SrvrTimeZone='" + ddlServerTimeZone.SelectedValue.ToString().Trim().Replace("'", "''") +
"',LocContact='" + txtName.Text.ToString().Trim().Replace("'", "''") +
"',LocPhone='" + txtPhone.Text.ToString().Trim().Replace("'", "''") +
"',LocFax='" + txtFax.Text.ToString().Trim().Replace("'", "''") +
"',LocEmail='" + txtEmail.Text.ToString().Trim().Replace("'", "''") +
"',LocType='" + ddlType.SelectedValue.ToString().Trim() +
"',HubSort='" + txtHubSort.Text.ToString().Trim().Replace("'", "''") +
"',WarehouseInd='" + ddlWarehouse.SelectedValue.ToString().Trim() +
"',IMBranchSort='" + txtBranchSort.Text.ToString().Trim() +
"',IMDisplayColor='" + ddlColor.SelectedValue.ToString().Trim() +
"',ChangeID='" + Session["UserName"].ToString().Trim().Replace("'", "''") + "'," +
" ChangeDt='" + DateTime.Now.ToString() + "'";
locationMaster.UpdateLocationMaster(_ColumnValues, _WhereClause);
BindDataGrid();
DisplaStatusMessage(updateMessage, "Success");
#endregion
}
UpdatePanels();
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
string updateValue = "AckDfltPrinter ='"+ ddlAcknowledgement.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
" CheckDfltPrinter='" + ddlAPCheck.Text.Trim().Replace("'", "''") + "'," +
"BOLDfltPrinter ='"+ ddlBillofLading.Text.Trim().Replace("'", "''") + "'," +
"CInvDfltPrinter ='" + ddlCommercialInvoice.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"DMDfltPrinter ='" + ddlDebitMemo.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"InvDfltPrinter ='" + ddlInvoice.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipDfltPrinter='" + ddlPackingList.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PSHDfltPrinter ='"+ ddlPickSheet.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PSDfltPrinter ='"+ ddlPickSlip.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PriorityShipDfltPrinter ='"+ ddlPriorityShip.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PODfltPrinter ='"+ ddlPurchaseOrder.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"BlindRcvDfltPrinter ='"+ ddlReceiver.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"RmtShipDfltPrinter ='"+ ddlRemoteShip.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipLblDfltPrinter ='"+ ddlShippingLabel.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"StmntDfltPrinter ='"+ ddlStatement.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"WCShipDftlPrinter ='" + ddlWCShip.SelectedItem.Value.Trim().Replace("'", "''") + " '," +
"ChangeID='" + Session["UserName"].ToString().Trim() + "'," +
"ChangeDt='" + DateTime.Now.ToString() + "'";
string whereclause = "LocID=" + LocMasterID;
locationMaster.UpdateLocationMaster(updateValue, whereclause);
}
public string GetFormattedValue(string format, string txtCtrl, string mode, string locID)
{
try
{
LocationMaster locationMstr = new LocationMaster();
string updateValue = "";
string formattedValue = "";
if (mode == "phone")
{
formattedValue = FormatContent(format.Trim(), txtCtrl);
updateValue = "PhoneFmt='" + format.Trim().Replace("'", "''") + "',LocPhone='" + formattedValue;
}
else
{
formattedValue = FormatContent(format.Trim(), txtCtrl);
updateValue = "PostCodeFmt='" + format.Trim().Replace("'", "''") + "',LocPostCode='" + formattedValue;
}
updateValue = updateValue + "'," +
"ChangeID='" + Session["UserName"].ToString().Trim() + "'," +
"ChangeDt='" + DateTime.Now.ToString() + "'";
string whereclause = "LocID=" + locID.Trim();
locationMstr.UpdateLocationMaster(updateValue, whereclause);
return(formattedValue);
}
catch (Exception ex)
{
return("");
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
string updateValue = "CRCheckCd ='" + ddlCreditCheckCode.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"CRDelinqDays ='" + txtDelinquentDays.Text.Trim().Replace("'", "''") + "'," +
"SFZipDigits ='" + txtShipFromLocation.Text.Trim().Replace("'", "''") + "'," +
"ShortCode ='" + txtShortCd.Text.Trim().Replace("'", "''") + "'," +
"CostPctPrice ='" + txtCostpctPrice.Text.Trim().Replace("'", "''") + "'," +
"BigQuoteMinimum = '" + Math.Round(Convert.ToDecimal(txtBigQuoteMin.Text.Trim().Replace("'", "''")), 2) + "'," +
"fTransVendorMasterID =" + ((hidTransferVendor.Value.Trim().Replace("'", "''") == "") ? "null " : "'" + hidTransferVendor.Value.Trim().Replace("'", "''") + "'") + "," +
"fVendorMasterID =" + ((hidDefaultVendor.Value.Trim().Replace("'", "''") == "") ? "null " : "'" + hidDefaultVendor.Value.Trim().Replace("'", "''") + "'") + "," +
"ShipHold1Ind ='" + ddlShipHoldCode.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"AllocTypeCd ='" + ddlAllocationType.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"APCheck ='" + ddlAPChecks.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"BlindRecForm ='" + ddlBlindReceiver.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"BOLForm ='" + ddlBOLForm.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ExpediteCd ='" + ddlFreightExpedite.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"InvForm ='" + ddlInvoiceForm.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"POForm ='" + ddlPOForm.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ItemPromptInd ='" + ddlItemPrompt.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipperForm ='" + ddlShipperForm.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ARStmt ='" + ddlStatement.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"SuppDscPrintInd ='" + ddlSuppDescPrint.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"VendorPOInd ='" + ddlVendorPO.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"USDutyCalcReq ='" + ddlDutyCalc.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"CostCtrInd ='" + ((chkSelection.Items[0].Selected == true) ? "Y" : "N") + "'," +
"TransferInd ='" + ((chkSelection.Items[1].Selected == true) ? "Y" : "N") + "'," +
"PrmptReasonCd ='" + ((chkSelection.Items[2].Selected == true) ? "Y" : "N") + "'," +
"SOEDetailItemInd ='" + ((chkSelection.Items[3].Selected == true) ? "Y" : "N") + "'," +
"GroupPricingInd ='" + ((chkSelection.Items[4].Selected == true) ? "Y" : "N") + "'," +
"SODupItemsInd ='" + ((chkSelection.Items[5].Selected == true) ? "Y" : "N") + "'," +
"UseQueuesInd ='" + ((chkSelection.Items[6].Selected == true) ? "Y" : "N") + "'," +
"FtCollectInd ='" + ((chkSelection.Items[7].Selected == true) ? "Y" : "N") + "'," +
"EnterSTInd ='" + ((chkSelection.Items[8].Selected == true) ? "Y" : "N") + "'," +
"ReqPOInd ='" + ((chkSelection.Items[9].Selected == true) ? "Y" : "N") + "'," +
"DimensionInd ='" + ((chkSelection.Items[10].Selected == true) ? "Y" : "N") + "'," +
"UseEDIInd ='" + ((chkSelection.Items[11].Selected == true) ? "Y" : "N") + " '," +
"MaintainIMQtyInd ='" + ((chkSelection.Items[12].Selected == true) ? "Y" : "N") + "'," +
"ReqRequisitionInd ='" + ((chkSelection.Items[13].Selected == true) ? "Y" : "N") + "'," +
//"VendorPOInd ='" + ((chkSelection.Items[14].Selected == true) ? "Y" : "N") + "'," +
"SODisplayProd ='" + ((chkSelection.Items[14].Selected == true) ? "Y" : "N") + "'," +
"AllowSplitEDI ='" + ((chkSelection.Items[15].Selected == true) ? "1" : "0") + "'," +
"ChangeID ='" + Session["UserName"].ToString().Trim() + "'," +
"ChangeDt ='" + DateTime.Now.ToString() + "'";
string whereclause = "LocID=" + LocMasterID;
locationMaster.UpdateLocationMaster(updateValue, whereclause);
txtBigQuoteMin.Text = Convert.ToString(Math.Round(Convert.ToDecimal(txtBigQuoteMin.Text.Trim().Replace("'", "''")), 2));
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
string updateValue = "UseASNOdomInd ='" + ddlASNOdometer.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"CreateLPNPrmptInd ='" + ddlCreateLPN.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"EndCrtnDocsInd ='"+ ddlEndCartonDocs.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"InvoicePrintInd ='"+ ddlInvoicePrint.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"LotTrackInd ='"+ ddlLotTrack.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PackSlipPrintInd ='"+ ddlPackingSlipPrint.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PalletInd ='"+ ddlPallet.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PickEndInd ='"+ ddlPickEndOrder.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"PrmptBinInd ='"+ ddlPromptRecBin.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ReceivingMode ='" + ddlReceiveMode.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ReformToItemInd ='"+ ddlReformtoItem.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"RFPrintInd ='"+ ddlRFPrint.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ROPDays ='"+ txtROPDays.Text.Trim().Replace("'", "''") + "'," +
"SerialNoInd ='" + ddlSerial.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"SerialNoPrintInd ='"+ ddlSerialPrint.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShippedOrderInd ='"+ ddlShippedOrder.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipLabel ='" + ddlShippingLabel.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipMethCd ='"+ ddlShippingMethod.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ShipModuleInd ='" + ddlShippingModule.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"SupportRepInd ='"+ ddlSupportRep.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ILTStartTransInd='" + ddlTransactionSet.SelectedItem.Value.Trim().Replace("'", "''") + "'," +
"ComplItemShipInd ='" + ((chkSelection.Items[0].Selected == true) ? "Y" : "N") + "'," +
"ILTBatchControlInd='" + ((chkSelection.Items[1].Selected == true) ? "Y" : "N") + "'," +
"ActivatePhyInd='" + ((chkSelection.Items[2].Selected == true) ? "Y" : "N") + "'," +
"UseOdomInd ='"+ ((chkSelection.Items[3].Selected == true) ? "Y" : "N") + "'," +
"DefaultBinInd ='" + ((chkSelection.Items[4].Selected == true) ? "Y" : "N") + "'," +
"LPNControlInd='" + ((chkSelection.Items[5].Selected == true) ? "Y" : "N") + "'," +
"CartonPrintInd='" + ((chkSelection.Items[6].Selected == true) ? "Y" : "N") + "'," +
"AllowPartialRcptsInd='" + ((chkSelection.Items[7].Selected == true) ? "Y" : "N") + "'," +
"DefaultItemInd ='" + ((chkSelection.Items[8].Selected == true) ? "Y" : "N") + "'," +
"MoveDocPromptInd='" + ((chkSelection.Items[9].Selected == true) ? "Y" : "N") + "'," +
"ShipConfirmInd='" + ((chkSelection.Items[10].Selected == true) ? "Y" : "N") + "'," +
"UseScaleInd='" + ((chkSelection.Items[11].Selected == true) ? "Y" : "N") + "'," +
"UseDefltSellStkUMInd ='" + ((chkSelection.Items[12].Selected == true) ? "Y" : "N") + "'," +
"MultiUMInd='" + ((chkSelection.Items[13].Selected == true) ? "Y" : "N") + "'," +
"ShipInFullInd='" + ((chkSelection.Items[14].Selected == true) ? "Y" : "N") + "'," +
"DefaultFromBinInd ='" + ((chkSelection.Items[15].Selected == true) ? "Y" : "N") + "'," +
"VirtualLocationName ='" + txtVLocName.Text.Trim().Replace("'", "''") + "'," +
"VirtualLocationNo ='" + txtVLocNo.Text.Trim().Replace("'", "''") + "'," +
"VirtualBinZone ='" + txtVLocZone.Text.Trim().Replace("'", "''") + "'," +
"ChangeID='" + Session["UserName"].ToString().Trim() + "'," +
"ChangeDt='" + DateTime.Now.ToString() + "'";
string whereclause = "LocID=" + LocMasterID;
locationMaster.UpdateLocationMaster(updateValue, whereclause);
}
