public DataTable GetByIdFacturaDT(int idFactura) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from fd in bd.facturas_detalles join c in bd.cod_conceptos on fd.id_concepto equals c.id_concepto where fd.id_factura == idFactura select new { c.concepto, valor=fd.importe }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }
public DataTable CargarAcciones(int idSocio) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var _Lista = (from p in bd.acciones where p.id_socio == idSocio orderby p.fecha select new { p.id_accion, p.fecha, p.importe, p.cuotas, p.valor_cuota, p.facturadas, p.pendientes, p.finalizado } ).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(_Lista); } } catch (Exception) { return null; } }
public void OpenNewWindow(Commons.Message msg) { MessageWindow msgWindow = new MessageWindow(msg.Sender.UserName); Statics.MessageWindows.Add(msgWindow); SetMessage(msgWindow, msg); System.Windows.Forms.Application.Run(msgWindow); }
public void Delete(int idConvenio) { using (cooperativaEntities bd = new cooperativaEntities()) { DataTable dtFacturas = new DataTable(); FacturasImplement oFacturasImplement = new FacturasImplement(); var listar = (from f in bd.facturas where f.id_convenio == idConvenio select f).ToList(); Commons oCommons = new Commons(); dtFacturas=oCommons.convertToTable(listar); foreach(DataRow dr in dtFacturas.Rows) { int idFactura = int.Parse(dr["id_factura"].ToString()); facturas oFacturas = new facturas(); oFacturas = oFacturasImplement.Get(idFactura); oFacturas.id_convenio = 0; oFacturasImplement.Update(oFacturas); } var regis = (from p in bd.convenios where p.id_convenio == idConvenio select p).Single(); bd.DeleteObject(regis); bd.SaveChanges(); } }
public static void ProcessMessage(Commons.Message msg,TcpClient tcpClient) { Message response = new Message(); switch (msg.Command) { case Statics.Commands.ADD: // List all the users. Message ack = new Message(); ack.Sender = msg.Sender; ack.Command = Statics.Commands.USERONLINE; foreach(UserWrapper uw in Statics.ExtendedCurrentUsers) { ack.To = uw.User.UserName; if (uw.TcpClient.Connected) Message.Send(ack, uw.TcpClient.GetStream()); } Statics.CurrentUsers.Add(msg.Sender); Statics.ExtendedCurrentUsers.Add(new UserWrapper(msg.Sender, tcpClient)); response = new Message(); response.Command = Statics.Commands.LISTUSERS; response.Text = UserInfo.Serialize(Statics.CurrentUsers); Message.Send(response, tcpClient.GetStream()); break; case Statics.Commands.SENDMSG: UserWrapper userWrapper = (from UserWrapper uw in Statics.ExtendedCurrentUsers where uw.User.UserName.Equals(msg.To) select uw).ToList<UserWrapper>().First(); Message.Send(msg, userWrapper.TcpClient.GetStream()); break; case Commons.Statics.Commands.USEROFFLINE: if (Statics.CurrentUsers.Contains(msg.Sender)) Statics.CurrentUsers.Remove(msg.Sender); break; } }
public DataTable GetByFilterDT(int idBarrio, Boolean SinEstadoActual, int ordenarBy) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from f in bd.facturas join sm in bd.socios_mediciones on f.id_medicion equals sm.id_medicion join s in bd.socios on f.id_socio equals s.id_socio //faltan barrio y demas datos select new { f.id_periodo, f.id_socio, s.codigo_socio, s.nombre, sm.fecha_lectura, sm.consumo, sm.lectura, fechaAnt = String.Empty, lecturaAnt = Decimal.Zero }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception ex) { return null; } }
public void WritePacket(Commons.Networking.AsyncConnection connection, Commons.Networking.ByteBuffer packet) { packet.WriteUInt(0xFFFFFFFF); packet.WriteString(objectType); packet.WriteUInt(_id); packet.WriteLong(0); }
public void WritePacket(Commons.Networking.AsyncConnection connection, Commons.Networking.ByteBuffer packet) { byte[] Msg = new byte[] { 0xB8, 0xC4, 0x05, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00 }; packet.WriteBytes(Msg); }
public void ExecutePacket(Commons.Networking.AsyncConnection connection, Commons.Networking.ByteBuffer packet) { packet.ReadUInt(); packet.ReadShort(); string requestdeObjectName = packet.ReadString(); // OmegaServerProxyObjectName string signature = packet.ReadString(); // b7a6bba3:8ab55405:d7b5d3e1:5bc541f9 packet.ReadString(); // Client uint objectId = packet.ReadUInt(); SignatureService.ClientSignatureResponse(connection, requestdeObjectName, objectId, signature); }
public void SetMessage(MessageWindow messageWindow, Commons.Message message) { if (messageWindow.InvokeRequired) { SetMessageCallback callback = new SetMessageCallback(messageWindow.RecievedNewMessage); messageWindow.Invoke(callback, message.Text, message.Sender.UserName); } else { messageWindow.RecievedNewMessage(message.Text, message.Sender.UserName); } }
public DataTable GetAllByIdMoratoria(int idmoratoria) { DataTable dt = new DataTable(); using (cooperativaEntities bd = new cooperativaEntities()) { var listado = (from p in bd.detalles_moratoria where p.idmoratoria == idmoratoria select p).ToList(); Commons oCommons = new Commons(); dt = oCommons.convertToTable(listado); return dt; } }
public DataTable GetAllDT() { using (cooperativaEntities bd = new cooperativaEntities()) { var listar = (from p in bd.periodos orderby p.id_periodo descending select new { p.id_periodo, periodo = p.id_periodo.Substring(4, 5) + "/" + p.id_periodo.Substring(0, 4) }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(listar); } }
private FECAECabRequest GetCabecera(FacturaTemplate factura, WSFE.Service servicio, WSFE.FEAuthRequest authRequest) { WSFE.FECAECabRequest cabecera = new FECAECabRequest(); try { Commons commonUtilities = new Commons(servicio, authRequest); int? id = commonUtilities.GetTipoComprobanteId(factura.Comprobante, factura.TipoComprobante); cabecera.CbteTipo = id.Value; cabecera.CantReg = 1; //factura.Items.Count(); //Siempre enviamos uno solo. Como mejora a futuro se habla para procesamiento por lotes cabecera.PtoVta = commonUtilities.GetPuntoDeVentaId(factura.ComprobanteRelacionado).Value; } catch (Exception ex) { LoggerManager.Error("Ha ocurrido un error al generar la cabecera", ex); } return cabecera; }
public DataTable GetByProvinciaDT(string Provincia) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from p in bd.cod_provincias where p.provincia.StartsWith(Provincia) select p).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }
public decimal CalcularIVA(int idFactura) { using (cooperativaEntities bd = new cooperativaEntities()) { Commons oCommons = new Commons(); var detallesByFact = (from d in bd.facturas_detalles join c in bd.cod_conceptos on d.id_concepto equals c.id_concepto where d.id_factura == idFactura select new { d.id_factura, d.id_detalle, d.id_concepto, d.idOrden, d.idTipo, d.importe, c.id_formula, c.orden_concepto, c.tipo_signo, c.variable, c.activo, c.aplicar_descuento, c.aplicar_iva, c.aplicar_recargo, c.concepto }).ToList(); DataTable detallesCalc = oCommons.convertToTable(detallesByFact); decimal IVA = 0; foreach (DataRow rowDet in detallesCalc.Rows) { if(bool.Parse(rowDet["aplicar_iva"].ToString())) IVA = IVA + decimal.Parse(rowDet["importe"].ToString()); } int idSocio = 0; FacturasImplement oFacturasImplement = new FacturasImplement(); idSocio = (int)oFacturasImplement.Get(idFactura).id_socio; socios oSocio = new socios(); SocioImplement oSocioImplement = new SocioImplement(); oSocio = oSocioImplement.Get(idSocio); IVA = IVA * (decimal.Parse(oSocio.iva.ToString())/100); return IVA; } }
public ParcelTrackingPageViewModel(IParcelTrackingService parcelTrackingService) { _parcelTrackingService = parcelTrackingService; _parcelTrackingService.IsBusyChanged += (source, args) => { IsBusy = (args as IsBusyEventArgs).IsBusy; }; TrackingNumber = Settings.LastTrackingNumber; TrackCommand = new Command(async() => { Settings.LastTrackingNumber = _trackingNumber; ParcelTrackingModel parcelTracking = null; try { parcelTracking = await _parcelTrackingService.Track(_trackingNumber); string title = parcelTracking.TrackingNumber; string message = $"Tracking: {parcelTracking.TrackingNumber}\n" + (!String.IsNullOrWhiteSpace(parcelTracking.Status) ? $"Status: {parcelTracking.Status}\n" : "") + (!String.IsNullOrWhiteSpace(parcelTracking.Division) ? $"Division: {parcelTracking.Division}\n" : "") + (!String.IsNullOrWhiteSpace(parcelTracking.LastUpdateString) ? $"Last update: {parcelTracking.LastUpdateString}\n" : "") + (!String.IsNullOrWhiteSpace(parcelTracking.Status) ? $"Notes: {parcelTracking.Notes}" : ""); await Application.Current.MainPage.DisplayAlert(title, message, "Ok"); } catch (Exception ex) { await Commons.DisplayAlert("Error", ex.Message, "Ok"); } }); }
private void loadUserShipsInPort(long UserID, bool hideMessage = false) { LOG.Debug("loadUserShipsInPort"); PlayerShipImport Importer = WGAPI.GetPlayerShips(UserID); if (Importer.Status.ToLower().Equals("ok")) { List <PlayerShip> PersonalShips = new List <PlayerShip>(); Dictionary <string, List <PlayerShip> > ImportedShips = Importer.Ships; foreach (KeyValuePair <string, List <PlayerShip> > ShipID in ImportedShips) { foreach (PlayerShip PShip in ShipID.Value) { PersonalShips.Add(PShip); } } string FileName = Commons.GetPersonalShipsFileName(); BinarySerialize.WriteToBinaryFile <List <PlayerShip> >(FileName, PersonalShips); this.PersonalShips.Clear(); foreach (PlayerShip PlayerShipData in PersonalShips) { this.PersonalShips.Add(PlayerShipData.ID); } if (hideMessage == false) { MessageBox.Show("Your ships have been imported.", "Load Personal Data", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { LOG.Warning("Unable to import personal ships: " + Importer.Status); MessageBox.Show("Some error occured during gathering of data. Try again later.", "Connection error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private async void BtnAdd_Click(object sender, RoutedEventArgs e) { bool isValid = true; // 입력된 값이 모두 만족하는지 판별하는 플래그 if (GrdData.SelectedItem == null) { await Commons.ShowMessageAsync("오류", "비활성화할 사용자를 선택하세요"); // MessageBox.Show("비활성화할 사용자를 선택하세요."); return; } if (isValid) { try { var user = GrdData.SelectedItem as Model.User; user.UserActivated = false; // 사용자 비활성화 var result = Logic.DataAccess.SetUser(user); if (result == 0) { await Commons.ShowMessageAsync("오류", "사용자 수정에 실패했습니다"); return; } else { NavigationService.Navigate(new UserList()); } } catch (Exception ex) { Commons.LOGGER.Error($"예외발생 : {ex}"); } } }
/// <summary> /// @author:wp /// @datetime:2016-09-22 /// @desc:分页查询 带输出 /// </summary> /// <typeparam name="TKey"></typeparam> /// <param name="pageIndex">页码</param> /// <param name="pageSize">页容量</param> /// <param name="whereLambda">条件 lambda表达式</param> /// <param name="orderBy">排序 lambda表达式</param> /// <returns></returns> public List <T> GetListByPageer <TKey>(IQueryable <T> query, int pageIndex, int pageSize, ref int rowCount, List <Expression <Func <T, bool> > > parmList, Expression <Func <T, TKey> > orderByLambda, bool isAsc = true, AspNetPager CtrPagerIndex = null) { if (query != null) { if (parmList != null) { foreach (var parm in parmList) { query = query.Where(parm); } } // 分页 一定注意: Skip 之前一定要 OrderBy rowCount = query.FutureCount(); if (CtrPagerIndex != null) { CtrPagerIndex.RecordCount = rowCount; CtrPagerIndex.PageSize = pageSize; CtrPagerIndex.CurrentPageIndex = pageIndex; Commons.SavaChange(CtrPagerIndex); } //Commons.SavaChange(new AspNetPagerTool()); if (isAsc) { return(query.OrderBy(orderByLambda).Skip((pageIndex - 1) * pageSize).Take(pageSize).AsNoTracking().ToList()); } else { return(query.OrderByDescending(orderByLambda).Skip((pageIndex - 1) * pageSize).Take(pageSize).AsNoTracking().ToList()); } } return(null); }
public int GetNewTestMethodId() { EntityTestMethod ldt = new EntityTestMethod(); try { ldt = (from tbl in objData.tblTestMethods where tbl.IsDelete == false orderby tbl.TestMethodId descending select new EntityTestMethod { TestMethodId = (tbl.TestMethodId + 1) }).FirstOrDefault(); } catch (Exception ex) { Commons.FileLog("TestMethodBLL - GetNewTestMethodId()", ex); } if (ldt != null) { return ldt.TestMethodId; } else { return 1; } }
public DataTable GetByNombreDT(string nombre) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from p in bd.cod_calles where p.calle.StartsWith(nombre) select new { Codigo = p.id_calle, p.calle, p.normalizado }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }
private async void BtnDeactive_Click(object sender, RoutedEventArgs e) { try { var user = GrdData.SelectedItem as Model.User; if (GrdData.SelectedItem == null || GrdData.SelectedIndex >= Logic.DataAccess.GetUsers().Count()) { await Commons.ShowMessageAsync("오류", "비활성화할 사용자를 선택하세요."); return; } user.UserActivated = false; Logic.DataAccess.SetUser(user); LoadData(); NavigationService.GoBack(); } catch (Exception ex) { Commons.LOGGER.Error($"예외발생 BtnDeactive_Click : {ex}"); throw ex; } }
private void BtnEdit_Click(object sender, RoutedEventArgs e) { bool isValid = true; // 입력된 값이 모두 만족하는지 판별하는 플래그 LblStoreName.Visibility = LblStoreLocation.Visibility = Visibility.Hidden; isValid = IsVaildInput(); // 유효성 체크 if (isValid) { // MessageBox.Show("DB입력 처리 완료!"); CurrentStore.StoreName = TxtStoreName.Text; CurrentStore.StoreLocation = TxtStoreLocation.Text; try { var result = Logic.DataAccess.SetStore(CurrentStore); Commons.ShowMessageAsync("수정", "수정완료했습니다!"); if (result == 0) { // 수정 안됨 Commons.LOGGER.Error("AddStore.xaml.cs 창고정보 수정오류 발생"); Commons.ShowMessageAsync("오류", "수정시 오류가 발생했습니다"); return; } else { NavigationService.Navigate(new StoreList()); } } catch (Exception ex) { Commons.LOGGER.Error($"예외발생 : {ex}"); } } }
public WeightPageForCombinationViewModel(string combination) { NumberOfAxles = combination.Split(',') .Select((a) => Convert.ToInt32(a)) .ToList(); string imageFile = combination.Replace(',', '_') + ".png"; ImageSource = ImageSourceHelper.GetFromResource(imageFile); PsiTableTruck = DictionaryToList(_psiTableTruckBase); PsiTableTrailerGeneric = DictionaryToList(_psiTableTrailerGenericBase); SelectedIndexA = ApplicationPropertiesHelper.GetProperty(nameof(SelectedIndexA), -1); SelectedIndexB = ApplicationPropertiesHelper.GetProperty(nameof(SelectedIndexB), -1); SelectedIndexC = ApplicationPropertiesHelper.GetProperty(nameof(SelectedIndexC), -1); SelectedIndexD = ApplicationPropertiesHelper.GetProperty(nameof(SelectedIndexD), -1); HelpCommand = new Command(async() => { await Commons.DisplayAlert(AppResources.WeightHelpTitle, AppResources.WeightHelpMessage, "Ok"); }); MaxLegalWeight = (NumberOfAxles[2] > 0) ? 67500 : 5500 + GetMaxWeightForAxle(NumberOfAxles[0]) + GetMaxWeightForAxle(NumberOfAxles[1]); }
private void validateEntry(int idx) { errorLabel.Text = ""; if (isshort) { editShortCode(idx); } if (isshort && IcnNumber.Length < 10) { MessageBox.Show(Commons.GetMessageString("TagReprintIcnNumberInvalid"), "Prompt", MessageBoxButtons.OK); return; if (errorLabel.Text.Length > 0) { errorLabel.Text += System.Environment.NewLine + Commons.GetMessageString("TagReprintIcnNumberInvalid"); } else { errorLabel.Text = Commons.GetMessageString("TagReprintIcnNumberInvalid"); } } if (!isshort && textBoxIcnNumber.Text.Length != 18) { MessageBox.Show(Commons.GetMessageString("TagReprintIcnNumberInvalid"), "Prompt", MessageBoxButtons.OK); if (errorLabel.Text.Length > 0) { errorLabel.Text += System.Environment.NewLine + Commons.GetMessageString("TagReprintIcnNumberInvalid"); } else { errorLabel.Text = Commons.GetMessageString("TagReprintIcnNumberInvalid"); } } }
public async Task <ObjectResultModule> LeaguerInfoList([FromBody] LeaguerInfo PageLeaguer) { if (!Commons.CheckSecret(PageLeaguer.Secret)) { this.ObjectResultModule.StatusCode = 422; this.ObjectResultModule.Message = "Wrong Secret"; this.ObjectResultModule.Object = ""; return(this.ObjectResultModule); } var userid = _IabpSession.UserId > 0 ? (int)_IabpSession.UserId : 0; PageLeaguer.AndAlso(t => !t.IsDelete && t.CreatedBy == userid); if (!string.IsNullOrEmpty(PageLeaguer.Name)) { PageLeaguer.AndAlso(t => t.LeaguerName.Contains(PageLeaguer.Name)); } var value = await _LeaguerService.LeaguerInfoList(PageLeaguer); this.ObjectResultModule.Object = value; this.ObjectResultModule.Message = "sucess"; this.ObjectResultModule.StatusCode = 200; #region 操作日志 var CreateYaeherOperList = new YaeherOperList() { OperExplain = "LeaguerInfoList", OperContent = JsonHelper.ToJson(PageLeaguer), OperType = "LeaguerInfoList", CreatedBy = userid, CreatedOn = DateTime.Now }; var resultLog = await _yaeherOperListService.CreateYaeherOperList(CreateYaeherOperList); #endregion return(this.ObjectResultModule); }
private Boolean CheckInput() { if (txtMa.Text.Trim() == "") { Commons.Message_Warning("Bạn chưa nhập tên đơn vị"); txtMa.Focus(); return(false); } if (txtMaChuong.Text.Trim() == "") { Commons.Message_Warning("Bạn chưa nhập mã đơn vị"); txtMaChuong.Focus(); return(false); } if (grlDmLoaiKhoan.EditValue == null) { Commons.Message_Warning("Bạn chưa chọn loại đơn vị"); grlDmLoaiKhoan.Focus(); return(false); } return(true); }
public void assertAddedNewMessage() { test = ReportsHelper.extent.CreateTest("General Message Test"); this.extent = ReportsHelper.extent; LoginPageSteps loginPageSteps = new LoginPageSteps(driver, test); StatusPanelPageSteps statusPanelPageSteps = new StatusPanelPageSteps(driver, test); TelephonyWindowPageSteps telephonyWindowPageSteps = new TelephonyWindowPageSteps(driver, test); TransactionWindowPageSteps transactionWindowPageSteps = new TransactionWindowPageSteps(driver, test); FunctionMenuPageSteps functionMenuPageSteps = new FunctionMenuPageSteps(driver, test); ChildWindowsPageSteps childWindowPageSteps = new ChildWindowsPageSteps(driver, test); Commons commons = new Commons(driver, this.test); loginPageSteps.loginUsingSeatNo(); statusPanelPageSteps.selectAdminWork(); statusPanelPageSteps.selectFacility(); telephonyWindowPageSteps.telephonyClickRejectAll(); transactionWindowPageSteps.clickCancel(); commons.clickYes(); statusPanelPageSteps.selectMessage(); statusPanelPageSteps.selectGeneralMessage(); telephonyWindowPageSteps.telephonyClickRejectAll(); transactionWindowPageSteps.populateFields(); transactionWindowPageSteps.clickFirstRecord(); transactionWindowPageSteps.clickReturn(); commons.clickOK(); transactionWindowPageSteps.populateMoreFields(); telephonyWindowPageSteps.telephonyClickRejectAll(); transactionWindowPageSteps.clickSendMessageBtn(); transactionWindowPageSteps.clickSendBtn(); transactionWindowPageSteps.clickF12EndCall(); functionMenuPageSteps.selectTransResearch(); childWindowPageSteps.validateAddedRecords("General Message"); statusPanelPageSteps.logOut(); }
private async void BtnAdd_Click(object sender, RoutedEventArgs e)//DB에서 고유키를 걸어줘서 더 이상 중복 데이터가 들어가지 않게 해주는 것이다. DB 디자인에서 UserEmail과 UserIdentityNumber에 대해 Unique키 설정. 스크립트 저장을 하고 나서 테이블 새로고침을 해야 나온다. D { bool isvalid = true; if (GrdData.SelectedItem == null) { await Commons.ShowMessageAsync("오류", "비활성화할 사용자를 선택하세요");//대기된 작업에서 이것이 시행됨 return; } if (isvalid) { try { var user = GrdData.SelectedItem as Model.User; user.UserActivated = false;//사용자 비활성화 var result = Logic.DataAccess.SetUser(user); if (result == 0) { await Commons.ShowMessageAsync("오류", "사용자 수정에 실패했어요"); //대기된 작업에서 이것이 시행됨 return; } else { //정상적 수정됨 NavigationService.Navigate(new UserList()); } } catch (Exception ex)//페이지는 메트로 인트로가 아니기 때문에 메시지 박스가 발생하지 않는다. { Commons.LOGGER.Error($"예외발생 : {ex}"); } } }
//Add ActionPlan public async Task <JsonResult> Add(AddActionPlanViewModel obj) { var userprofile = Session["UserProfile"] as UserProfileVM; obj.OwnerID = userprofile.User.ID; var data = await new ActionPlanDAO().Add(obj);//(item, obj.Subject, obj.Auditor, obj.CategoryID); NotificationHub.SendNotifications(); if (data.ListEmails.Count > 0 && await new SettingDAO().IsSendMail("ADDTASK")) { string contentForPIC = @"<p><b>*PLEASE DO NOT REPLY* this email was automatically sent from the KPI system.</b></p> <p>The account <b>" + data.ListEmails.First()[0].ToTitleCase() + "</b> assigned a task to you in KPI Sytem App. </p>" + "<p>Task name : <b>" + data.ListEmails.First()[3] + "</b></p>" + "<p>Description : " + data.ListEmails.First()[4] + "</p>" + "<p>Link: <a href='" + data.QueryString + "'>Click Here</a></p>"; string contentAuditor = @"<p><b>*PLEASE DO NOT REPLY* this email was automatically sent from the KPI system.</b></p> <p>The account <b>" + data.ListEmailsForAuditor.First()[0].ToTitleCase() + "</b> created a new task ,assigned you are an auditor in KPI Sytem App. </p>" + "<p>Task name : <b>" + data.ListEmailsForAuditor.First()[3] + "</b></p>" + "<p>Description : " + data.ListEmailsForAuditor.First()[4] + "</p>" + "<p>Link: <a href='" + data.QueryString + "'>Click Here</a></p>"; Thread thread = new Thread(() => { Commons.SendMail(data.ListEmailsForAuditor.Select(x => x[1]).ToList(), "[KPI System-03] Action Plan (Add Task - Assign Auditor)", contentAuditor, "Action Plan (Add Task - Assign Auditor)"); }); Thread thread2 = new Thread(() => { Commons.SendMail(data.ListEmails.Select(x => x[1]).ToList(), "[KPI System-03] Action Plan (Add Task)", contentForPIC, "Action Plan (Add Task)"); }); thread.Start(); thread2.Start(); return(Json(new { status = data.Status, isSendmail = true, message = data.Message }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = data.Status, isSendmail = true, message = data.Message }, JsonRequestBehavior.AllowGet)); }
private void BtnAdd_Click(object sender, RoutedEventArgs e) { bool isValid = true; // 입력된 값이 모두 만족하는지 판별하는 플래그 LblStoreLocation.Visibility = LblStoreLocation.Visibility = Visibility.Hidden; var store = new Model.Store(); isValid = IsValidInput(); // 유효성 체크 (빈값 못넣도록 만들어줌, 필수임) if (isValid) { //MessageBox.Show("DB 입력처리!"); store.StoreName = TxtStoreName.Text; store.StoreLocation = TxtStoreLocation.Text; try { var result = Logic.DataAccess.SetStore(store); if (result == 0) { // 수정 안됨 Commons.LOGGER.Error("AddStore.xaml.cs 창고 정보 저장 오류 발생"); Commons.ShowMessageAsync("오류", "저장시 오류가 발생했습니다"); } else { NavigationService.Navigate(new StoreList()); } } catch (Exception ex) { Commons.LOGGER.Error($"예외발생 : {ex}"); } } }
protected override void OnLoad(EventArgs e) { try { if (!this.DesignMode) { DataTable countryTable = GlobalDataAccessor.Instance.DesktopSession.CountryTable; if (countryTable.Rows.Count > 0) { ArrayList countries = new ArrayList(); foreach (DataRow dr in countryTable.Rows) { countries.Add(new CountryData(dr["country_code"].ToString(), dr["country_name"].ToString())); } //Madhu 12/07/2010 fix forbugzilla 10 countries.Insert(0, new CountryData("", "Select One")); this.countryComboBox.DataSource = countries; this.countryComboBox.DisplayMember = "Name"; this.countryComboBox.ValueMember = "Code"; } } //To do: There should be an application wide data structure that holds the country values //which will be used to populate the drop down in case the call to DB could not be completed or //the call did not yield any rows } catch (SystemException ex) { BasicExceptionHandler.Instance.AddException(Commons.GetMessageString("CountryDataFetchError"), ex); } base.OnLoad(e); }
/// <summary> /// 保存每个手机号每分钟调用短讯发送接口的次数 /// 针对每一个手机号都有一个自己的Sorted Set /// key为 LogPhoneCount:phone /// </summary> /// <param name="list"></param> public void PhoneMinuteCount(List <Count> list) { lock (this) { for (int i = 0; i < list.Count; i++) { string sortedSetKey = "LogPhoneMinuteCount:" + list[i].phone; string value = string.Empty; long time = Commons.ConvertDateTimeInt(list[i].time); List <string> listStr = Redis.GetRangeFromSortedSetByLowestScore(sortedSetKey, time, time); if (listStr.Count > 0) { string[] str = listStr[0].Split('_'); value = (Convert.ToInt32(str[0]) + list[i].count).ToString() + "_" + list[i].time.ToString(); Redis.RemoveItemFromSortedSet(sortedSetKey, listStr[0]); } else { value = list[i].count.ToString() + "_" + list[i].time.ToString(); } Redis.AddItemToSortedSet(sortedSetKey, value, time); } } }
private void simpleButton_save_Click(object sender, EventArgs e) { try { Server dbServer = new Server(new ServerConnection(Commons.GetByKey("serverName"), Commons.GetByKey("userDatabase"), "")); Restore restore = new Restore(); restore.Database = "SMO"; // your database name // define options restore.Action = RestoreActionType.Database; restore.Devices.AddDevice(@"C:\SMOTest.bak", DeviceType.File); restore.PercentCompleteNotification = 10; restore.ReplaceDatabase = true; // define a callback method to show progress restore.PercentComplete += new PercentCompleteEventHandler(res_PercentComplete); // execute the restore restore.SqlRestore(dbServer); } catch (Exception ex) { } }
protected void dgvReligion_RowCommand(object sender, GridViewCommandEventArgs e) { try { DataTable ldt = new DataTable(); EditBindCategory(); if (e.CommandName == "EditReligion") { //this.programmaticModalPopupEdit.Show(); int linIndex = Convert.ToInt32(e.CommandArgument); GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; LinkButton lnkReligionCode = (LinkButton)gvr.FindControl("lnkReligionCode"); string lstrReligionCode = lnkReligionCode.Text; txtEditReligionCode.Text = lstrReligionCode; ldt = mobjReligionBLL.GetReligionForEdit(lstrReligionCode); FillControls(ldt); } } catch (Exception ex) { Commons.FileLog("frmAnaesthetistMaster - dgvReligion_RowCommand(object sender, GridViewCommandEventArgs e)", ex); } }
private Boolean CheckInput() { if (txtTenDonVi.Text.Trim() == "") { Commons.Message_Warning("Bạn chưa nhập tên đơn vị"); txtTenDonVi.Focus(); return(false); } if (txtMaDonVi.Text.Trim() == "") { Commons.Message_Warning("Bạn chưa nhập mã đơn vị"); txtMaDonVi.Focus(); return(false); } if (cboDmNganHang.EditValue == null) { Commons.Message_Warning("Bạn chưa chọn loại đơn vị"); cboDmNganHang.Focus(); return(false); } return(true); }
//Term Mode private void cmbTerm_SelectedIndexChanged(System.Object sender, System.EventArgs e) { try { int year_selected = int.Parse(cmbYearTerm.SelectedItem.ToString()); if (cmbTerm.SelectedIndex == 0) { //Term 1 : Month 1, 2, 3 : 1/1 - 31/3 StartTemp = new System.DateTime(year_selected, 1, 1); EndTemp = StartTemp.AddMonths(3).AddDays(-1); } else if (cmbTerm.SelectedIndex == 1) { //Term 2 : Month 4, 5, 6 : 1/4 - 30/6 StartTemp = new System.DateTime(year_selected, 4, 1); EndTemp = StartTemp.AddMonths(3).AddDays(-1); } else if (cmbTerm.SelectedIndex == 2) { //Term 3 : Month 7, 8, 9 : 1/7 - 30/9 StartTemp = new System.DateTime(year_selected, 7, 1); EndTemp = StartTemp.AddMonths(3).AddDays(-1); } else if (cmbTerm.SelectedIndex == 3) { //Term 4 : Month 10, 11, 12 : 1/10 - 31/12 StartTemp = new System.DateTime(year_selected, 10, 1); EndTemp = StartTemp.AddMonths(3).AddDays(-1); } SetValue(); } catch (Exception ex) { Commons.Message_Error(ex); } }
private void workPhoneAreaCode_Leave(object sender, EventArgs e) { if (workPhoneAreaCode.Text.Length == 0) { if (workPhoneNumber.Text.Length > 0) { MessageBox.Show(Commons.GetMessageString("WorkAreaCodeNotEntered")); } //If work phone was set as primary change the primary to home or cell //depending on which one has numbers entered if (radioButtonWorkPhone.Checked) { radioButtonWorkPhone.Checked = false; if (homePhoneAreaCode.Text.Length > 0 && homePhoneNumber.Text.Length > 0) { radioButtonHomePhone.Checked = true; } else if (cellPhoneAreaCode.Text.Length > 0 && cellPhoneNumber.Text.Length > 0) { radioButtonCellPhone.Checked = true; } } } }
public void Embed(Commons.Container container, byte[] message) { }
// Retorna una DT de Socios con los medidores no cargados public DataTable GetEstadosMedidores() { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from s in bd.socios join sc in bd.socios_conexion on s.id_socio equals sc.id_Socio join sm in bd.socios_mediciones on s.id_socio equals sm.id_socio join ces in bd.cod_estados_socios on s.estado equals ces.id_estado_socio where (sc.medidor != "") && ces.facturar == true && sm.lectura == 0 select new { s.id_socio, s.nombre, sm.lectura }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }
private void gvPayments_CellMouseEnter(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex != colReceiptNumber.Index || e.RowIndex < 0) { return; } tooltipPanel.Visible = false; DataGridViewRow row = gvPayments.Rows[e.RowIndex]; LayawayHistoryPaymentInfo paymentInfo = row.Tag as LayawayHistoryPaymentInfo; if (paymentInfo == null || paymentInfo.TenderDataDetails.Count == 0) { return; } tooltipPanel.Controls.Clear(); tooltipPanel.ColumnCount = 2; tooltipPanel.RowCount = paymentInfo.TenderDataDetails.Count + 1; tooltipPanel.Height = (paymentInfo.TenderDataDetails.Count + 2) * 20; tooltipPanel.Width = 275; tooltipPanel.Controls.Add(new Label() { Text = "Amount" }); tooltipPanel.Controls.Add(new Label() { Text = "Tender Type" }); foreach (TenderData tenderData in paymentInfo.TenderDataDetails) { string tenderDescription = Commons.GetTenderDescription(tenderData); tooltipPanel.Controls.Add(new Label() { Text = tenderData.TenderAmount.ToString("c") }); tooltipPanel.Controls.Add(new Label() { Text = tenderDescription, AutoSize = true, AutoEllipsis = true }); } tooltipPanel.ColumnStyles[0].SizeType = SizeType.Percent; tooltipPanel.ColumnStyles[0].Width = 30; tooltipPanel.ColumnStyles[1].SizeType = SizeType.Percent; tooltipPanel.ColumnStyles[1].Width = 70; foreach (RowStyle rowStyle in tooltipPanel.RowStyles) { rowStyle.SizeType = SizeType.Absolute; rowStyle.Height = 20; } Rectangle cellPostition = gvPayments.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true); tooltipPanel.Location = new Point(gvPayments.Location.X + cellPostition.Left, gvPayments.Location.Y + cellPostition.Bottom); tooltipPanel.Visible = true; }
public Asignar_rol_a_usuario() { InitializeComponent(); Commons.getInstance().cargarComboBox("Roles", "nombre", comboBoxRoles); }
//static Lib.Commons p = new Lib.Commons(); static void Main(String[] args) { string weather = string.Empty; Task.Run(async() => { weather = await Helper.Helper.GetWeatherByCity("Bangalore,IN"); }).Wait(); Commons.Init(); int choice; do { if (!string.IsNullOrEmpty(weather)) { Console.WriteLine($"Temperature: {weather} Deg"); } Console.Write("\n-------------MENU--------------"); Console.Write("\n 1. Add Students"); Console.Write("\n 2. Display Students"); Console.Write("\n 3. Update Student detals"); Console.Write("\n 4. Serach Student details"); Console.Write("\n 5. Highest Marks"); Console.Write("\n 6. Exit"); Console.Write("\n----------------------------"); Console.Write("\n Enter your choice: "); var tempChoice = Console.ReadLine(); if (int.TryParse(tempChoice, out choice)) { switch (choice) { case 1: AddStudent(); Console.WriteLine("\n Students Added!!"); break; case 2: Console.WriteLine("The Student Details are: "); DisplayStudents(); break; case 3: UpdateStudent(); Console.WriteLine("\n Students updated!!"); break; case 4: SearchStudent(); break; case 5: HighestAverageStudent(); break; case 6: Environment.Exit(0); break; default: Console.WriteLine("\n Incorrect choice"); break; } Commons.SaveToFile(); } //hello test } while (choice != 6); }
private void BtnExportPdf_Click(object sender, RoutedEventArgs e) { SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.Filter = "PDF File(*.pdf)|*.pdf"; saveDialog.FileName = ""; if (saveDialog.ShowDialog() == true) { // PDF 변환 try { // 0. PDF 사용 폰트 설정 string nanumPath = Path.Combine(Environment.CurrentDirectory, $"NanumGothic.ttf"); // 폰트경로 BaseFont nanumBase = BaseFont.CreateFont(nanumPath, BaseFont.IDENTITY_H, BaseFont.EMBEDDED); var nanumTitle = new iTextSharp.text.Font(nanumBase, 20f); // 20 타이틀용 나눔폰트 var nanumContent = new iTextSharp.text.Font(nanumBase, 12f); // 12 내용 나눔폰트 // iTextSharp.text.Font font = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 12); string pdfFilePath = saveDialog.FileName; // 1.PDF 생성 iTextSharp.text.Document pdfDoc = new Document(PageSize.A4); // 2.PDF 내용 만들기 Paragraph title = new Paragraph("부경대 재고관리시스템(SMS)\n", nanumTitle); Paragraph subtitle = new Paragraph($"사용자리스트 exported : {DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}\n\n", nanumContent); PdfPTable pdfTable = new PdfPTable(GrdData.Columns.Count); pdfTable.WidthPercentage = 100; // 그리드 헤더 작업 foreach (DataGridColumn column in GrdData.Columns) { PdfPCell cell = new PdfPCell(new Phrase(column.Header.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_CENTER; pdfTable.AddCell(cell); } // 각 셀 사이즈 조정 float[] columnsWidth = new float[] { 7f, 15f, 10f, 15f, 27f, 12f, 10f }; pdfTable.SetWidths(columnsWidth); // 그리드 Row 작업 foreach (var item in GrdData.Items) { if (item is Model.User) { var temp = item as Model.User; // UserId PdfPCell cell = new PdfPCell(new Phrase(temp.UserID.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_RIGHT; pdfTable.AddCell(cell); // UserIdentityNumber cell = new PdfPCell(new Phrase(temp.UserIdentityNumber.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); // UserSurName cell = new PdfPCell(new Phrase(temp.UserSurname.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); // UserName cell = new PdfPCell(new Phrase(temp.UserName.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); // UserEmail cell = new PdfPCell(new Phrase(temp.UserEmail.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); // UserAdmin cell = new PdfPCell(new Phrase(temp.UserAdmin.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); // UserActivated cell = new PdfPCell(new Phrase(temp.UserActivated.ToString(), nanumContent)); cell.HorizontalAlignment = Element.ALIGN_LEFT; pdfTable.AddCell(cell); } } // 3.PDF 파일 생성 using (FileStream stream = new FileStream(pdfFilePath, FileMode.OpenOrCreate)) { PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); // 2번에서 만든 내용 추가 pdfDoc.Add(title); pdfDoc.Add(subtitle); pdfDoc.Add(pdfTable); pdfDoc.Close(); stream.Close(); // 안해도됨(선택) } Commons.ShowMessageAsync("PDF변환", "PDF 익스포트 성공했습니다"); } catch (Exception ex) { Commons.LOGGER.Error($"예외발생 BtnExportPdf_Click : {ex}"); } } }
public int ObtenerLecturaAnterior(int idFactura) { int _LectAnt = 0; using (cooperativaEntities bd = new cooperativaEntities()) { Commons oCommons = new Commons(); FacturasImplement oFacturasImplement = new FacturasImplement(); facturas oFactura = new facturas(); oFactura = oFacturasImplement.Get(idFactura); var facturaAnterior = (from f in bd.facturas join m in bd.socios_mediciones on f.id_medicion equals m.id_medicion where f.id_factura < idFactura && f.id_socio == oFactura.id_socio orderby f.id_factura descending select new { f.id_factura, m.lectura }).Take(1).ToList(); if (facturaAnterior.Count>0) _LectAnt = (int)facturaAnterior[0].lectura; } return _LectAnt; }
private void txtCuotas_KeyPress(object sender, KeyPressEventArgs e) { Commons oCommons = new Commons(); oCommons.ValidarNumeroEntero(sender, e); }
public decimal CalcularRecargo(int idFactura) { using (cooperativaEntities bd = new cooperativaEntities()) { Commons oCommons = new Commons(); MySqlCommand _comando = new MySqlCommand(String.Format( "call GetTotalRecargoByFactura('{0}')", idFactura), dbConectorMySql.ObtenerConexion()); MySqlDataReader _reader = _comando.ExecuteReader(); DataTable detallesCalc = new DataTable(); detallesCalc.Load(_reader); decimal Recargo = 0; Recargo = decimal.Parse(detallesCalc.Rows[0][0].ToString()); /*var detallesByFact = (from d in bd.facturas_detalles join c in bd.cod_conceptos on d.id_concepto equals c.id_concepto where d.id_factura == idFactura select new { d.id_factura, d.id_detalle, d.id_concepto, d.idOrden, d.idTipo, d.importe, c.id_formula, c.orden_concepto, c.tipo_signo, c.variable, c.activo, c.aplicar_descuento, c.aplicar_iva, c.aplicar_recargo, c.concepto }).ToList(); DataTable detallesCalc = oCommons.convertToTable(detallesByFact); foreach (DataRow rowDet in detallesCalc.Rows) { if (bool.Parse(rowDet["aplicar_recargo"].ToString())) Recargo = Recargo + decimal.Parse(rowDet["importe"].ToString()); }*/ /* periodos oPeriodo = new periodos(); PeriodosImplement oPeriososImplement = new PeriodosImplement(); FacturasImplement oFacturasImplement = new FacturasImplement(); oPeriodo = oPeriososImplement.Get(oFacturasImplement.Get(idFactura).id_periodo.ToString());*/ TimeSpan diferencia; DateTime fecha_primer_venc=new DateTime(); fecha_primer_venc = DateTime.Parse(detallesCalc.Rows[0][1].ToString()); if (fecha_primer_venc < DateTime.Today) { diferencia = DateTime.Today - DateTime.Parse(fecha_primer_venc.ToString()); } else { diferencia = DateTime.Today - DateTime.Today; } cod_conceptos oCod_conceptos = new cod_conceptos(); ConceptoImplement oConceptoImplement = new ConceptoImplement(); oCod_conceptos = oConceptoImplement.Get(18); decimal? days = diferencia.Days*oCod_conceptos.variable; decimal resultado = 0; if (days >= 0) { resultado = (decimal)days; } int idSocio = 0; idSocio = int.Parse(detallesCalc.Rows[0][2].ToString()); socios oSocio = new socios(); SocioImplement oSocioImplement = new SocioImplement(); oSocio = oSocioImplement.Get(idSocio); tarifas oTarifa = new tarifas(); TarifaImplement oTarifaImplement = new TarifaImplement(); oTarifa = oTarifaImplement.Get(oSocio.id_socio); Recargo = Recargo * resultado; DateTime fecha_segundo_venc = new DateTime(); fecha_segundo_venc = DateTime.Parse(detallesCalc.Rows[0][3].ToString()); if (fecha_segundo_venc > DateTime.Today) { if (oTarifa.cargo_fijo > Recargo) //esto lo hago segun la marca en recargo en tabla tarifas? { Recargo = (decimal)oTarifa.cargo_fijo; } } return Recargo; } }
private WSFE.FECAEDetRequest[] GetDetalles(FacturaTemplate factura, WSFE.Service servicio, WSFE.FEAuthRequest authRequest) { WSFE.FECAEDetRequest[] fedetreq = new WSFE.FECAEDetRequest[1]; try { WSFE.FECAEDetRequest detalle = new FECAEDetRequest(); List<WSFE.AlicIva> alicuota_iva = new List<AlicIva>(); Commons commonsUtilities = new Commons(servicio, authRequest); int tipo_comprobante = commonsUtilities.GetTipoComprobanteId(factura.Comprobante, factura.TipoComprobante).Value; int ptoVta = factura.PuntoDeVenta; int conceptoTipo = commonsUtilities.GetTipoConceptoId(factura.Concepto).Value; int documetoTipo = commonsUtilities.GetTipoDocumentoId(factura.TipoDocumento).Value; detalle.CbteDesde = commonsUtilities.GetComprobanteProximoAAtutorizar(ptoVta, tipo_comprobante) + 1; //numero de comprobante desde detalle.CbteHasta = detalle.CbteDesde; //numero de comprobante hasta detalle.CbteFch = factura.FechaFactura.ToString("yyyyMMdd"); detalle.Concepto = conceptoTipo; detalle.DocTipo = documetoTipo; detalle.DocNro = factura.Cuit; detalle.MonId = "PES";//Siempre pesos detalle.MonCotiz = 1;//Cotizacion de la moneda es siempre 1 porque es pesos if (factura.Concepto.Equals("S")) { detalle.FchServDesde = factura.FechaDesde.ToString("yyyyMMdd"); detalle.FchServHasta = factura.FechaHasta.ToString("yyyyMMdd"); detalle.FchVtoPago = factura.FechaVencimiento.ToString("yyyyMMdd"); } double importeSinIVA = 0; double totalIVA = 0; //Sumamos y calculamos //Como observacion hay que aclarar que el tema de los decimales es bastante complicado y pueden existir //situaciones donde la AFIP rechace las solicitudes por redondeos que se efectuan de distinta manera foreach (FacturaItemsTemplate item in factura.GetItems()) { importeSinIVA += item.Unitario; totalIVA += (item.Unitario * (item.TasaIVA / 100)); WSFE.AlicIva iva = new AlicIva(); iva.BaseImp = item.Unitario; iva.Importe = (item.Unitario * (item.TasaIVA / 100)); iva.Id = commonsUtilities.GetTipoIVAId(item.TasaIVA); alicuota_iva.Add(iva); } detalle.ImpIVA = Math.Round(totalIVA, 2); detalle.ImpNeto = Math.Round(importeSinIVA, 2); detalle.ImpTotal = detalle.ImpIVA + detalle.ImpNeto; detalle.ImpTrib = 0.0; detalle.Iva = alicuota_iva.GroupBy(x => x.Id).Select(x => new WSFE.AlicIva { Id = x.Key, Importe = Math.Round(x.Sum(i => i.Importe), 2), BaseImp = Math.Round(x.Sum(i => i.BaseImp), 2) }).ToArray(); fedetreq[0] = detalle; } catch (Exception ex) { LoggerManager.Error("Ha ocurrido un error al generar el detalle", ex); } return fedetreq; }
/// <summary> /// Инициализация загрузчика /// </summary> /// <param name="configuration">Конфигурация среды</param> public override void Init(Commons.Collections.ExtendedProperties configuration) { this.domainName = (String)configuration["domain"]; }
public void Embed(Commons.Container container, byte[] message) { throw new NotImplementedException(); }
public byte[] Extract(Commons.Container container, Commons.Key key) { throw new NotImplementedException(); }
void ProcessMessage(Commons.Message msg, NetworkStream ns) { Commons.Message response = new Commons.Message(); switch (msg.Command) { case Commons.Statics.Commands.LISTUSERS: // List all the users. Statics.CurrentUsers = Commons.UserInfo.Deserialize(msg.Text); break; case Commons.Statics.Commands.SENDMSG: //Statics.MessageQueue.Add(msg); if (Statics.MessageWindows.Count > 0) { List<string> tags = (from MessageWindow mw in Statics.MessageWindows select mw.Tag.ToString()).ToList<string>(); if (!tags.Contains(msg.Sender.UserName)) { MessageWindow msgWindow = new MessageWindow(msg.Sender.UserName); msgWindow.Show(); Statics.MessageWindows.Add(msgWindow); } else { MessageWindow msw = (MessageWindow)(from MessageWindow mw in Statics.MessageWindows where mw.Tag.ToString().Equals(msg.Sender.UserName) select mw).ToList<MessageWindow>().First<MessageWindow>(); SetMessage(msw, msg); } } else { OpenNewWindow(msg); } break; case Commons.Statics.Commands.USERONLINE: if (!Statics.CurrentUsers.Contains(msg.Sender)) Statics.CurrentUsers.Add(msg.Sender); break; case Commons.Statics.Commands.USEROFFLINE: if (Statics.CurrentUsers.Contains(msg.Sender)) Statics.CurrentUsers.Remove(msg.Sender); break; } }
public MainForm() { InitializeComponent(); aux = new Commons(); }
public DataTable GetByBarrioDT(string Barrio) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from p in bd.cod_barrios where p.barrio.StartsWith(Barrio) select p).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }
public MainController(Form parentForm) { this.parentForm = parentForm; comm = new Commons(); getView(); }
public DataTable GetAllDT() { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from p in bd.cod_conceptos where p.activo.Value select new { p.id_concepto, p.concepto, p.variable }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } }
private void aceptar_Click(object sender, EventArgs e) { // Busco al usuario DataGridViewRow row = Commons.getInstance().getSelectedRow(dgvUsuarios); if (row == null) { MessageBox.Show("No se ha seleccionado ningun usuario"); } else { string nombre = row.Cells[0].Value.ToString(); string apellido = row.Cells[1].Value.ToString(); string dni = row.Cells[2].Value.ToString(); System.Data.SqlClient.SqlDataReader reader; string query = "SELECT * FROM JUST_DO_IT.BuscarUsuario ('" + nombre + "','" + apellido + "'," + dni + ") AS id"; string idUsuario; try { reader = Server.getInstance().query(query); reader.Read(); idUsuario = reader["id"].ToString(); reader.Close(); } catch (Exception ex1) { MessageBox.Show(ex1.Message); return; } // Busco al rol if (comboBoxRoles.Text == "") { MessageBox.Show("No ingresó un rol"); return; } else { string nombreRol = comboBoxRoles.Text; idRol = Rol.obtenerID(nombreRol); } //Asigno Rol - Usuario query = "EXEC JUST_DO_IT.asignarRolAUsuario " + idRol + "," + idUsuario; try { Server.getInstance().realizarQuery(query); MessageBox.Show("El rol se asignó satisfactoriamente"); } catch (Exception ex1) { MessageBox.Show(ex1.Message); } this.Hide(); new Vistas_Inicio.Inicio_Admin().Show(); } }
public override void Init(Commons.Collections.ExtendedProperties configuration) { //nothing to configure }
private void EditGunBookRecord_Load(object sender, EventArgs e) { this.NavControlBox.Owner = this; gunBookData = GlobalDataAccessor.Instance.DesktopSession.GunData; gunItemData = GlobalDataAccessor.Instance.DesktopSession.GunItemData; if (gunBookData != null && gunBookData.Rows.Count > 0) { gunCACCCode = Utilities.GetStringValue(gunBookData.Rows[0]["cat_code"]); currentGunNo.Text = Utilities.GetStringValue(gunBookData.Rows[0]["gun_number"]); originalGunNo.Text = Utilities.GetStringValue(gunBookData.Rows[0]["original_gun_number"]); newGunNo.Text = Utilities.GetStringValue(gunBookData.Rows[0]["new_gun_number"]); status.Text = Utilities.GetStringValue(gunBookData.Rows[0]["status_cd"]); statusDate.Text = Utilities.GetDateTimeValue(gunBookData.Rows[0]["status_date"]).ToString("d", DateTimeFormatInfo.InvariantInfo); gunBound.Text = Utilities.GetStringValue(gunBookData.Rows[0]["gun_bound"]); pageRecord.Text = Utilities.GetStringValue(gunBookData.Rows[0]["gun_page"]) + "/" + Utilities.GetStringValue(gunBookData.Rows[0]["record_number"]); manufacturer.Text = Utilities.GetStringValue(gunBookData.Rows[0]["manufacturer"]); model.Text = Utilities.GetStringValue(gunBookData.Rows[0]["model"]); serialNumber.Text = Utilities.GetStringValue(gunBookData.Rows[0]["serial_number"]); caliber.Text = Utilities.GetStringValue(gunBookData.Rows[0]["caliber"]); type.Text = Utilities.GetStringValue(gunBookData.Rows[0]["gun_type"]); importer.Text = Utilities.GetStringValue(gunBookData.Rows[0]["importer"]); icnDocType = Utilities.GetStringValue(gunBookData.Rows[0]["icn_doc_type"]); icn.Text = Utilities.IcnGenerator(Utilities.GetIntegerValue(gunBookData.Rows[0]["icn_store"]), Utilities.GetIntegerValue(gunBookData.Rows[0]["icn_year"]), Utilities.GetIntegerValue(gunBookData.Rows[0]["icn_doc"]), Utilities.GetStringValue(gunBookData.Rows[0]["icn_doc_type"]), Utilities.GetIntegerValue(gunBookData.Rows[0]["icn_item"]), Utilities.GetIntegerValue(gunBookData.Rows[0]["icn_sub_item"])); //acquisition data acquireCustNumber = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_customer_number"]); acquisitionCustomerNo.Text = acquireCustNumber; acquireTransactionType = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_transaction_type"]); acquisitionType.Text = acquireTransactionType; acquireCustFirstName = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_first_name"]); acquireCustLastName = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_last_name"]); acquireCustMiddleName = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_middle_initial"]); acquisitionName.Text = acquireCustFirstName + " " + acquireCustMiddleName + " " + acquireCustLastName; acquisitionTicket.Text = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_document_number"]); acquireCustomerAddress1 = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_address"]); acquisitionAddress1.Text = acquireCustomerAddress1; acquireCustomerCity = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_city"]); acquireCustomerState = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_state"]); acquireCustomerZipcode = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_postal_code"]); acquisitionAddress2.Text = acquireCustomerCity + "," + acquireCustomerState + " " + acquireCustomerZipcode; acquisitionDate.Text = Utilities.GetDateTimeValue(gunBookData.Rows[0]["acquire_date"]).ToShortDateString(); acquireCustIDType = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_id_type"]); acquireCustIDNumber = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_id_number"]); acquireCustIDAgency = Utilities.GetStringValue(gunBookData.Rows[0]["acquire_id_agency"]); acquisitionID.Text = acquireCustIDType + " " + acquireCustIDAgency + " " + acquireCustIDNumber; //disposition data dispositionCustNumber = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_customer_number"]); dispositionCustomerNo.Text = dispositionCustNumber; dispTransactionType = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_transaction_type"]); dispositionType.Text = dispTransactionType; dispositionCustLastName = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_last_name"]); dispositionCustFirstName = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_first_name"]); dispositionCustMiddleName = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_middle_initial"]); dispositionName.Text = dispositionCustFirstName + " " + dispositionCustMiddleName + " " + dispositionCustLastName; dispositionTicket.Text = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_document_number"]); dispositionCustomerAddress1 = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_address"]); dispositionAddress1.Text = dispositionCustomerAddress1; dispositionCustomerCity = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_city"]); dispositionCustomerState = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_state"]); dispositionCustomerZipcode = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_postal_code"]); dispositionAddress2.Text = dispositionCustomerCity + "," + dispositionCustomerState + " " + dispositionCustomerZipcode; dispositionDate.Text = Utilities.GetDateTimeValue(gunBookData.Rows[0]["disposition_date"]).ToShortDateString(); dispositionCustIDType = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_id_type"]); dispositionCustIDAgency = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_id_agency"]); dispositionCustIDNumber = Utilities.GetStringValue(gunBookData.Rows[0]["disposition_id_number"]); dispositionID.Text = dispositionCustIDType + " " + dispositionCustIDAgency + " " + dispositionCustIDNumber; string gunStatus = Utilities.GetStringValue((gunBookData.Rows[0]["status_cd"])); if (gunStatus == "VO" || gunStatus == "PS") { labelErrMessage.Text = Commons.GetMessageString("GunEditError"); DisableActions(); } if (string.IsNullOrEmpty(dispositionCustNumber)) { DispositionReplace.Enabled = false; DispositionEdit.Enabled = false; } if (!SecurityProfileProcedures.CanUserModifyResource("EDIT GUN BOOK", GlobalDataAccessor.Instance.DesktopSession.LoggedInUserSecurityProfile, CashlinxPawnSupportSession.Instance) && !SecurityProfileProcedures.CanUserModifyResource("EDIT RESTRICTED GUN BOOK FIELDS", GlobalDataAccessor.Instance.DesktopSession.LoggedInUserSecurityProfile, CashlinxPawnSupportSession.Instance)) { firearmDescEdit.Enabled = false; AcquisitionEdit.Enabled = false; AcquisitionReplace.Enabled = false; DispositionEdit.Enabled = false; DispositionReplace.Enabled = false; } if (string.IsNullOrEmpty(acquireCustNumber)) { AcquisitionEdit.Enabled = false; AcquisitionReplace.Enabled = false; } if (acquireTransactionType == "T" || acquireTransactionType == "C") { AcquisitionEdit.Enabled = false; AcquisitionReplace.Enabled = false; } if (dispTransactionType == "T" || dispTransactionType == "C") { DispositionReplace.Enabled = false; DispositionEdit.Enabled = false; } } else { labelErrMessage.Text = "Gun Book data not found"; DisableActions(); } }
public DataTable GetByIdSocioDT(int idSocio) { try { using (cooperativaEntities bd = new cooperativaEntities()) { var Listar = (from f in bd.facturas join sm in bd.socios_mediciones on f.id_medicion equals sm.id_medicion where f.id_socio == idSocio select new { f.id_periodo, sm.fecha_lectura, sm.consumo, sm.lectura, fechaAnt = (from f2 in bd.facturas join sm2 in bd.socios_mediciones on f2.id_medicion equals sm2.id_medicion where f2.id_socio == idSocio & sm2.fecha_lectura < sm.fecha_lectura orderby sm2.fecha_lectura descending select new { sm2.fecha_lectura }).First(), lecturaAnt = (from f2 in bd.facturas join sm2 in bd.socios_mediciones on f2.id_medicion equals sm2.id_medicion where f2.id_socio == idSocio & sm2.fecha_lectura < sm.fecha_lectura orderby sm2.fecha_lectura descending select new { sm2.lectura }).First() }).ToList(); Commons oCommons = new Commons(); return oCommons.convertToTable(Listar); } } catch (Exception) { return null; } }