public void SetGameController(string scriptName) { GameObject gameControllerObject = GameObject.Find("Main Camera"); if (gameControllerObject != null) { gameController = gameControllerObject.GetComponent(scriptName) as BaseFunctions; } }
public async Task <bool> SaveUserToDB() { if (App.uploadStream != null) { string uploadImage = await UploadImageToServer(); if (uploadImage.ToString() != "false") { currentUser.userImage = uploadImage.ToString(); } } currentUser.userFirstName = FirstName.Text; currentUser.userLastName = LastName.Text; currentUser.userPosition = position.Text; currentUser.userCompany = company.Text; currentUser.userPhone = phone.Text; currentUser.userWebsite = website.Text; currentUser.userAddress = address.Text; currentUser.userDescription = shortBio.Text; currentUser.userGplus = userGPlus.Text; currentUser.userFacebook = userFacebook.Text; currentUser.userCity = city.Text; currentUser.userState = states[state.SelectedIndex]; currentUser.userPostal = postal.Text; currentUser.userLinkedIn = userLinkedIn.Text; currentUser.userTwitter = userTwitter.Text; App.serverData.mei_user.currentUser = currentUser; App.serverData.SaveUserDataToLocal(); if (!string.IsNullOrEmpty(oldImage) && currentUser.userImage != oldImage) { var k = await DeleteOldimage(); Debug.WriteLine("Old Image deletion" + k.ToString()); } return(await BaseFunctions.SaveUserToServer()); }
public ucTesting() { InitializeComponent(); //Display comport BaseFunctions.display_Port_Name(); //Binding data this.border_DUT01.DataContext = GlobalData.testingDataDut1; this.border_DUT02.DataContext = GlobalData.testingDataDut2; this.border_DUT03.DataContext = GlobalData.testingDataDut3; this.border_DUT04.DataContext = GlobalData.testingDataDut4; //this._loadSetting(); //Load setting BaseFunctions.connect_Instrument(); //Connect Instrument timer = new DispatcherTimer(); timer.Interval = new TimeSpan(0, 0, 0, 0, 500); timer.Tick += ((sender, e) => { if (GlobalData.testingDataDut1.BUTTONENABLE == false) { this._dut1scrollViewer.ScrollToEnd(); } if (GlobalData.testingDataDut2.BUTTONENABLE == false) { this._dut2scrollViewer.ScrollToEnd(); } if (GlobalData.testingDataDut3.BUTTONENABLE == false) { this._dut3scrollViewer.ScrollToEnd(); } if (GlobalData.testingDataDut4.BUTTONENABLE == false) { this._dut4scrollViewer.ScrollToEnd(); } }); timer.Start(); }
public async void EmailInvoiceFunction(object sender, EventArgs e) { await((HomeLayout)App.Current.MainPage).SetLoading(true, "Sending email..."); string cardType = await App.serverData.GetTransactionInformation(transaction.transactionID, "trans_cardType"); string card4 = await App.serverData.GetTransactionInformation(transaction.transactionID, "trans_last4"); if (transaction.transactionType == "Sale") { bool sent = await BaseFunctions.EmailSaleInvoice(transaction, cardType + " ending with " + card4); await((HomeLayout)App.Current.MainPage).SetLoading(false, "Sending email..."); if (sent) { await App.Current.MainPage.DisplayAlert("Success", "Invoice has been sent to your email", "Ok"); } else { await App.Current.MainPage.DisplayAlert("Failed", "Something went wrong please retry.", "Ok"); } } else if (transaction.transactionType == "Donation") { bool sent = await BaseFunctions.EmailDonationInvoice(transaction, cardType + " ending with " + card4); await((HomeLayout)App.Current.MainPage).SetLoading(false, "Sending email..."); if (sent) { await App.Current.MainPage.DisplayAlert("Success", "Invoice has been sent to your email", "Ok"); } else { await App.Current.MainPage.DisplayAlert("Failed", "Something went wrong please retry.", "Ok"); } } }
public async void SaveNote(object sender, EventHandler e) { if (currentNote.userNote != noteEditor.Text) { currentNote.userNote = noteEditor.Text; for (int i = 0; i < App.serverData.mei_user.noteList.Count; i++) { if (App.serverData.mei_user.noteList[i].noteID == currentNote.noteID) { var cTime = DateTime.Now; currentNote.noteDateTime = cTime.ToString("MM/dd/yyyy hh:mm:ss tt"); App.serverData.mei_user.noteList[i] = currentNote; await((HomeLayout)App.Current.MainPage).SetLoading(true, "Saving note..."); await BaseFunctions.EditNoteInServer(currentNote); await((HomeLayout)App.Current.MainPage).SetLoading(false, "Deleting note..."); } } } noteEditor.Unfocus(); //if(parentNotes!=null) //parentNotes.SetDetails(); e(this, null); }
public static string createActivationKey(byte pinCheckDigit) { byte[] buffer = BaseFunctions.secureRandom(14); buffer[0] = pinCheckDigit; string str = ""; for (int i = 0; i < buffer.Length; i++) { str += (int)((buffer[i] % 10 < 0) ? (buffer[i] % 10 + 10) : (buffer[i] % 10)); } string s = str.Substring(0, 7); string str2 = str.Substring(7, 7); string str3 = string.Concat(BaseFunctions.calcChecksum(long.Parse(s), 7)); string str4 = string.Concat(BaseFunctions.calcChecksum(long.Parse(str2), 7)); return(string.Concat(new string[] { s, str3, "-", str2, str4 })); }
public PartialViewResult RoleRelatedUsersDelete(string role_id, string id) { GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>(); gnl_roles_related_users role_related_users = new gnl_roles_related_users(); Role model = new Role(); Guid role_uid = Guid.Empty; Guid user_uid = Guid.Empty; if (Guid.TryParse(role_id, out role_uid) && BaseFunctions.getInstance().IsNumeric(id)) { var obj = gnlDB.GetRoleRelatedUsersById(Convert.ToInt32(id)); if (obj != null && obj.Count > 0) { gnlDB.DeleteRoleRelatedUsers(obj[0]); } } List <gnl_role_related_users_v> listRoleRelatedUsers = gnlDB.GetRoleRelatedUsers(role_uid); model.roleRelatedUsers = listRoleRelatedUsers; return(PartialView("RoleRelatedUsers", model)); }
public static string createActivationKey(byte pinCheckDigit) { byte[] array = BaseFunctions.secureRandom(14); array[0] = pinCheckDigit; string text = ""; for (int i = 0; i < array.Length; i++) { text += (int)((array[i] % 10 < 0) ? (array[i] % 10 + 10) : (array[i] % 10)); } string text2 = text.Substring(0, 7); string text3 = text.Substring(7, 7); string text4 = string.Concat(BaseFunctions.calcChecksum(long.Parse(text2), 7)); string text5 = string.Concat(BaseFunctions.calcChecksum(long.Parse(text3), 7)); return(string.Concat(new string[] { text2, text4, "-", text3, text5 })); }
public static long createSequenceNumber() { byte[] array = BaseFunctions.secureRandom(2); return((long)(array[0] * 10 + array[1])); }
public static byte[] createSeed(string pin, string activationKey) { return(HOTPCipherInitialize.derivateKey(BaseFunctions.convertStringToByteArray(activationKey), BaseFunctions.convertStringToByteArray(pin), 10, 32)); }
public async void SetAbout() { eventDescription.IsVisible = true; emptyList.IsVisible = false; await((HomeLayout)App.Current.MainPage).SetLoading(true, "Syncing event RSVP status..."); currentEvent = await((HomeLayout)App.Current.MainPage).GetCurrentDomainEventFromServer(); if (currentEvent.s_event.eventType != "Subscription") { cancelSubscription.IsVisible = false; } else { subscription = App.serverData.mei_user.userSubscriptionList.Find(x => x.planID == currentEvent.s_event.eventSubscriptionPlanID); if (subscription != null) { await((HomeLayout)App.Current.MainPage).SetLoading(true, "Syncing event RSVP status..."); string subStatus = await App.serverData.GetSubscriptionStatus(subscription.subscriptionID, "sub_status"); cancelSubscription.IsVisible = true; if ((subStatus.Equals("Canceled") || subStatus.Equals("Expired")) && currentEvent.s_event.eventSubscriptionType != "Single") { cancelSubscription.IsEnabled = false; if (subStatus.Equals("Canceled")) { cancelSubscription.Text = "Subscription Canceled"; } else { cancelSubscription.Text = "Subscription Expired"; } } else if (currentEvent.s_event.eventSubscriptionType != "Single") { cancelSubscription.IsVisible = false; } } } if (!string.IsNullOrEmpty(currentEvent.s_event.eventName)) { eventName.Text = currentEvent.s_event.eventName; } else { eventName.Text = "No event name"; } if (!string.IsNullOrEmpty(currentEvent.s_event.eventLogo)) { aboutEventLogo.Source = currentEvent.s_event.eventLogo; Regex initials = new Regex(@"(\b[a-zA-Z])[a-zA-Z]* ?"); string init = initials.Replace(currentEvent.s_event.eventName, "$1"); if (init.Length > 3) { init = init.Substring(0, 3); } logoText.Text = init.ToUpper(); } else { aboutEventLogo.Source = ""; Regex initials = new Regex(@"(\b[a-zA-Z])[a-zA-Z]* ?"); string init = initials.Replace(currentEvent.s_event.eventName, "$1"); if (init.Length > 3) { init = init.Substring(0, 3); } logoText.Text = init.ToUpper(); } if (!string.IsNullOrEmpty(currentEvent.s_event.eventVenueName)) { eventVenueName.Text = currentEvent.s_event.eventVenueName; } else { eventVenueName.Text = ""; } if (!string.IsNullOrEmpty(currentEvent.s_event.eventAbout)) { eventDescription.Text = currentEvent.s_event.eventAbout; } else { eventDescription.IsVisible = false; emptyList.IsVisible = true; if (!string.IsNullOrEmpty(currentEvent.s_event.eventDescription)) { eventDescription.Text = currentEvent.s_event.eventDescription; } else { eventDescription.IsVisible = false; emptyList.IsVisible = true; } } if (!string.IsNullOrEmpty(currentEvent.s_event.eventAddress)) { eventCityState.Text = currentEvent.s_event.eventAddress; } else { eventCityState.Text = ""; } if (currentEvent.s_event.eventStartDate.Equals(currentEvent.s_event.eventEndDate)) { eventDays.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + ", " + BaseFunctions.getYear(currentEvent.s_event.eventEndDate); } else { if (BaseFunctions.GetMonth(currentEvent.s_event.eventStartDate) == BaseFunctions.GetMonth(currentEvent.s_event.eventEndDate)) { eventDays.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + " - " + BaseFunctions.getDayYear(currentEvent.s_event.eventEndDate); } else { eventDays.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + " - " + BaseFunctions.getMonthDay(currentEvent.s_event.eventEndDate) + ", " + BaseFunctions.getYear(currentEvent.s_event.eventEndDate); } } var k = await rsvpTemplate.CheckRSVP(); await((HomeLayout)App.Current.MainPage).SetLoading(false, "Loading event sessions..."); }
public int InsertCierreKardex(int Accion, int UsuarioID, string Almacen, string ProductoID, string EmpresaID, string Periodo, int Anno, bool CostoCero, decimal Cantidad2, decimal CostoUnitario) { int totalAfectados = 0; CD_Kardex ObjCD_Kardex = new CD_Kardex(AppSettings.GetConnectionString); if (Accion == 1) { DataTable dtTMP = new DataTable(); DataTable dtTMP2 = new DataTable(); if (CostoCero == false) { //aplicar la lógica del cierre en el reporte mensual if (ProductoID == "TODOS") { ProductoID = ""; } DateTime FecInicial, FecFinal; FecInicial = new DateTime(Anno, Convert.ToInt16(Periodo), 1); FecFinal = new DateTime(Anno, Convert.ToInt16(Periodo), 1).AddMonths(1); dtTMP2 = new CL_Kardex().getDTKardex_varios(ProductoID, EmpresaID, FecInicial, FecFinal, Almacen, 1); dtTMP = new CL_Kardex().ArmarReporteKardex(dtTMP2); //Seleccionamos disticnt de los productos DataTable DtProductos = new DataTable(); DtProductos = dtTMP.DefaultView.ToTable(true, "ProductoID"); //tabla apra agregar los cierres DataTable DTCierre = new DataTable("Cierre"); DTCierre.Columns.Add("ProductoID", typeof(string)); DTCierre.Columns.Add("Cantidad", typeof(decimal)); DTCierre.Columns.Add("CostoUnitario", typeof(decimal)); foreach (DataRow DRP in DtProductos.Rows) { //filtramos datos por producto DataView Dv = new DataView(dtTMP, "ProductoID='" + DRP["ProductoID"].ToString() + "'", "ID DESC", DataViewRowState.CurrentRows); DataRow DR = DTCierre.NewRow(); DR["ProductoID"] = DRP["ProductoID"]; DR["Cantidad"] = decimal.Round(Convert.ToDecimal(Dv[0]["FCantidad"]), 2); DR["CostoUnitario"] = decimal.Round(Convert.ToDecimal(Dv[0]["FCostoUnitario"]), 2); DTCierre.Rows.Add(DR); } string XML = ""; string _xml = new BaseFunctions().GetXML(DTCierre).Replace("NewDataSet", "DocumentElement"); XML = _xml.Replace("Table", "Cierre"); //insercion masiva del kardex totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, XML, UsuarioID, null, null, EmpresaID, Periodo, Anno, false, Cantidad2, CostoUnitario); } else { string XML = ""; totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, XML, UsuarioID, Almacen, ProductoID, EmpresaID, Periodo, Anno, CostoCero, Cantidad2, CostoUnitario); } } else if (Accion == 2) { //ingreso manual totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, "", UsuarioID, Almacen, ProductoID, EmpresaID, Periodo, Anno, CostoCero, Cantidad2, CostoUnitario); } return(totalAfectados); }
public async void SetCurrentEventReminder(object sender, EventArgs e) { if (CheckSelfPermission(Manifest.Permission.WriteCalendar.ToString()) == Android.Content.PM.Permission.Granted) { try { if (!isEventInCal(this, App.reminderEvent.eventName)) { ContentValues eventValues = new ContentValues(); eventValues.Put(CalendarContract.Events.InterfaceConsts.CalendarId, 1); eventValues.Put(CalendarContract.Events.InterfaceConsts.Title, App.reminderEvent.eventName); eventValues.Put(CalendarContract.Events.InterfaceConsts.Description, App.reminderEvent.eventDescription); eventValues.Put(CalendarContract.Events.InterfaceConsts.Dtstart, GetDateTimeMS(BaseFunctions.GetDateTimeFull(App.reminderEvent.eventStartDate + " " + App.reminderEvent.eventStartTime))); eventValues.Put(CalendarContract.Events.InterfaceConsts.Dtend, GetDateTimeMS(BaseFunctions.GetDateTimeFull(App.reminderEvent.eventEndDate + " " + App.reminderEvent.eventEndTime))); eventValues.Put(CalendarContract.Events.InterfaceConsts.AllDay, "0"); eventValues.Put(CalendarContract.Events.InterfaceConsts.EventLocation, App.reminderEvent.eventAddress); eventValues.Put(CalendarContract.Events.InterfaceConsts.HasAlarm, "1"); eventValues.Put(CalendarContract.Events.InterfaceConsts.EventTimezone, "UTC"); eventValues.Put(CalendarContract.Events.InterfaceConsts.EventEndTimezone, "UTC"); var eventUri = ContentResolver.Insert(CalendarContract.Events.ContentUri, eventValues); long eventID = long.Parse(eventUri.LastPathSegment); ContentValues reminderValues = new ContentValues(); reminderValues.Put(CalendarContract.Reminders.InterfaceConsts.Minutes, 30); reminderValues.Put(CalendarContract.Reminders.InterfaceConsts.EventId, eventID); reminderValues.Put(CalendarContract.Reminders.InterfaceConsts.Method, (int)RemindersMethod.Alert); var reminderUri = ContentResolver.Insert(CalendarContract.Reminders.ContentUri, reminderValues); await App.Current.MainPage.DisplayAlert("Alert", "This event is added to your calender", "Ok"); } else { await App.Current.MainPage.DisplayAlert("Alert", "This event is already added to your calender", "Ok"); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.ToString()); } } else { RequestPermissions(new string[] { Manifest.Permission.WriteCalendar.ToString() }, calenderRequestCode); } }
public static string[] tokenTANMatrixArrayFetch(TokenCryptoData tokenCryptoData, string masterKey, string dataEntropy) { string[] result; try { string[] array = BaseFunctions.DecodeFrom64(tokenCryptoData.CryptoData.SupportCryptoData).Split(new char[] { ';' }); if (tokenCryptoData.TokenBaseParams.OTPValidationWindow != array.Length) { result = null; } else { byte[] tokenSeed = tokenCryptoData.GetTokenSeed(masterKey); string[] array2 = new string[tokenCryptoData.TokenBaseParams.OTPValidationWindow]; for (int i = 0; i < tokenCryptoData.TokenBaseParams.OTPValidationWindow; i++) { tokenCryptoData.ResetMovingFactor((long)int.Parse(array[i])); array2[i] = HOTPPwdGenerator.generate(tokenCryptoData, tokenSeed, (dataEntropy == null || dataEntropy.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy)); } result = array2; } } catch { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::TANMatrixArrayFetch[]", null); result = null; } finally { } return(result); }
private void BtnGrabar_Click(object sender, EventArgs e) { try { if (Ds != null)//si datatset tiene tablas { bool MenorqDisponible = false; string Producto = ""; #region crear solicitud de transferencia DataTable dtRequerimiento = new DataTable(); dtRequerimiento.Columns.Add("Origen", typeof(string)); dtRequerimiento.Columns.Add("Sede", typeof(string)); dtRequerimiento.Columns.Add("AlmacenID", typeof(string)); dtRequerimiento.Columns.Add("Almacen", typeof(string)); dtRequerimiento.Columns.Add("ProductoID", typeof(string)); dtRequerimiento.Columns.Add("Producto", typeof(string)); dtRequerimiento.Columns.Add("UM", typeof(string)); dtRequerimiento.Columns.Add("Marca", typeof(string)); dtRequerimiento.Columns.Add("Disponible", typeof(decimal)); dtRequerimiento.Columns.Add("CantidadSolicitada", typeof(decimal)); dtRequerimiento.Columns.Add("Observacion", typeof(string)); //#region Macroinsumos //filtrar todos los productos para que se conviertan en columnas DataTable DtFiltro1 = new DataTable(); DtFiltro1 = new BaseFunctions().SelectDistinct(Ds.Tables["Temp"], "ProductoIDMateria", "AlmacenMateria", "NomProducto"); //crear las columnas DataTable DTAcu = new DataTable(); DTAcu.Columns.Add("ProductoIDMateria", typeof(string)); DTAcu.Columns.Add("Almacen", typeof(string)); DTAcu.Columns.Add("Cantidad", typeof(decimal)); string empresa = "", sede = "001PU"; if (CboEmpresa.SelectedIndex == 0) { empresa = "IH"; } else { empresa = "GH"; } //filtrar e ir agregando foreach (DataRow dr2 in DtFiltro1.Rows) { DataRow DR = DTAcu.NewRow(); DR["ProductoIDMateria"] = dr2["ProductoIDMateria"]; DR["Almacen"] = empresa + sede + dr2["AlmacenMateria"]; //filtrar e ir agregando DataView Dv = new DataView(Ds.Tables["DtSumatoria"]); Dv.RowFilter = "NomProducto = '" + dr2["NomProducto"] + "'"; decimal Cantidad = 0; Cantidad = Convert.ToDecimal(Dv[0]["Cantidad"]); DR["Cantidad"] = Cantidad; DTAcu.Rows.Add(DR); } foreach (DataRow DR in DTAcu.Rows) { DataRow row = dtRequerimiento.NewRow(); row["Origen"] = empresa + sede + "PRO"; //quien lo solicita row["Sede"] = AppSettings.NomSede; row["AlmacenID"] = DR["Almacen"]; //quien debe darselo row["Almacen"] = "PRODUCCION"; row["ProductoID"] = DR["ProductoIDMateria"]; row["Producto"] = ""; row["UM"] = ""; row["Marca"] = ""; //obtener el disponible DataView DvS = new DataView(Ds.Tables["DtStockLocalSede"]); DvS.RowFilter = "ProductoID = '" + DR["ProductoIDMateria"] + "'"; if (DvS.Count == 1) { row["Disponible"] = DvS[0]["StockDisponible"]; Producto = DvS[0]["NomProducto"].ToString(); } else { row["Disponible"] = 0; Producto = DR["ProductoIDMateria"].ToString(); } //validar si lo solicitado es menor que lo disponible, sea el caso se creara el requerimiento de trasnferencia if (Convert.ToDecimal(row["Disponible"]) < Convert.ToDecimal(DR["Cantidad"])) { MenorqDisponible = true; break; } row["CantidadSolicitada"] = DR["Cantidad"]; row["Observacion"] = "para produccion del dia: " + DateTime.Now.ToString(); dtRequerimiento.Rows.Add(row); } #endregion if (MenorqDisponible == false) { //new CL_Requerimientos().InsertarTransferencia(dtRequerimiento, AppSettings.UserID, empresa, AppSettings.NomSede, AppSettings.ApeNom_Login); #region guardar historico ObjCL_Produccion.InsertMateriaPrimaHistorico(empresa, AppSettings.UserID, Ds.Tables["Temp"], DtProductosBatch); #endregion MessageBox.Show("Se guardo correctamente en el historial", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("El producto: " + Producto + " no tiene suficiente stock disponible, disminuyalo o espere que cuente con el stock necesario.\r\n\r\n No se creo el requerimiento de transferencia ni se guardo el plan de producción.", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); } BtnGrabar.Visible = false; BtnNuevo_Click(null, null); }//fin si dataset tiene tablas } catch (Exception ex) { MessageBox.Show(ex.Message + ". Metodo InsertMateriaPrimaHistorico().", "Aviso", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public AutenticationStatus Autenticate(string tokenInternalID, string password, string dataEntropy, out string newChallenge) { newChallenge = null; TokenCryptoData _tkCryptoData = new TokensDAO().loadTokenCryptoData(tokenInternalID); AutenticationStatus result; if (_tkCryptoData.ID == null) { result = AutenticationStatus.ErrorCheckTokenStatus; } else { if (_tkCryptoData.TokenBaseParams.MovingFactorType != TokenMovingFactorType.EventBase && _tkCryptoData.TokenBaseParams.SeedType == TokenSeedType.ActivactionKey) { throw new Exception("Function not implemented for this type of token!!"); } long _MovingFactor; AutenticationStatus _authStatus = HOTPPwdValidator.Validate(_tkCryptoData, (dataEntropy == null) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy), this._masterKey, password, out _MovingFactor); if (_authStatus == AutenticationStatus.Success || _authStatus == AutenticationStatus.SuccessButSynchronized) { _tkCryptoData.ResetMovingFactor(_MovingFactor); if (new TokensDAO().updateMovingFactor(_tkCryptoData) != OperationResult.Success) { result = AutenticationStatus.TokenOrPasswordInvalid; return(result); } } result = _authStatus; } return(result); }
public async void SponsorDetials(SponsorGroup _sponsor, SponsorsTemplate parentSponsor) { await((HomeLayout)App.Current.MainPage).SetLoading(true, "loading sponsor..."); currentSponsor = _sponsor; sponsorTemp = parentSponsor; VcardContact c_user = new VcardContact(); c_user.FirstName = currentSponsor.company.CompanyName; c_user.LastName = currentSponsor.company.CompanyName; c_user.company = currentSponsor.company.CompanyName; c_user.phoneNumber = currentSponsor.company.companyPhone; c_user.email = currentSponsor.company.companyEmail; App.contactuser = c_user; if (currentSponsor.company != null) { CheckSocialVisiblilty(); if (!string.IsNullOrEmpty(currentSponsor.company.companyLogo)) { sponsorLogo.Source = currentSponsor.company.companyLogo; Regex initials = new Regex(@"(\b[a-zA-Z])[a-zA-Z]* ?"); string init = initials.Replace(currentSponsor.company.CompanyName, "$1"); if (init.Length > 3) { init = init.Substring(0, 3); } logoText.Text = init.ToUpper(); } else { sponsorLogo.Source = ""; Regex initials = new Regex(@"(\b[a-zA-Z])[a-zA-Z]* ?"); string init = initials.Replace(currentSponsor.company.CompanyName, "$1"); if (init.Length > 3) { init = init.Substring(0, 3); } logoText.Text = init.ToUpper(); } if (!string.IsNullOrEmpty(currentSponsor.company.CompanyName)) { sponsorName.Text = currentSponsor.company.CompanyName; } else { sponsorName.Text = ""; } if (currentSponsor.sponsor.sponsorFields.Count > 0) { BaseFunctions.GetCustomFields(customFieldsLayout, currentSponsor.sponsor.sponsorFields); } if (!string.IsNullOrEmpty(currentSponsor.company.companyWebsite)) { websiteURL = currentSponsor.company.companyWebsite; } id = _sponsor.sponsor.sponsorID; if (!string.IsNullOrEmpty(currentSponsor.company.companyDescription)) { description.Text = currentSponsor.company.companyDescription; emptyList.IsVisible = false; } else { emptyList.IsVisible = true; description.ParentView.IsVisible = false; } } CheckBookmark(App.serverData.mei_user.currentUser.userBookmarks.isBookmarked(currentSponsor)); await Task.Delay(1000); await((HomeLayout)App.Current.MainPage).SetLoading(false, ""); }
public async Task <bool> SaveUserToBrainTree() { if (string.IsNullOrEmpty(NameOnCard.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Name on Card", "OK"); return(false); } if (string.IsNullOrEmpty(cardNumber.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Card Number", "OK"); return(false); } if (string.IsNullOrEmpty(cardMonth.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Expiration Month of Card", "OK"); return(false); } if (string.IsNullOrEmpty(cardYear.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Expiration Year of Card", "OK"); return(false); } if (string.IsNullOrEmpty(cardCvv.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required CVV", "OK"); return(false); } if (string.IsNullOrEmpty(billingFirstName.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required First Name for billing information", "OK"); return(false); } if (string.IsNullOrEmpty(billingLastName.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Last Name for billing information", "OK"); return(false); } if (string.IsNullOrEmpty(billingAddressLine.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Address for billing information", "OK"); return(false); } if (string.IsNullOrEmpty(billingCity.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required City for billing information", "OK"); return(false); } if (string.IsNullOrEmpty(billingPostalCode.Text)) { await App.Current.MainPage.DisplayAlert("Alert", "Required Postal / Zip code for billing information", "OK"); return(false); } bool returnValue = false; if (App.serverData.mei_user.userCustomerTokenList.Count > currentIndex) { UserCard currentCard = new UserCard(); currentCard.card = App.serverData.mei_user.userCustomerTokenList[currentIndex].card; currentCard.cardToken = App.serverData.mei_user.userCustomerTokenList[currentIndex].cardToken; currentCard.card.cardName = NameOnCard.Text; currentCard.card.cardExpMonth = cardMonth.Text; currentCard.card.cardExpYear = cardYear.Text; currentCard.card.cardCVV = cardCvv.Text; currentCard.card.cardBillingFirstName = billingFirstName.Text; currentCard.card.cardBillingLastName = billingLastName.Text; currentCard.card.cardBillingAddress = billingAddressLine.Text; //currentCard.billingInformation.addressLine2 = billingAddressLine2.Text; currentCard.card.cardBillingCity = billingCity.Text; currentCard.card.cardBillingZipCode = billingPostalCode.Text; currentCard.card.cardBillingState = states[billingState.SelectedIndex]; string token = await BaseFunctions.UpdateBraintreeUser(currentIndex, currentUser, currentCard); if (token == "updated") { App.serverData.mei_user.userCustomerTokenList[currentIndex] = currentCard; ((HomeLayout)App.Current.MainPage).paymentList.PullToRefresh(); returnValue = true; } else { returnValue = false; } } else { if (!agreeTermSwitch.IsToggled) { await App.Current.MainPage.DisplayAlert("Alert", "Please agree terms and conditions to add a card to your account.", "OK"); return(false); } if (!agreePrivacySwitch.IsToggled) { await App.Current.MainPage.DisplayAlert("Alert", "Please agree privacy to add a card to your account.", "OK"); return(false); } List <UserCard> list = new List <UserCard>(); UserCard currentCard = new UserCard(); currentCard.card = new CardObject(); currentCard.card.cardName = NameOnCard.Text; currentCard.card.cardNumber = cardNumber.Text; currentCard.card.cardExpMonth = cardMonth.Text; currentCard.card.cardExpYear = cardYear.Text; currentCard.card.cardCVV = cardCvv.Text; currentCard.card.cardBillingFirstName = billingFirstName.Text; currentCard.card.cardBillingLastName = billingLastName.Text; currentCard.card.cardBillingAddress = billingAddressLine.Text; currentCard.card.cardBillingCity = billingCity.Text; currentCard.card.cardBillingState = states[billingState.SelectedIndex]; currentCard.card.cardBillingZipCode = billingPostalCode.Text; string token = "not assigned"; token = await BaseFunctions.AddUserToBraintree(currentIndex, currentUser, currentCard.card); if (token != "") { string customerID = token.Split("&"[0])[0]; string customerTokenID = token.Split("&"[0])[1]; string cardType = token.Split("&"[0])[2]; currentUser.userCustomerID.Add(customerID); App.serverData.mei_user.currentUser = currentUser; await((HomeLayout)App.Current.MainPage).SetLoading(true, "Adding card to your profile..."); await App.serverData.CreateUserTokenList(); ((HomeLayout)App.Current.MainPage).paymentList.PullToRefresh(); await((HomeLayout)App.Current.MainPage).SetLoading(true, "Saving to server..."); returnValue = await BaseFunctions.SaveUserToServer(); } else { returnValue = false; } } return(returnValue); }
public static OperationResult TokensCreateNew(TokenTypeBaseParams tkTypeBaseParams, string masterKey, string vendorSerialNumber, string dataEntropy, out TokenCryptoData tokenCryptoData) { OperationResult result; try { byte[] tkseed; byte[] tkserial; long tkmovFactor; if (OperationResult.Error == HOTPCryptoData.Generate(masterKey, null, tkTypeBaseParams, out tkseed, out tkserial, out tkmovFactor)) { tokenCryptoData = new TokenCryptoData(null, null, new CryptoData(), new TokenTypeBaseParams()); result = OperationResult.Error; } else { TokenCryptoData _tkCryptoData = new TokenCryptoData(null, vendorSerialNumber, new CryptoData(tkmovFactor, BaseFunctions.HexEncoder(tkseed), BaseFunctions.HexEncoder(tkserial), ""), tkTypeBaseParams); _tkCryptoData.ResetMovingFactor(HOTPCipherInitialize.createSequenceNumber()); if (tkTypeBaseParams.MovingFactorType == TokenMovingFactorType.TransactionAuthenticationNumber) { string supportCryptoData; if (OperationResult.Error == TokensBaseFunctions.tokenTANMatrixIntegrityCheck(_tkCryptoData, _tkCryptoData.GetTokenSeed(masterKey), (dataEntropy == null || dataEntropy.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy), out supportCryptoData)) { tokenCryptoData = new TokenCryptoData(null, null, new CryptoData(), new TokenTypeBaseParams()); result = OperationResult.Error; return(result); } _tkCryptoData.ResetSupportCryptoData(supportCryptoData); } tokenCryptoData = _tkCryptoData; result = OperationResult.Success; } } catch (Exception ex) { tokenCryptoData = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { // byte[] tkseed = null; // byte[] tkserial = null; } return(result); }
public static OperationResult TokensImportNew(TokenTypeBaseParams tkTypeBaseParams, string masterKey, string vendorSerialNumber, string externalSeed, string pin, long movingFactor, out TokenCryptoData TokenCryptoData) { TokenCryptoData = new TokenCryptoData(null, null, new CryptoData(), new TokenTypeBaseParams()); OperationResult result; try { if (tkTypeBaseParams.SeedType != TokenSeedType.Dynamic) { throw new Exception("Invalid Seed type!"); } if (tkTypeBaseParams.MovingFactorType != TokenMovingFactorType.EventBase || movingFactor < 1L) { throw new Exception("Invalid MovingFactorType!"); } byte[] tkserial = HOTPCipherInitialize.createSerialNumber((pin == null || pin.Length < 1) ? HOTPCipherInitialize.Generate4DigitsPin() : pin); byte[] tkseed = HOTPCipher.encryptData(BaseFunctions.HexDecoder(externalSeed), HOTPCipherInitialize.createCryptKey(tkserial, (masterKey == null || masterKey.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(masterKey))); TokenCryptoData = new TokenCryptoData(null, vendorSerialNumber, new CryptoData(movingFactor, BaseFunctions.HexEncoder(tkseed), BaseFunctions.HexEncoder(tkserial), ""), tkTypeBaseParams); TokenCryptoData.ResetMovingFactor(movingFactor); result = OperationResult.Success; } catch (Exception ex) { TokenCryptoData = new TokenCryptoData(null, null, new CryptoData(), new TokenTypeBaseParams()); SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { } return(result); }
public static string[] tokenTANMatrixArrayFetch(TokenCryptoData tokenCryptoData, string masterKey, string dataEntropy) { string[] result; try { string[] _TanChallenge = BaseFunctions.DecodeFrom64(tokenCryptoData.CryptoData.SupportCryptoData).Split(new char[] { ';' }); if (tokenCryptoData.TokenBaseParams.OTPValidationWindow != _TanChallenge.Length) { result = null; } else { byte[] _seedOpen = tokenCryptoData.GetTokenSeed(masterKey); string[] _matriz = new string[tokenCryptoData.TokenBaseParams.OTPValidationWindow]; for (int _index = 0; _index < tokenCryptoData.TokenBaseParams.OTPValidationWindow; _index++) { tokenCryptoData.ResetMovingFactor((long)int.Parse(_TanChallenge[_index])); _matriz[_index] = HOTPPwdGenerator.generate(tokenCryptoData, _seedOpen, (dataEntropy == null || dataEntropy.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy)); } result = _matriz; } } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = null; } finally { } return(result); }
public int InsertCierreKardex(int Accion, int UsuarioID, string Almacen, string ProductoID, string EmpresaID, string Periodo, int Anno, bool CostoCero, decimal Cantidad2, decimal CostoUnitario) { int totalAfectados = 0; CD_Kardex ObjCD_Kardex = new CD_Kardex(AppSettings.GetConnectionString); if (Accion == 1) { DataTable dtTMP = new DataTable(); if (CostoCero == false) { //aplicar la lógica del cierre en el reporte mensual if (ProductoID == "TODOS") { ProductoID = ""; } DateTime FecInicial, FecFinal; FecInicial = new DateTime(Anno, Convert.ToInt16(Periodo), 1); FecFinal = new DateTime(Anno, Convert.ToInt16(Periodo), 1).AddMonths(1); dtTMP = new CL_Kardex().getDTKardex_varios(ProductoID, EmpresaID, FecInicial, FecFinal, Almacen, 2); //buscar '0' en los valores, no deberia existir el '0' DataView DVCero = new DataView(dtTMP, "PrecioUnitario = 0", "", DataViewRowState.CurrentRows); if (DVCero.Count > 0) { throw new Exception("Hay " + DVCero.Count.ToString() + " costo(s) unitario igual a 0\n\nno se insertara ningun registro"); } decimal Cantidad = 0, CantidadAcumulada = 0, PrecioPonderado = 0, CostoAcumulado = 0; //UsuarioID //Creamos tabla para ordenar los datos DataTable DtKardex = new DataTable("GetKardex"); DtKardex.Columns.Add("ID", typeof(int)).AutoIncrement = true; DtKardex.Columns.Add("ProductoID", typeof(string)); DtKardex.Columns.Add("FCantidad", typeof(decimal)); DtKardex.Columns.Add("FCostoUnitario", typeof(decimal)); //Seleccionamos disticnt de los productos DataTable DtProductos = new DataTable(); DtProductos = dtTMP.DefaultView.ToTable(true, "ProductoID"); foreach (DataRow DRP in DtProductos.Rows) { //filtramos datos por producto DataView Dv = new DataView(dtTMP, "ProductoID='" + DRP["ProductoID"].ToString() + "'", "AudCrea ASC", DataViewRowState.CurrentRows); foreach (DataRowView Dr in Dv) { DataRow DR = DtKardex.NewRow(); DR["ProductoID"] = Dr["ProductoID"]; Cantidad = Convert.ToDecimal(Dr["Cantidad"]); //validar si es entrada o salida if (Dr["Tipo"].ToString() == "I") { PrecioPonderado = Convert.ToDecimal(Dr["PrecioUnitario"]);//temporal CantidadAcumulada += Cantidad; CostoAcumulado += Cantidad * PrecioPonderado; DR["FCantidad"] = CantidadAcumulada; PrecioPonderado = CostoAcumulado / CantidadAcumulada;//precio real nuevo DR["FCostoUnitario"] = PrecioPonderado; } else if (Dr["Tipo"].ToString() == "S" & Dr["TipoOperacion"].ToString() == "01") //salida por venta { CantidadAcumulada -= Cantidad; CostoAcumulado = CantidadAcumulada * PrecioPonderado; DR["FCantidad"] = CantidadAcumulada; PrecioPonderado = CostoAcumulado / CantidadAcumulada; DR["FCostoUnitario"] = PrecioPonderado; } else if (Dr["Tipo"].ToString() == "S") //otro tipo de salida { PrecioPonderado = Convert.ToDecimal(Dr["PrecioUnitario"]); //temporal CantidadAcumulada -= Cantidad; DR["FCantidad"] = CantidadAcumulada; CostoAcumulado -= Cantidad * PrecioPonderado; PrecioPonderado = CostoAcumulado / CantidadAcumulada; DR["FCostoUnitario"] = PrecioPonderado; } else if (Dr["Tipo"].ToString() == "A") //saldo inicial { PrecioPonderado = Convert.ToDecimal(Dr["PrecioUnitario"]); CantidadAcumulada += Cantidad; CostoAcumulado += Cantidad * PrecioPonderado; DR["FCantidad"] = Cantidad; DR["FCostoUnitario"] = PrecioPonderado; } DtKardex.Rows.Add(DR); } Cantidad = 0; CantidadAcumulada = 0; PrecioPonderado = 0; } //una ves creada la tabla, se debe capturar los totales y ordenarlos en otra tabla //Creamos tabla para ordenar los datos DataTable DTCierre = new DataTable("Cierre"); DTCierre.Columns.Add("ProductoID", typeof(string)); DTCierre.Columns.Add("Cantidad", typeof(decimal)); DTCierre.Columns.Add("CostoUnitario", typeof(decimal)); foreach (DataRow DRP in DtProductos.Rows) { //cacturar el ultimo valor agregado, ese sera el costo nuevo DataView DV = new DataView(DtKardex, "ProductoID = '" + DRP["ProductoID"].ToString() + "'", "ID DESC", DataViewRowState.CurrentRows); DataRow DR = DTCierre.NewRow(); DR["ProductoID"] = DRP["ProductoID"]; DR["Cantidad"] = DV[0]["FCantidad"]; DR["CostoUnitario"] = DV[0]["FCostoUnitario"]; DTCierre.Rows.Add(DR); } string XML = ""; string _xml = new BaseFunctions().GetXML(DTCierre).Replace("NewDataSet", "DocumentElement"); XML = _xml.Replace("Table", "Cierre"); //insercion masiva del kardex totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, XML, UsuarioID, null, null, EmpresaID, Periodo, Anno, false, Cantidad2, CostoUnitario); } else { string XML = ""; totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, XML, UsuarioID, Almacen, ProductoID, EmpresaID, Periodo, Anno, CostoCero, Cantidad2, CostoUnitario); } } else if (Accion == 2) { //ingreso manual totalAfectados = ObjCD_Kardex.InsertCierreKardex(Accion, "", UsuarioID, Almacen, ProductoID, EmpresaID, Periodo, Anno, CostoCero, Cantidad2, CostoUnitario); } return(totalAfectados); }
public void SetEventDetails(DomainEvent currentEvent) { if (!string.IsNullOrEmpty(currentEvent.s_event.eventVenueName)) { currentCenter.Text = currentEvent.s_event.eventVenueName; } else { currentCenter.Text = ""; } if (!string.IsNullOrEmpty(currentEvent.s_event.eventName)) { currentEventName.Text = currentEvent.s_event.eventName; } else { currentEventName.Text = ""; } if (!string.IsNullOrEmpty(currentEvent.s_event.eventVenueMap.venueAddress)) { currentCityState.Text = currentEvent.s_event.eventVenueMap.venueAddress; } else { currentCityState.Text = ""; } if (!string.IsNullOrEmpty(currentEvent.s_event.eventLogo)) { eventIcon.Source = currentEvent.s_event.eventLogo; } else { eventIcon.Source = "eventicon.png"; } if (currentEvent.s_event.eventStartDate.Equals(currentEvent.s_event.eventEndDate)) { currentSchedule.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + ", " + BaseFunctions.getFullYear(currentEvent.s_event.eventStartDate); } else { if (BaseFunctions.GetMonth(currentEvent.s_event.eventStartDate) == BaseFunctions.GetMonth(currentEvent.s_event.eventEndDate)) { currentSchedule.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + " - " + BaseFunctions.getDayYear(currentEvent.s_event.eventStartDate); } else { currentSchedule.Text = BaseFunctions.getMonthDay(currentEvent.s_event.eventStartDate) + " - " + BaseFunctions.getMonthDay(currentEvent.s_event.eventEndDate) + ", " + BaseFunctions.getYear(currentEvent.s_event.eventEndDate); } } }
private void BtnGenerarHojaDespacho_Click(object sender, EventArgs e) { if (DtGuias.Rows.Count > 0) { BtnGenerarHojaDespacho.Visible = false; BtnNuevo.Visible = false; BtnGrabar.Visible = false; BtnBalanza.Visible = false; RbPeso.Visible = false; RbTara.Visible = false; #region inserta hoja de despacho y se obtiene el codigo //Insertar Hoja de despacho E_HojaDespacho ObjHojaDespacho = new E_HojaDespacho(); ObjHojaDespacho.EmpresaID = EmpresaIDUser; ObjHojaDespacho.EmpresaTransporte = EmpresaTransporte; ObjHojaDespacho.NombreChofer = NomTransportista; ObjHojaDespacho.placa = TxtPlaca.Text; ObjHojaDespacho.Carrosa = TxtCarrosa.Text; ObjHojaDespacho.FechaLlegada = Convert.ToDateTime(DeFechaLlegada.Value); ObjHojaDespacho.FechaSalida = Convert.ToDateTime(DeFechaSalida.Value); ObjHojaDespacho.NumJabas = NroJabasTotal; ObjHojaDespacho.PesoTotal = BrutoTotal; ObjHojaDespacho.PesoNeto = NetoTotal; ObjHojaDespacho.TotalAnimales = Cantidad; ObjHojaDespacho.TaraTotal = TaraTotal; ObjHojaDespacho.UsuarioID = AppSettings.UserID; NumHojaDespacho = new CL_HojaDespacho().InsertHojaDespacho(ObjHojaDespacho, AppSettings.SedeID); #endregion #region crear tablas //Tabla para insertar el detalle de la hoja de despacho DataTable DetalleHojaDespacho = new DataTable(); DetalleHojaDespacho.TableName = "DetalleHojaDespacho"; DetalleHojaDespacho.Columns.Add("ProductoID", typeof(string)); DetalleHojaDespacho.Columns.Add("NumHojaDespacho", typeof(string)); DetalleHojaDespacho.Columns.Add("NumGuiaRemision", typeof(string)); DetalleHojaDespacho.Columns.Add("NumRequerimiento", typeof(string)); DetalleHojaDespacho.Columns.Add("NroFactura", typeof(string)); DetalleHojaDespacho.Columns.Add("TotalPeso", typeof(decimal)); DetalleHojaDespacho.Columns.Add("Motivo", typeof(string)); DetalleHojaDespacho.Columns.Add("NumGuiaTransportista", typeof(string)); DetalleHojaDespacho.Columns.Add("Bultos", typeof(string)); DetalleHojaDespacho.Columns.Add("IDProveedor", typeof(int)); #endregion //para detalle hoja despacho foreach (DataRow Row2 in DtGuias.Rows) { DataRow RowHD = DetalleHojaDespacho.NewRow(); RowHD["ProductoID"] = Row2["ProductoID"]; RowHD["NumHojaDespacho"] = NumHojaDespacho; RowHD["NumGuiaRemision"] = Row2["NumGuiaRemision"]; RowHD["NumRequerimiento"] = Row2["NumRequerimiento"]; RowHD["NroFactura"] = Row2["NroFactura"]; RowHD["TotalPeso"] = Row2["TotalPeso"]; RowHD["Motivo"] = Row2["Motivo"]; RowHD["NumGuiaTransportista"] = Row2["NumGuiaTransportista"]; RowHD["Bultos"] = Row2["Bultos"]; RowHD["IDProveedor"] = Row2["IDProveedor"]; DetalleHojaDespacho.Rows.Add(RowHD); } if (DetalleHojaDespacho.Rows.Count > 0) { string xml = new BaseFunctions().GetXML(DetalleHojaDespacho).Replace("NewDataSet", "DocumentElement"); bool Valor; Valor = new CL_HojaDespacho().InsertXMLDetalleHojaDespacho(xml); if (Valor == false) { MessageBox.Show("Ocurrio un error al intentar insertar los detalles de la hoja de despacho", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } //mostrar en reporte Reportes.FrmHojaDespacho ObjFrmHojaD = new Reportes.FrmHojaDespacho(); ObjFrmHojaD.NumHojaDespacho = NumHojaDespacho; ObjFrmHojaD.ShowDialog(); } else { MessageBox.Show("No se ha creado aún alguna guia.", "Hoja de despacho", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
public AutenticationStatus Autenticate(string tokenInternalID, string password, string dataEntropy, out string newChallenge) { newChallenge = null; TokenCryptoData _tkCryptoData = new TokensDAO().loadTokenCryptoData(tokenInternalID); AutenticationStatus result; if (_tkCryptoData.ID == null) { result = AutenticationStatus.TokenNotFoundOrCanceled; } else { if (_tkCryptoData.TokenBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber) { throw new Exception("Function not implemented for this type of token!!"); } string currentChallenge = (string)new TokensChallengeRequestDAO().loadChallengeRequest(tokenInternalID); if (currentChallenge == null) { result = AutenticationStatus.InvalidDataOnPasswordValidation; } else { int iRequest = int.Parse(SAFConfiguration.readParameterExternal("TANRequestPositions")); int iDigitsByPos = int.Parse(SAFConfiguration.readParameterExternal("TANDigitsByPosition")); int iFixPosOnFaill = int.Parse(SAFConfiguration.readParameterExternal("TANFixedPosOnFail")); string _otp = string.Empty; byte[] _tkSeedOpen = BaseFunctions.HexDecoder(_tkCryptoData.CryptoData.CryptoKey.Trim()); byte[] _dataEntropy = (dataEntropy == null || dataEntropy.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy); string[] _arrayPosValid = currentChallenge.Split(new char[] { '|' }); string[] _arrayChallenge = BaseFunctions.DecodeFrom64(_tkCryptoData.CryptoData.SupportCryptoData.Trim()).Split(new char[] { ';' }); for (int idx = 0; idx < _arrayPosValid.Length; idx++) { string[] _temp = _arrayPosValid[idx].Trim().Split(new char[] { ';' }); _tkCryptoData.ResetMovingFactor(long.Parse(_arrayChallenge[(int)checked ((IntPtr)long.Parse(_temp[0]))])); _otp += HOTPPwdGenerator.generate(_tkCryptoData, _tkSeedOpen, _dataEntropy).Substring(int.Parse(_temp[1]), 1); } if (password.Trim() == _otp) { if (OperationResult.Success == new TokensChallengeRequestDAO().resetChallengeRequest(tokenInternalID)) { result = AutenticationStatus.Success; return(result); } } result = AutenticationStatus.TokenOrPasswordInvalid; } } return(result); }
public static OperationResult TokensCreateNew(TokenTypeBaseParams tkTypeBaseParams, string masterKey, string vendorSerialNumber, string dataEntropy, out TokenCryptoData tokenCryptoData) { OperationResult result; try { byte[] data; byte[] data2; long movingFactor; if (OperationResult.Error == HOTPCryptoData.Generate(masterKey, null, tkTypeBaseParams, out data, out data2, out movingFactor)) { tokenCryptoData = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); result = OperationResult.Error; } else { TokenCryptoData tokenCryptoData2 = new TokenCryptoData(null, vendorSerialNumber, new CryptoData(movingFactor, BaseFunctions.HexEncoder(data), BaseFunctions.HexEncoder(data2), ""), tkTypeBaseParams); tokenCryptoData2.ResetMovingFactor(HOTPCipherInitialize.createSequenceNumber()); /*--------------------------*/ byte[] tokenSeed = tokenCryptoData2.GetTokenSeed(masterKey); string x = Encoding.ASCII.GetString(tokenSeed); Base32Encoder enc = new Base32Encoder(); string y = enc.Encode(tokenSeed); /*--------------------------*/ if (tkTypeBaseParams.MovingFactorType == TokenMovingFactorType.TransactionAuthenticationNumber) { string value; if (OperationResult.Error == TokensBaseFunctions.tokenTANMatrixIntegrityCheck(tokenCryptoData2, tokenCryptoData2.GetTokenSeed(masterKey), (dataEntropy == null || dataEntropy.Length < 1) ? new byte[0] : BaseFunctions.convertStringToByteArray(dataEntropy), out value)) { tokenCryptoData = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); result = OperationResult.Error; return(result); } tokenCryptoData2.ResetSupportCryptoData(value); } tokenCryptoData = tokenCryptoData2; result = OperationResult.Success; } } catch { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::TokensCreateNew[]", null); tokenCryptoData = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); result = OperationResult.Error; } return(result); }
private void Button_Click(object sender, RoutedEventArgs e) { Button b = sender as Button; string buttonName = b.Name; string _index = buttonName.Substring(buttonName.Length - 1, 1); this._resetDisplay(_index); //manual if (GlobalData.initSetting.ONTTYPE == "GW040H" || (GlobalData.initSetting.ONTTYPE == "GW020BoB" && GlobalData.initSetting.ENABLEWRITEAPD == true)) { this.Opacity = 0.3; wBosaSerialNumber wb = new wBosaSerialNumber(_index); wb.ShowDialog(); this.Opacity = 1; } //Kiểm tra trạng thái calib của máy đo ER try { double _temp = 0, _hours; string _time; bool ret; ret = Function.IO.CalibrationModuleTime.Read(out _time); //ret = GlobalData.erDevice.getTemperature(out _temp); ret = BaseFunctions.last_Time_Calibrate_Module_DCAX86100D_To_Hours(_time, out _hours); if (_hours > 5 || _temp > 5) { CalibModuleWarning cm = new CalibModuleWarning(_time.ToString(), _temp.ToString()); cm.ShowDialog(); } } catch { } //***BEGIN -----------------------------------------// System.Threading.Thread t = new System.Threading.Thread(new System.Threading.ThreadStart(() => { //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~// //Start count time System.Diagnostics.Stopwatch st = new System.Diagnostics.Stopwatch(); st.Start(); string _name = buttonName; testinginfo testtmp = null; BaseFunctions.get_Testing_Info_By_Name(_name, ref testtmp); variables vari = new variables(); string _BosaSN = ""; if (GlobalData.initSetting.ONTTYPE == "GW040H" || (GlobalData.initSetting.ONTTYPE == "GW020BoB" && GlobalData.initSetting.ENABLEWRITEAPD == true)) { testtmp.SYSTEMLOG += string.Format("Input Bosa Serial...\r\n...{0}\r\n", testtmp.BOSASERIAL); _BosaSN = testtmp.BOSASERIAL; if (_BosaSN == "--") { return; } } if (GlobalData.initSetting.ENABLEWRITEMAC) { if (testtmp.MACADDRESS == "--") { return; } } //Get Bosa Information from Bosa Serial bosainfo bosaInfo = new bosainfo(); if (GlobalData.initSetting.ONTTYPE == "GW040H" || (GlobalData.initSetting.ONTTYPE == "GW020BoB" && GlobalData.initSetting.ENABLEWRITEAPD == true)) { testtmp.SYSTEMLOG += string.Format("Get Bosa information...\r\n"); bosaInfo = this._getDataByBosaSN(_BosaSN); if (bosaInfo == null) { testtmp.ERRORCODE = "(Mã Lỗi: COT-BS-0001)"; testtmp.SYSTEMLOG += string.Format("...FAIL. {0}. Bosa SN is not existed\r\n", testtmp.ERRORCODE); testtmp.TOTALRESULT = Parameters.testStatus.FAIL.ToString(); goto END; } testtmp.SYSTEMLOG += string.Format("...Ith= {0}mA\r\n", bosaInfo.Ith); testtmp.SYSTEMLOG += string.Format("...Vbr= {0}V\r\n", bosaInfo.Vbr); testtmp.SYSTEMLOG += string.Format("...PASS\r\n"); } //Calib testtmp.TOTALRESULT = Parameters.testStatus.Wait.ToString(); testtmp.BUTTONCONTENT = "STOP"; testtmp.BUTTONENABLE = false; bool _result = RunAll(testtmp, bosaInfo, vari); testtmp.TOTALRESULT = _result == false ? Parameters.testStatus.FAIL.ToString() : Parameters.testStatus.PASS.ToString(); END: testtmp.SYSTEMLOG += string.Format("\r\n----------------------------\r\nTotal Judged={0}\r\n", testtmp.TOTALRESULT); testtmp.BUTTONCONTENT = "START"; testtmp.BUTTONENABLE = true; //Stop count time st.Stop(); testtmp.SYSTEMLOG += string.Format("Total time = {0} seconds\r\n", st.ElapsedMilliseconds / 1000); testtmp.TOTALTIME += (st.ElapsedMilliseconds / 1000).ToString(); //save log Function.IO.LogDetail.Save(testtmp); Function.IO.LogTest.Save(testtmp); //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~// })); t.IsBackground = true; t.Start(); //***END -------------------------------------------// }
public ActionResult RoleAuthorization(RoleAuthorization model, FormCollection formCollection) { GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>(); model.activeRoles = gnlDB.GetActiveRoles(); ViewBag.Success = true; SessionContext.Current.ActiveUser.FromUpdateButton = model.FromUpdateButton; SessionContext.Current.ActiveUser.SelectedRoleId = model.SelectedRoleId; if (SessionContext.Current.ActiveUser.FromUpdateButton == "1") { try { gnlDB.DeleteRoleRights(model.SelectedRoleId); DataSet dsMenu = BaseDB.DBManager.AppConnection.GetDataSet("select * from gnl_menu"); foreach (DataRow row in dsMenu.Tables[0].Rows) { bool menuRight = false; bool deleteRight = false; bool updateRight = false; bool reportRight = false; bool newRecordRight = false; foreach (var key in formCollection.AllKeys) { string[] arr = key.Split('_'); if (arr.Length > 1) { if (arr[1] != "" && BaseFunctions.getInstance().IsNumeric(arr[1]) && arr[1] == row["menu_id"].ToString()) { if (arr[0] == "Show") { menuRight = true; } if (arr[0] == "Update") { updateRight = true; } if (arr[0] == "Delete") { deleteRight = true; } if (arr[0] == "Report") { reportRight = true; } if (arr[0] == "NewRecord") { newRecordRight = true; } } } } gnl_role_rights rights = new gnl_role_rights(); gnlDB.AddRoleRights(rights, Guid.Parse(model.SelectedRoleId), Convert.ToInt32(row["menu_id"].ToString()), menuRight, updateRight, deleteRight, reportRight, newRecordRight); } ViewBag.ResultMessage = Resources.GlobalResource.transaction_success; } catch (Exception exp) { ViewBag.Success = false; ModelState.AddModelError("Error", exp.Message); } } return(View(model)); }
public static byte[] createCryptKey(byte[] serialNumber, string pin) { string text = BaseFunctions.HexEncoder(serialNumber); return(HashBaseFunction.createBinaryHash(text.Substring(text.Length - 4, 4) + pin + text.Substring(0, 2))); }
public DataSet CrearGuiaTransporte(E_GuiaTransporte CabeceraGuiaTransporte, DataTable DtDetalleGuiaRemisionVenta, string EmpresaSede) { string NumGuiaTransportista; DataSet Ds = new DataSet(); #region crear tabla cabecera DataTable DtCabecera = new DataTable("DtCabecera"); DtCabecera.Columns.Add("NumGuiaTransportista", typeof(string)); DtCabecera.Columns.Add("EmpresaID", typeof(string)); DtCabecera.Columns.Add("NumGuiaRemision", typeof(string)); DtCabecera.Columns.Add("DomicilioPartida", typeof(string)); DtCabecera.Columns.Add("NroDomicilioPartida", typeof(Int32)); DtCabecera.Columns.Add("IntDomicilioPartida", typeof(Int32)); DtCabecera.Columns.Add("ZonaDomicilioPartida", typeof(string)); DtCabecera.Columns.Add("DisDomicilioPartida", typeof(string)); DtCabecera.Columns.Add("ProvDomicilioPartida", typeof(string)); DtCabecera.Columns.Add("DepDomicilioPartida", typeof(string)); DtCabecera.Columns.Add("DomicilioLlegada", typeof(string)); DtCabecera.Columns.Add("NroDomicilioLlegada", typeof(Int32)); DtCabecera.Columns.Add("IntDomicilioLlegada", typeof(Int32)); DtCabecera.Columns.Add("ZonaDomicilioLlegada", typeof(string)); DtCabecera.Columns.Add("DisDomicilioLlegada", typeof(string)); DtCabecera.Columns.Add("ProvDomicilioLlegada", typeof(string)); DtCabecera.Columns.Add("DepDomicilioLlegada", typeof(string)); DtCabecera.Columns.Add("Remitente", typeof(string)); DtCabecera.Columns.Add("RUCRemitente", typeof(string)); DtCabecera.Columns.Add("DireccionRemitente", typeof(string)); DtCabecera.Columns.Add("ObservacionRemitente", typeof(string)); DtCabecera.Columns.Add("Destinatario", typeof(string)); DtCabecera.Columns.Add("RUCDestinatario", typeof(string)); DtCabecera.Columns.Add("DireccionDestinatario", typeof(string)); DtCabecera.Columns.Add("ObservacionDestinatario", typeof(string)); DtCabecera.Columns.Add("Marca", typeof(string)); DtCabecera.Columns.Add("Placa", typeof(string)); DtCabecera.Columns.Add("Carrosa", typeof(string)); DtCabecera.Columns.Add("NombreChofer", typeof(string)); DtCabecera.Columns.Add("DNIChofer", typeof(string)); DtCabecera.Columns.Add("FechaSalida", typeof(DateTime)); DtCabecera.Columns.Add("ConfiguracionVehicular", typeof(string)); DtCabecera.Columns.Add("NroConstInscripcion", typeof(Int32)); DtCabecera.Columns.Add("NroLicTransportista", typeof(string)); DtCabecera.Columns.Add("UsuarioID", typeof(Int32)); DtCabecera.Columns.Add("EstadoID", typeof(Int32)); #endregion #region crear tabla detalle DataTable DtDetalleGuiaTransportista = new DataTable("DetalleGuiaRemisionVenta"); DtDetalleGuiaTransportista.Columns.Add("NumGuiaTransportista", typeof(string)); DtDetalleGuiaTransportista.Columns.Add("ProductoID", typeof(string)); DtDetalleGuiaTransportista.Columns.Add("CantidadEnviada", typeof(decimal)); DtDetalleGuiaTransportista.Columns.Add("NomProducto", typeof(string)); DtDetalleGuiaTransportista.Columns.Add("UnidadMedidaID", typeof(string)); DtDetalleGuiaTransportista.Columns.Add("PesoNeto", typeof(decimal)); #endregion SqlDatabase SqlClient = new SqlDatabase(connectionString); SqlDatabase SqlClientD = new SqlDatabase(connectionString); DbConnection tCnn; tCnn = SqlClient.CreateConnection(); tCnn.Open(); DbTransaction tran = tCnn.BeginTransaction(); try { //acumular de 10 DataTable NewDtDetalleGuiaRemisionVenta = DtDetalleGuiaRemisionVenta.Clone(); foreach (DataRow Dr in DtDetalleGuiaRemisionVenta.Rows) { NewDtDetalleGuiaRemisionVenta.ImportRow(Dr); if (NewDtDetalleGuiaRemisionVenta.Rows.Count == 10)//maximo de lineas que puede contener una guia { //insertar la guia DbCommand SqlCommand = SqlClient.GetStoredProcCommand("Almacen.Usp_InsertGuiaTransportista"); #region Cabecera guia SqlClient.AddInParameter(SqlCommand, "@EmpresaID", SqlDbType.Char, CabeceraGuiaTransporte.EmpresaID); SqlClient.AddInParameter(SqlCommand, "@NumGuiaRemision", SqlDbType.Char, CabeceraGuiaTransporte.NumGuiaRemision); SqlClient.AddInParameter(SqlCommand, "@DomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@NroDomicilioPartida", SqlDbType.Int, CabeceraGuiaTransporte.NroDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@IntDomicilioPartida", SqlDbType.Int, CabeceraGuiaTransporte.IntDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@ZonaDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.ZonaDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DisDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DisDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@ProvDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.ProvDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DepDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DepDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@NroDomicilioLlegada", SqlDbType.Int, CabeceraGuiaTransporte.NroDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@IntDomicilioLlegada", SqlDbType.Int, CabeceraGuiaTransporte.IntDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@ZonaDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.ZonaDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@DisDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DisDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@ProvDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.ProvDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@DepDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DepDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@Remitente", SqlDbType.VarChar, CabeceraGuiaTransporte.Remitente); SqlClient.AddInParameter(SqlCommand, "@RUCRemitente", SqlDbType.Char, CabeceraGuiaTransporte.RUCRemitente); SqlClient.AddInParameter(SqlCommand, "@DireccionRemitente", SqlDbType.VarChar, CabeceraGuiaTransporte.DireccionRemitente); SqlClient.AddInParameter(SqlCommand, "@ObservacionRemitente", SqlDbType.VarChar, CabeceraGuiaTransporte.ObservacionRemitente); SqlClient.AddInParameter(SqlCommand, "@Destinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.Destinatario); SqlClient.AddInParameter(SqlCommand, "@RUCDestinatario", SqlDbType.Char, CabeceraGuiaTransporte.RUCDestinatario); SqlClient.AddInParameter(SqlCommand, "@DireccionDestinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.DireccionDestinatario); SqlClient.AddInParameter(SqlCommand, "@ObservacionDestinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.ObservacionDestinatario); SqlClient.AddInParameter(SqlCommand, "@Marca", SqlDbType.VarChar, CabeceraGuiaTransporte.Marca); SqlClient.AddInParameter(SqlCommand, "@Placa", SqlDbType.VarChar, CabeceraGuiaTransporte.Placa); SqlClient.AddInParameter(SqlCommand, "@Carrosa", SqlDbType.VarChar, CabeceraGuiaTransporte.Carrosa); SqlClient.AddInParameter(SqlCommand, "@NombreChofer", SqlDbType.VarChar, CabeceraGuiaTransporte.NombreChofer); SqlClient.AddInParameter(SqlCommand, "@DNIChofer", SqlDbType.Char, CabeceraGuiaTransporte.DNIChofer); SqlClient.AddInParameter(SqlCommand, "@FechaSalida", SqlDbType.DateTime, CabeceraGuiaTransporte.FechaSalida); SqlClient.AddInParameter(SqlCommand, "@ConfiguracionVehicular", SqlDbType.VarChar, CabeceraGuiaTransporte.ConfiguracionVehicular); SqlClient.AddInParameter(SqlCommand, "@NroConstInscripcion", SqlDbType.Int, CabeceraGuiaTransporte.NroConstInscripcion); SqlClient.AddInParameter(SqlCommand, "@NroLicTransportista", SqlDbType.VarChar, CabeceraGuiaTransporte.NroLicTransportista); SqlClient.AddInParameter(SqlCommand, "@TipoGuia", SqlDbType.Char, CabeceraGuiaTransporte.TipoGuia); SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, CabeceraGuiaTransporte.UsuarioID); SqlClient.AddInParameter(SqlCommand, "@EmpresaSede", SqlDbType.Char, EmpresaSede); #endregion NumGuiaTransportista = Convert.ToString(SqlClient.ExecuteScalar(SqlCommand, tran)); #region Agregar Cabecera DataRow DRC = DtCabecera.NewRow(); DRC["NumGuiaTransportista"] = NumGuiaTransportista; DRC["EmpresaID"] = CabeceraGuiaTransporte.EmpresaID; DRC["NumGuiaRemision"] = CabeceraGuiaTransporte.NumGuiaRemision; DRC["DomicilioPartida"] = CabeceraGuiaTransporte.DomicilioPartida; DRC["NroDomicilioPartida"] = CabeceraGuiaTransporte.NroDomicilioPartida; DRC["IntDomicilioPartida"] = CabeceraGuiaTransporte.IntDomicilioPartida; DRC["ZonaDomicilioPartida"] = CabeceraGuiaTransporte.ZonaDomicilioPartida; DRC["DisDomicilioPartida"] = CabeceraGuiaTransporte.DisDomicilioPartida; DRC["ProvDomicilioPartida"] = CabeceraGuiaTransporte.ProvDomicilioPartida; DRC["DepDomicilioPartida"] = CabeceraGuiaTransporte.DepDomicilioPartida; DRC["DomicilioLlegada"] = CabeceraGuiaTransporte.DomicilioLlegada; DRC["NroDomicilioLlegada"] = CabeceraGuiaTransporte.NroDomicilioLlegada; DRC["IntDomicilioLlegada"] = CabeceraGuiaTransporte.IntDomicilioLlegada; DRC["ZonaDomicilioLlegada"] = CabeceraGuiaTransporte.ZonaDomicilioLlegada; DRC["DisDomicilioLlegada"] = CabeceraGuiaTransporte.DisDomicilioLlegada; DRC["ProvDomicilioLlegada"] = CabeceraGuiaTransporte.ProvDomicilioLlegada; DRC["DepDomicilioLlegada"] = CabeceraGuiaTransporte.DepDomicilioLlegada; DRC["Remitente"] = CabeceraGuiaTransporte.Remitente; DRC["RUCRemitente"] = CabeceraGuiaTransporte.RUCRemitente; DRC["DireccionRemitente"] = CabeceraGuiaTransporte.DireccionRemitente; DRC["ObservacionRemitente"] = CabeceraGuiaTransporte.ObservacionRemitente; DRC["Destinatario"] = CabeceraGuiaTransporte.Destinatario; DRC["RUCDestinatario"] = CabeceraGuiaTransporte.RUCDestinatario; DRC["DireccionDestinatario"] = CabeceraGuiaTransporte.DireccionDestinatario; DRC["ObservacionDestinatario"] = CabeceraGuiaTransporte.ObservacionDestinatario; DRC["Marca"] = CabeceraGuiaTransporte.Marca; DRC["Placa"] = CabeceraGuiaTransporte.Placa; DRC["Carrosa"] = CabeceraGuiaTransporte.Carrosa; DRC["NombreChofer"] = CabeceraGuiaTransporte.NombreChofer; DRC["DNIChofer"] = CabeceraGuiaTransporte.DNIChofer; DRC["FechaSalida"] = CabeceraGuiaTransporte.FechaSalida; DRC["ConfiguracionVehicular"] = CabeceraGuiaTransporte.ConfiguracionVehicular; DRC["NroConstInscripcion"] = CabeceraGuiaTransporte.NroConstInscripcion; DRC["NroLicTransportista"] = CabeceraGuiaTransporte.NroLicTransportista; DRC["UsuarioID"] = CabeceraGuiaTransporte.UsuarioID; DRC["EstadoID"] = 0; DtCabecera.Rows.Add(DRC); #endregion string xml, xmlDetalle; xml = new BaseFunctions().GetXML(NewDtDetalleGuiaRemisionVenta).Replace("NewDataSet", "DocumentElement"); xmlDetalle = xml.Replace("Table", "DetalleGuiaTransportista"); DbCommand SqlCommand2 = SqlClientD.GetStoredProcCommand("Almacen.Usp_Insert_XMLDetalleGuiaTransportistaVenta2"); SqlClientD.AddInParameter(SqlCommand2, "@XML", SqlDbType.Xml, xmlDetalle); SqlClientD.AddInParameter(SqlCommand2, "@NumGuiaTransportista", SqlDbType.Char, NumGuiaTransportista); SqlClientD.ExecuteNonQuery(SqlCommand2, tran); #region agregar detalles foreach (DataRow DR in NewDtDetalleGuiaRemisionVenta.Rows) { DataRow DRD = DtDetalleGuiaTransportista.NewRow(); DRD["NumGuiaTransportista"] = NumGuiaTransportista; DRD["ProductoID"] = DR["ProductoID"]; DRD["CantidadEnviada"] = DR["CantidadEnviada"]; DRD["NomProducto"] = DR["NomProducto"]; DRD["UnidadMedidaID"] = DR["UnidadMedidaID"]; DRD["PesoNeto"] = DR["PesoNeto"]; DtDetalleGuiaTransportista.Rows.Add(DRD); } #endregion SqlCommand2.Dispose(); SqlCommand.Dispose(); NewDtDetalleGuiaRemisionVenta.Rows.Clear(); } } if (NewDtDetalleGuiaRemisionVenta.Rows.Count < 10 & NewDtDetalleGuiaRemisionVenta.Rows.Count > 0)//en caso de que la guia sea menor que 10 { //insertar la guia DbCommand SqlCommand = SqlClient.GetStoredProcCommand("Almacen.Usp_InsertGuiaTransportista"); #region Cabecera guia SqlClient.AddInParameter(SqlCommand, "@EmpresaID", SqlDbType.Char, CabeceraGuiaTransporte.EmpresaID); SqlClient.AddInParameter(SqlCommand, "@NumGuiaRemision", SqlDbType.Char, CabeceraGuiaTransporte.NumGuiaRemision); SqlClient.AddInParameter(SqlCommand, "@DomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@NroDomicilioPartida", SqlDbType.Int, CabeceraGuiaTransporte.NroDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@IntDomicilioPartida", SqlDbType.Int, CabeceraGuiaTransporte.IntDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@ZonaDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.ZonaDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DisDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DisDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@ProvDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.ProvDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DepDomicilioPartida", SqlDbType.VarChar, CabeceraGuiaTransporte.DepDomicilioPartida); SqlClient.AddInParameter(SqlCommand, "@DomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@NroDomicilioLlegada", SqlDbType.Int, CabeceraGuiaTransporte.NroDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@IntDomicilioLlegada", SqlDbType.Int, CabeceraGuiaTransporte.IntDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@ZonaDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.ZonaDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@DisDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DisDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@ProvDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.ProvDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@DepDomicilioLlegada", SqlDbType.VarChar, CabeceraGuiaTransporte.DepDomicilioLlegada); SqlClient.AddInParameter(SqlCommand, "@Remitente", SqlDbType.VarChar, CabeceraGuiaTransporte.Remitente); SqlClient.AddInParameter(SqlCommand, "@RUCRemitente", SqlDbType.Char, CabeceraGuiaTransporte.RUCRemitente); SqlClient.AddInParameter(SqlCommand, "@DireccionRemitente", SqlDbType.VarChar, CabeceraGuiaTransporte.DireccionRemitente); SqlClient.AddInParameter(SqlCommand, "@ObservacionRemitente", SqlDbType.VarChar, CabeceraGuiaTransporte.ObservacionRemitente); SqlClient.AddInParameter(SqlCommand, "@Destinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.Destinatario); SqlClient.AddInParameter(SqlCommand, "@RUCDestinatario", SqlDbType.Char, CabeceraGuiaTransporte.RUCDestinatario); SqlClient.AddInParameter(SqlCommand, "@DireccionDestinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.DireccionDestinatario); SqlClient.AddInParameter(SqlCommand, "@ObservacionDestinatario", SqlDbType.VarChar, CabeceraGuiaTransporte.ObservacionDestinatario); SqlClient.AddInParameter(SqlCommand, "@Marca", SqlDbType.VarChar, CabeceraGuiaTransporte.Marca); SqlClient.AddInParameter(SqlCommand, "@Placa", SqlDbType.VarChar, CabeceraGuiaTransporte.Placa); SqlClient.AddInParameter(SqlCommand, "@Carrosa", SqlDbType.VarChar, CabeceraGuiaTransporte.Carrosa); SqlClient.AddInParameter(SqlCommand, "@NombreChofer", SqlDbType.VarChar, CabeceraGuiaTransporte.NombreChofer); SqlClient.AddInParameter(SqlCommand, "@DNIChofer", SqlDbType.Char, CabeceraGuiaTransporte.DNIChofer); SqlClient.AddInParameter(SqlCommand, "@FechaSalida", SqlDbType.DateTime, CabeceraGuiaTransporte.FechaSalida); SqlClient.AddInParameter(SqlCommand, "@ConfiguracionVehicular", SqlDbType.VarChar, CabeceraGuiaTransporte.ConfiguracionVehicular); SqlClient.AddInParameter(SqlCommand, "@NroConstInscripcion", SqlDbType.Int, CabeceraGuiaTransporte.NroConstInscripcion); SqlClient.AddInParameter(SqlCommand, "@NroLicTransportista", SqlDbType.VarChar, CabeceraGuiaTransporte.NroLicTransportista); SqlClient.AddInParameter(SqlCommand, "@TipoGuia", SqlDbType.Char, CabeceraGuiaTransporte.TipoGuia); SqlClient.AddInParameter(SqlCommand, "@UsuarioID", SqlDbType.Int, CabeceraGuiaTransporte.UsuarioID); SqlClient.AddInParameter(SqlCommand, "@EmpresaSede", SqlDbType.Char, EmpresaSede); #endregion NumGuiaTransportista = Convert.ToString(SqlClient.ExecuteScalar(SqlCommand, tran)); #region Agregar Cabecera DataRow DRC = DtCabecera.NewRow(); DRC["NumGuiaTransportista"] = NumGuiaTransportista; DRC["EmpresaID"] = CabeceraGuiaTransporte.EmpresaID; DRC["NumGuiaRemision"] = CabeceraGuiaTransporte.NumGuiaRemision; DRC["DomicilioPartida"] = CabeceraGuiaTransporte.DomicilioPartida; DRC["NroDomicilioPartida"] = CabeceraGuiaTransporte.NroDomicilioPartida; DRC["IntDomicilioPartida"] = CabeceraGuiaTransporte.IntDomicilioPartida; DRC["ZonaDomicilioPartida"] = CabeceraGuiaTransporte.ZonaDomicilioPartida; DRC["DisDomicilioPartida"] = CabeceraGuiaTransporte.DisDomicilioPartida; DRC["ProvDomicilioPartida"] = CabeceraGuiaTransporte.ProvDomicilioPartida; DRC["DepDomicilioPartida"] = CabeceraGuiaTransporte.DepDomicilioPartida; DRC["DomicilioLlegada"] = CabeceraGuiaTransporte.DomicilioLlegada; DRC["NroDomicilioLlegada"] = CabeceraGuiaTransporte.NroDomicilioLlegada; DRC["IntDomicilioLlegada"] = CabeceraGuiaTransporte.IntDomicilioLlegada; DRC["ZonaDomicilioLlegada"] = CabeceraGuiaTransporte.ZonaDomicilioLlegada; DRC["DisDomicilioLlegada"] = CabeceraGuiaTransporte.DisDomicilioLlegada; DRC["ProvDomicilioLlegada"] = CabeceraGuiaTransporte.ProvDomicilioLlegada; DRC["DepDomicilioLlegada"] = CabeceraGuiaTransporte.DepDomicilioLlegada; DRC["Remitente"] = CabeceraGuiaTransporte.Remitente; DRC["RUCRemitente"] = CabeceraGuiaTransporte.RUCRemitente; DRC["DireccionRemitente"] = CabeceraGuiaTransporte.DireccionRemitente; DRC["ObservacionRemitente"] = CabeceraGuiaTransporte.ObservacionRemitente; DRC["Destinatario"] = CabeceraGuiaTransporte.Destinatario; DRC["RUCDestinatario"] = CabeceraGuiaTransporte.RUCDestinatario; DRC["DireccionDestinatario"] = CabeceraGuiaTransporte.DireccionDestinatario; DRC["ObservacionDestinatario"] = CabeceraGuiaTransporte.ObservacionDestinatario; DRC["Marca"] = CabeceraGuiaTransporte.Marca; DRC["Placa"] = CabeceraGuiaTransporte.Placa; DRC["Carrosa"] = CabeceraGuiaTransporte.Carrosa; DRC["NombreChofer"] = CabeceraGuiaTransporte.NombreChofer; DRC["DNIChofer"] = CabeceraGuiaTransporte.DNIChofer; DRC["FechaSalida"] = CabeceraGuiaTransporte.FechaSalida; DRC["ConfiguracionVehicular"] = CabeceraGuiaTransporte.ConfiguracionVehicular; DRC["NroConstInscripcion"] = CabeceraGuiaTransporte.NroConstInscripcion; DRC["NroLicTransportista"] = CabeceraGuiaTransporte.NroLicTransportista; DRC["UsuarioID"] = CabeceraGuiaTransporte.UsuarioID; DRC["EstadoID"] = 0; DtCabecera.Rows.Add(DRC); #endregion string xml, xmlDetalle; xml = new BaseFunctions().GetXML(NewDtDetalleGuiaRemisionVenta).Replace("NewDataSet", "DocumentElement"); xmlDetalle = xml.Replace("Table", "DetalleGuiaTransportista"); DbCommand SqlCommand2 = SqlClientD.GetStoredProcCommand("Almacen.Usp_Insert_XMLDetalleGuiaTransportistaVenta2"); SqlClientD.AddInParameter(SqlCommand2, "@XML", SqlDbType.Xml, xmlDetalle); SqlClientD.AddInParameter(SqlCommand2, "@NumGuiaTransportista", SqlDbType.Char, NumGuiaTransportista); SqlClientD.ExecuteNonQuery(SqlCommand2, tran); #region agregar detalles foreach (DataRow DR in NewDtDetalleGuiaRemisionVenta.Rows) { DataRow DRD = DtDetalleGuiaTransportista.NewRow(); DRD["NumGuiaTransportista"] = NumGuiaTransportista; DRD["ProductoID"] = DR["ProductoID"]; DRD["CantidadEnviada"] = DR["CantidadEnviada"]; DRD["NomProducto"] = DR["NomProducto"]; DRD["UnidadMedidaID"] = DR["UnidadMedidaID"]; DRD["PesoNeto"] = DR["PesoNeto"]; DtDetalleGuiaTransportista.Rows.Add(DRD); } #endregion SqlCommand2.Dispose(); SqlCommand.Dispose(); NewDtDetalleGuiaRemisionVenta.Rows.Clear(); } tran.Commit(); tCnn.Close(); tCnn.Dispose(); Ds.Tables.Add(DtCabecera); Ds.Tables.Add(DtDetalleGuiaTransportista); return(Ds); } catch (Exception ex) { tran.Rollback(); tCnn.Close(); tCnn.Dispose(); throw new Exception(ex.Message); } }
private void BtnAnular_Click(object sender, EventArgs e) { if (MessageBox.Show("¿Seguro que desea anular la guia de remisión Nro: " + TxtNumGuiaRemision.Text + ".?", "Guia de remisión", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //****************************** anular guia ***************************************** #region Crear Tablas //tabla para actualizar el nuevo stock (agregar productos recepcionados) DataTable DtActuStockLocal = new DataTable(); DtActuStockLocal.TableName = "StockAlmacen"; DtActuStockLocal.Columns.Add("NumRequerimiento", typeof(string)); DtActuStockLocal.Columns.Add("AlmacenID", typeof(string)); DtActuStockLocal.Columns.Add("ProductoID", typeof(string)); DtActuStockLocal.Columns.Add("StockAdicion", typeof(decimal)); #endregion //actualizar datos del requerimiento CL_Requerimientos ObjCL_Requerimientos = new CL_Requerimientos(); CL_GuiaRemision ObjCL_GuiaRemision = new CL_GuiaRemision(); foreach (DataRow Row2 in DtDetalle.Rows) { #region Actualizar Estado Requerimientos string NumRequerimiento; decimal CantidadTransito; string ProductoID; NumRequerimiento = Row2["NumRequerimiento"].ToString(); ProductoID = Row2["ProductoID"].ToString(); CantidadTransito = Convert.ToDecimal(Row2["CantidadEnviada"]); bool Valor; Valor = ObjCL_Requerimientos.UpdateDetalleRequerimientoAnulado(NumRequerimiento, CantidadTransito, ProductoID, AppSettings.UserID, AppSettings.SedeID); if (Valor == false) { MessageBox.Show("ocurrio un error al intentar actualizar el requerimiento: \r\nNumRequerimiento: " + NumRequerimiento + "ProductoID: " + ProductoID + "\r\nCantidadTransito: " + CantidadTransito, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } Valor = ObjCL_GuiaRemision.UpdateGuiaRemisionEstado(TxtGuia.Text, 10, "A", AppSettings.UserID, AppSettings.SedeID); #endregion #region llenar tabla para actualizar el stock local DataRow DrR = DtActuStockLocal.NewRow(); DrR["NumRequerimiento"] = Row2["NumRequerimiento"]; DrR["AlmacenID"] = AppSettings.EmpresaID + AppSettings.SedeID + "000"; DrR["ProductoID"] = Row2["ProductoID"]; DrR["StockAdicion"] = Row2["CantidadEnviada"]; DtActuStockLocal.Rows.Add(DrR); #endregion } #region agrupar para actualizar el stock local //Agrupar los productos apra almacenarlos DataTable DtProducto = new DataTable(); DataTable DtActuStockLocal2 = new DataTable(); DtActuStockLocal2.TableName = "StockAlmacen"; DtActuStockLocal2.Columns.Add("NumRequerimiento", typeof(string)); DtActuStockLocal2.Columns.Add("AlmacenID", typeof(string)); DtActuStockLocal2.Columns.Add("ProductoID", typeof(string)); DtActuStockLocal2.Columns.Add("StockAdicion", typeof(decimal)); DtProducto = new BaseFunctions().SelectDistinct(DtActuStockLocal, "ProductoID", "AlmacenID"); foreach (DataRow RowP in DtProducto.Rows) { DataView Dv = new DataView(DtActuStockLocal); Dv.RowFilter = "ProductoID = '" + RowP["ProductoID"] + "' and AlmacenID = '" + RowP["AlmacenID"] + "'"; decimal Suma = 0; string NumRequerimiento = ""; foreach (DataRowView Drv in Dv) //sumar las cantidades por producto { Suma += Convert.ToDecimal(Drv["StockAdicion"]); NumRequerimiento = Drv["NumRequerimiento"].ToString(); } DataRow DrR = DtActuStockLocal2.NewRow(); DrR["NumRequerimiento"] = NumRequerimiento; DrR["AlmacenID"] = RowP["AlmacenID"]; DrR["ProductoID"] = RowP["ProductoID"]; DrR["StockAdicion"] = Suma; DtActuStockLocal2.Rows.Add(DrR); } #endregion #region Actualizar el stock CL_Almacen ObjCL_Almacen = new CL_Almacen(); foreach (DataRow R in DtActuStockLocal2.Rows) { ObjCL_Almacen.UpdateStockAdidion(R["AlmacenID"].ToString(), R["ProductoID"].ToString(), Convert.ToDecimal(R["StockAdicion"]), R["NumRequerimiento"].ToString(), "R"); } #endregion } MessageBox.Show("Se termino de anular la guía", "Guia remitente", MessageBoxButtons.OK, MessageBoxIcon.Information); }