/*@Autor Alfredo Santiago Alvarado * * * */ static void Main(string[] args) { SqlConnections sql = new SqlConnections(); string consulta = "Select empleados.correo AS CORREOUSUARIO,subjefes.correo AS CORREOSUBJEFE,jefes.CORREO AS CORREOJEFE,DIRECTORES.CORREO AS CORREODIRECTOR ,AAAUSER.FIRST_NAME,WORKORDER.WORKORDERID AS Ticket ,WORKORDERStates.StatusID,convert(date,dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (WORKORDER.CREATEDTIME/1000),'1970-01-01 00:00:00'),110) 'Created Time' " + "from WORKORDER (nolock) " + "INNER JOIN WORKORDERStates " + "ON WORKORDER.WORKORDERID = WORKORDERStates.WORKORDERID " + "Inner JOIN AAAUSER " + "ON WORKORDER.requesterid = AAAUSER.USER_ID " + "LEFT JOIN empleados " + "ON WORKORDER.requesterid = empleados.user_id " + "LEFT JOIN subjefes " + "ON empleados.subjefe_id = subjefes.user_id " + "LEFT JOIN jefes " + "ON empleados.jefe_id = JEFES.user_id " + "LEFT JOIN directores " + "ON empleados.director_id = directores.user_id " + "WHERE dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (WORKORDER.CREATEDTIME/1000),'1970-01-01 00:00:00') >= convert(varchar,CONVERT (date, GETDATE()-4),21) " + "AND WORKORDERStates.statusid = 301 "; sql.consulta(consulta); // Console.WriteLine(sql.difDate("select DATEDIFF (day ,'2015-08-26' , CONVERT (date, SYSDATETIME())) AS diferencia")); // email.sendEMailThroughOUTLOOK("*****@*****.**"); }
private bool ValidateExistingUser(ref string username, string password, UserDefinition user) { username = user.Username; if (user.IsActive != 1) { if (Log.IsInfoEnabled) { Log.Error(String.Format("Inactive user login attempt: {0}", username), this.GetType()); } return(false); } // prevent more than 50 invalid login attempts in 30 minutes var throttler = new Throttler("ValidateUser:"******"site" || user.Source == "sign" || directoryService == null) { if (validatePassword()) { throttler.Reset(); return(true); } return(false); } if (user.Source != "ldap") { throw new ArgumentOutOfRangeException("userSource"); } if (!string.IsNullOrEmpty(user.PasswordHash) && user.LastDirectoryUpdate != null && user.LastDirectoryUpdate.Value.AddHours(1) >= DateTime.Now) { if (validatePassword()) { throttler.Reset(); return(true); } return(false); } DirectoryEntry entry; try { entry = directoryService.Validate(username, password); if (entry == null) { return(false); } throttler.Reset(); } catch (Exception ex) { Log.Error("Error on directory access", ex, this.GetType()); // couldn't access directory. allow user to login with cached password if (!user.PasswordHash.IsTrimmedEmpty()) { if (validatePassword()) { throttler.Reset(); return(true); } return(false); } throw; } try { string salt = user.PasswordSalt.TrimToNull(); var hash = UserRepository.GenerateHash(password, ref salt); var displayName = entry.FirstName + " " + entry.LastName; var email = entry.Email.TrimToNull() ?? user.Email ?? (username + "@yourdefaultdomain.com"); using (var connection = SqlConnections.NewFor <UserRow>()) using (var uow = new UnitOfWork(connection)) { var fld = UserRow.Fields; new SqlUpdate(fld.TableName) .Set(fld.DisplayName, displayName) .Set(fld.PasswordHash, hash) .Set(fld.PasswordSalt, salt) .Set(fld.Email, email) .Set(fld.LastDirectoryUpdate, DateTime.Now) .WhereEqual(fld.UserId, user.UserId) .Execute(connection, ExpectedRows.One); uow.Commit(); UserRetrieveService.RemoveCachedUser(user.UserId, username); } return(true); } catch (Exception ex) { Log.Error("Error while updating directory user", ex, this.GetType()); return(true); } }
private IDbConnection GetConnection() { return(SqlConnections.New(connectionString, providerName)); }
void GridArayuzleriKaydet(Control ctrl) { DevExpress.XtraGrid.GridControl gc = new GridControl(); gc = ctrl as DevExpress.XtraGrid.GridControl; DevExpress.XtraGrid.Views.Grid.GridView gv = (DevExpress.XtraGrid.Views.Grid.GridView)gc.Views[0]; string Layout = ""; using (var ms = new MemoryStream()) { gv.SaveLayoutToStream(ms); ms.Position = 0; using (var reader = new StreamReader(ms)) Layout = reader.ReadToEnd(); } cs.csGridLayout.InsertLayout(Convert.ToInt32(frmKullaniciGiris.KullaniciID), this.Name, gv.Name, Layout, SqlConnections.GetBaglanti(), trGenel); }
public List <SimpleReportViewModel> Queries(DateTime start, DateTime end, int consumerId, List <int?> meterId, List <int> parameterId) { var lstModel = new List <SimpleReportViewModel>(); bool isAdmin = false; bool isOperator = false; bool isConsumer = false; using (var connection = SqlConnections.NewByKey("Default")) { if (isAdmin) { List <MeterRow> meters = connection.List <MeterRow>(); List <MeterDetailRow> meterDetails = new List <MeterDetailRow>(); meterDetails.AddRange(connection.List <MeterDetailRow>().FindAll(md => meterId.Contains(md.MeterId))); foreach (var item in meterDetails) { var x = connection.ById <SchedulingRow>(item.SchedulingId); lstModel.Add(new SimpleReportViewModel { DimensionOne = x.FullDate.ToString(), Quantity = int.Parse(item.Value) }); } return(lstModel); } if (isOperator) { List <MeterRow> meters = new List <MeterRow>(); var meterRows = connection.List <MeterRow>(); meters = meterRows.FindAll(m => m.ConsumerId == consumerId); List <MeterDetailRow> meterDetails = new List <MeterDetailRow>(); foreach (var item in meters) { meterDetails.AddRange(connection.List <MeterDetailRow>().FindAll(md => md.MeterId == item.MeterId)); } foreach (var item in meterDetails) { var x = connection.ById <SchedulingRow>(item.SchedulingId); lstModel.Add(new SimpleReportViewModel { DimensionOne = x.FullDate.ToString(), Quantity = int.Parse(item.Value) }); } return(lstModel); } if (isConsumer) { List <MeterRow> meters = new List <MeterRow>(); var meterRows = connection.List <MeterRow>(); meters = meterRows.FindAll(m => m.ConsumerId == consumerId); List <MeterDetailRow> meterDetails = new List <MeterDetailRow>(); foreach (var item in meters) { meterDetails.AddRange(connection.List <MeterDetailRow>().FindAll(md => md.MeterId == item.MeterId)); } foreach (var item in meterDetails) { var x = connection.ById <SchedulingRow>(item.SchedulingId); lstModel.Add(new SimpleReportViewModel { DimensionOne = x.FullDate.ToString(), Quantity = int.Parse(item.Value) }); } return(lstModel); } } return(lstModel); }
/// <summary> /// Automatically creates a database for the template if it doesn't already exists. /// You might delete this method to disable auto create functionality. /// </summary> private static void EnsureDatabase(string databaseKey) { var cs = SqlConnections.GetConnectionString(databaseKey); var serverType = cs.Dialect.ServerType; bool isSql = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase); bool isPostgres = !isSql& serverType.StartsWith("Postgres", StringComparison.OrdinalIgnoreCase); bool isMySql = !isSql && !isPostgres && serverType.StartsWith("MySql", StringComparison.OrdinalIgnoreCase); bool isSqlite = !isSql && !isPostgres && !isMySql && serverType.StartsWith("Sqlite", StringComparison.OrdinalIgnoreCase); if (!isSql && !isPostgres && !isMySql && !isSqlite) { return; } var cb = cs.ProviderFactory.CreateConnectionStringBuilder(); cb.ConnectionString = cs.ConnectionString; string catalogKey = "?"; if (isSqlite) { catalogKey = "Data Source"; if (!cb.ContainsKey(catalogKey)) { return; } var dataFile = cb[catalogKey] as string; if (string.IsNullOrEmpty(dataFile)) { return; } dataFile = dataFile.Replace("|DataDirectory|", HostingEnvironment.MapPath("~/App_Data/")); if (File.Exists(dataFile)) { return; } Directory.CreateDirectory(Path.GetDirectoryName(dataFile)); using (var sqliteConn = SqlConnections.New(cb.ConnectionString, cs.ProviderName)) { var createFile = ((WrappedConnection)sqliteConn).ActualConnection.GetType().GetMethod("CreateFile", BindingFlags.Static); if (createFile != null) { createFile.Invoke(null, new object[] { dataFile }); } } SqlConnection.ClearAllPools(); return; } foreach (var ck in new[] { "Initial Catalog", "Database", "AttachDBFilename" }) { if (cb.ContainsKey(ck)) { catalogKey = ck; break; } } var catalog = cb[catalogKey] as string; cb[catalogKey] = null; using (var serverConnection = SqlConnections.New(cb.ConnectionString, cs.ProviderName)) { try { serverConnection.Open(); } catch (SqlException ex) { if (ex.ErrorCode != -2146232060) { throw; } const string oldVer = @"\v11.0"; if (cb.ConnectionString.IndexOf(oldVer) >= 0) { throw new Exception( "You don't seem to have SQL Express LocalDB 2012 installed.\r\n\r\n" + "If you have Visual Studio 2015 (with SQL LocalDB 2014) " + "try changing '" + databaseKey + "' connection string in WEB.CONFIG to:\r\n\r\n" + cs.ConnectionString.Replace(oldVer, @"\MSSqlLocalDB") + "\r\n\r\nor:\r\n\r\n" + cs.ConnectionString.Replace(oldVer, @"\v12.0") + "';\r\n\r\n" + "You can also try another SQL server type like .\\SQLExpress."); } throw; } string databasesQuery = "SELECT * FROM sys.databases WHERE NAME = @name"; string createDatabaseQuery = @"CREATE DATABASE [{0}]"; if (isPostgres) { databasesQuery = "select * from postgres.pg_catalog.pg_database where datname = @name"; createDatabaseQuery = "CREATE DATABASE \"{0}\""; } else if (isMySql) { databasesQuery = "SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = @name"; createDatabaseQuery = "CREATE DATABASE `{0}`"; } if (serverConnection.Query(databasesQuery, new { name = catalog }).Any()) { return; } var isLocalServer = isSql && serverConnection.ConnectionString.IndexOf(@"(localdb)\", StringComparison.OrdinalIgnoreCase) >= 0 || serverConnection.ConnectionString.IndexOf(@".\") >= 0; string command; if (isLocalServer) { var filename = Path.Combine(HostingEnvironment.MapPath("~/App_Data"), catalog); command = String.Format(@"CREATE DATABASE [{0}] ON PRIMARY (Name = N'{0}', FILENAME = '{1}.mdf') LOG ON (NAME = N'{0}_log', FILENAME = '{1}.ldf')", catalog, filename); if (File.Exists(filename + ".mdf")) { command += " FOR ATTACH"; } } else { command = String.Format(createDatabaseQuery, catalog); } serverConnection.Execute(command); SqlConnection.ClearAllPools(); } }
private static void RunMigrations(string databaseKey) { var cs = SqlConnections.GetConnectionString(databaseKey); var connection = cs.ConnectionString; string serverType = cs.Dialect.ServerType; bool isSqlServer = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase); bool isOracle = serverType.StartsWith("Oracle", StringComparison.OrdinalIgnoreCase); bool isFirebird = serverType.StartsWith("Firebird", StringComparison.OrdinalIgnoreCase); // safety check to ensure that we are not modifying an arbitrary database. // remove these lines if you want MovieTutorial migrations to run on your DB. //if (!isOracle && cs.ConnectionString.IndexOf(typeof(DataMigrations).Namespace + // @"_" + databaseKey + "_v1", StringComparison.OrdinalIgnoreCase) < 0) //{ // SkippedMigrations = true; // return; //} string databaseType = isOracle ? "OracleManaged" : serverType; using (var sw = new StringWriter()) { Announcer announcer = isOracle || isFirebird ? new TextWriterAnnouncer(sw) { ShowSql = true } : new TextWriterWithGoAnnouncer(sw) { ShowSql = true }; var runner = new RunnerContext(announcer) { Database = databaseType, Connection = cs.ConnectionString, #if COREFX TargetAssemblies = new[] { typeof(DataMigrations).Assembly }, #else Targets = new string[] { typeof(DataMigrations).Assembly.Location }, #endif Task = "migrate:up", WorkingDirectory = Path.GetDirectoryName(typeof(DataMigrations).Assembly.Location), Namespace = "MovieTutorial.Migrations." + databaseKey + "DB", Timeout = 90 }; var culture = CultureInfo.CurrentCulture; try { if (isFirebird) { Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; } new TaskExecutor(runner) { #if COREFX ConnectionString = cs.ConnectionString #endif }.Execute(); } catch (Exception ex) { var output = sw.ToString().Trim(); if (output.StartsWith("/*")) { var idx = output.IndexOf("*/"); output = output.Substring(idx + 2); } throw new Exception("Error executing migration:\r\n" + output, ex); } finally { if (isFirebird) { Thread.CurrentThread.CurrentCulture = culture; } } } }
private void cbtnUretildi_Click(object sender, EventArgs e) { if (XtraMessageBox.Show("Üretim Emri Durumu 'Üretildi' Olarak Değiştirilecek.\n{Üretim Fişleri oluşturulacak.}\nOnaylıyor musunuz?", "ARES", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.No) { return; } int SeciliSatir = gvUretimEmri.FocusedRowHandle; int UretimEmriID = (int)gvUretimEmri.GetFocusedRowCellValue("UretimEmriID"); int CiktiStokID = -1; #region REÇETEDEKİ ÇIKTI STOK BİLGİSİ ALINIYOR using (SqlCommand cmd = new SqlCommand(@"SELECT StokID FROM dbo.ReceteDetail WHERE (SatirTur = 1) AND (ReceteMasterID = @ReceteMasterID)", SqlConnections.GetBaglanti())) { cmd.Parameters.Add("@ReceteMasterID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("ReceteMasterID").ToString(); using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult)) { if (dr.Read()) { CiktiStokID = (int)dr["StokID"]; } } } #endregion #region ÇIKTI SATIRI UretimFis TABLOSUNA KAYDEDİLİYOR. //using (SqlCommand cmd = new SqlCommand(@"Insert Into UretimFis(UretimEmriID, FisTuru, ModulNo, GirisCikis, FisNo, DepoID, StokID, Miktar) Values(@UretimEmriID, @FisTuru, @ModulNo, @GirisCikis, @FisNo, @DepoID, @StokID, @Miktar)", SqlConnections.GetBaglanti())) //{ // cmd.Parameters.Add("@UretimEmriID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("UretimEmriID").ToString(); // cmd.Parameters.Add("@FisTuru", SqlDbType.Int).Value = "13"; //13:üretimden giriş fişi, // cmd.Parameters.Add("@ModulNo", SqlDbType.Int).Value = "3"; //3: Malzeme yönetimi // cmd.Parameters.Add("@GirisCikis", SqlDbType.Int).Value = "0"; // cmd.Parameters.Add("@FisNo", SqlDbType.NVarChar).Value = gvUretimEmri.GetFocusedRowCellValue("PartiNo").ToString(); // cmd.Parameters.Add("@DepoID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("UretimdenGirisAmbarID").ToString(); // cmd.Parameters.Add("@StokID", SqlDbType.Int).Value = CiktiStokID; // cmd.Parameters.Add("@Miktar", SqlDbType.Decimal).Value = CiktiMiktariniGetir(); // cmd.ExecuteNonQuery(); //} #endregion #region STOKFIS VE STOKFISDETAY TABLOLARINA KAYIT EKLENİYOR. int StokFisID = 0; #region Stok Fiş using (SqlCommand cmdMaster = new SqlCommand( @"INSERT INTO StokFis( StokFisNo, FisTarihi, FisTuru, GirisCikis, ModulNo, CikisAmbarID, GirisAmbarID) VALUES(@StokFisNo,@FisTarihi,@FisTuru,@GirisCikis,@ModulNo,@CikisAmbarID,@GirisAmbarID) SET @YeniID = SCOPE_IDENTITY()", SqlConnections.GetBaglanti())) { cmdMaster.Parameters.Add("@StokFisNo", SqlDbType.NVarChar).Value = gvUretimEmri.GetFocusedRowCellValue("PartiNo").ToString(); cmdMaster.Parameters.Add("@FisTarihi", SqlDbType.DateTime).Value = gvUretimEmri.GetFocusedRowCellValue("UretimTarihi").ToString(); cmdMaster.Parameters.Add("@FisTuru", SqlDbType.Int).Value = 13; //Üretimden Giriş Fişi cmdMaster.Parameters.Add("@GirisCikis", SqlDbType.Int).Value = 1; cmdMaster.Parameters.Add("@ModulNo", SqlDbType.Int).Value = 3; //Malzeme Yönetimi cmdMaster.Parameters.Add("@CikisAmbarID", SqlDbType.Int).Value = -1; cmdMaster.Parameters.Add("@GirisAmbarID", SqlDbType.Int).Value = -1; cmdMaster.Parameters.Add("@YeniID", SqlDbType.Int).Direction = ParameterDirection.Output; cmdMaster.ExecuteNonQuery(); StokFisID = Convert.ToInt32(cmdMaster.Parameters["@YeniID"].Value.ToString()); } #endregion #region StokFisDetay DataTable dtFisDetay = new DataTable(); using (SqlDataAdapter da = new SqlDataAdapter(@" SELECT SatirTur, StokID, Miktar, UretimMiktar FROM dbo.ReceteDetail WHERE (ReceteMasterID = @ReceteMasterID)", SqlConnections.GetBaglanti())) { da.SelectCommand.Parameters.Add("@ReceteMasterID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("ReceteMasterID").ToString(); dtFisDetay.Clear(); da.Fill(dtFisDetay); } int SiraNo = 0; foreach (DataRow row in dtFisDetay.AsEnumerable()) { //ReceteDetail.SatirTur -> 1: Çıktı, 2: Hammadde #region ÇIKTI SATIRI İŞLEMİ using (SqlCommand cmdDetail = new SqlCommand( @"INSERT INTO StokFisDetay(FisTuru, ModulNo, GirisCikis, StokID, StokFisID, SatirNo, Miktar, CikisAmbarID) VALUES(13,3,@GirisCikis,@StokID,@StokFisID,@SatirNo,@Miktar,@CikisAmbarID)", SqlConnections.GetBaglanti())) { SiraNo++; if (row["SatirTur"].ToString() == "1") { cmdDetail.Parameters.Add("@GirisCikis", SqlDbType.Int).Value = 1; } else if (row["SatirTur"].ToString() == "2") { cmdDetail.Parameters.Add("@GirisCikis", SqlDbType.Int).Value = 0; } cmdDetail.Parameters.Add("@StokID", SqlDbType.Int).Value = row["StokID"].ToString(); cmdDetail.Parameters.Add("@SatirNo", SqlDbType.Int).Value = SiraNo; cmdDetail.Parameters.Add("@Miktar", SqlDbType.Decimal).Value = row["Miktar"].ToString(); string a = gvUretimEmri.GetFocusedRowCellValue("UretimdenGirisAmbarID").ToString(); cmdDetail.Parameters.Add("@CikisAmbarID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("UretimdenGirisAmbarID").ToString(); cmdDetail.Parameters.Add("@StokFisID", SqlDbType.Int).Value = StokFisID; cmdDetail.ExecuteNonQuery(); } #endregion } #endregion #endregion #region UretimEmri Kaydının Durum'u değiştiriliyor. using (SqlCommand cmd = new SqlCommand(@"Update UretimEmri Set Durum=1 Where UretimEmriID=@UretimEmriID", SqlConnections.GetBaglanti())) { cmd.Parameters.Add("@UretimEmriID", SqlDbType.Int).Value = UretimEmriID; cmd.ExecuteNonQuery(); } #endregion dt.Clear(); daUretim.Update(dt); daUretim.Fill(dt); gvUretimEmri.FocusedRowHandle = SeciliSatir; }
private void ConnectionsCombo_SelectionChanged(object sender, SelectionChangedEventArgs e) { this._tables.Clear(); GenerateCodeButton.IsEnabled = false; if (this.ConnectionsCombo.SelectedItem != null) { var conn = (GeneratorConfig.Connection) this.ConnectionsCombo.SelectedItem; try { using (var connection = SqlConnections.New(conn.ConnectionString, conn.ProviderName)) { connection.Open(); var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType); foreach (var t in schemaProvider.GetTableNames(connection)) { var table = conn != null?conn.Tables.FirstOrDefault(x => x.Tablename == t.Tablename) : null; var identifier = (table == null || table.Identifier.IsEmptyOrNull()) ? RowGenerator.ClassNameFromTableName(t.Table) : table.Identifier; var permission = table == null ? "Administration:General" : table.PermissionKey; var connectionKey = (table != null && !table.ConnectionKey.IsEmptyOrNull()) ? table.ConnectionKey : conn.Key; var module = (table != null && table.Module != null) ? table.Module : (Inflector.Inflector.Pascalize(connectionKey) ?? "").Replace(" ", ""); var tableItem = new TableItem { IsChecked = false, ConnectionKey = conn.Key, Module = module, Identifier = identifier, PermissionKey = permission, FullName = t.Tablename }; _tables.Add(tableItem); tableItem.PropertyChanged += (s, e2) => { var t2 = conn.Tables.FirstOrDefault(x => x.Tablename == tableItem.FullName); if (t2 == null) { t2 = new GeneratorConfig.Table(); t2.Tablename = tableItem.FullName; conn.Tables.Add(t2); } t2.Identifier = tableItem.Identifier; t2.Module = tableItem.Module; t2.ConnectionKey = tableItem.ConnectionKey; t2.PermissionKey = tableItem.PermissionKey; this.config.Save(); GenerateCodeButton.IsEnabled = _tables.Any(x => x.IsChecked); }; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void checkButton_fotoGoster_CheckedChanged(object sender, EventArgs e) { try { if (gvStokListesi.RowCount == 0) { return; } if (checkButton_fotoGoster.Checked == true) { pictureEdit1.Visible = true; layoutControlItem43.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; pictureEdit1.EditValue = StokArama.StokIDverVarsayilanFotoAl(SqlConnections.GetBaglanti(), trGenel, Convert.ToInt32(gvStokListesi.GetFocusedRowCellValue("StokID"))); } else { pictureEdit1.Visible = false; layoutControlItem43.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; } } catch (Exception) { } }
string MiktarliBarkod; // buraya açıklama lazım void FiltreKriterleriniBindleHamisina() { //tabbedControlGroup1.TabPages. //layoutControlGroup5. //layoutControlItem33.Control.DataBindings for (int i = 0; i < layoutControlGroup6.Items.Count; i++) { this.layoutControlGroup6.Items[i].DataBindings.Clear(); } for (int i = 0; i < layoutControlGroup5.Items.Count; i++) { this.layoutControlGroup5.Items[i].DataBindings.Clear(); } for (int i = 0; i < layoutControlGroup7.Items.Count; i++) { this.layoutControlGroup7.Items[i].DataBindings.Clear(); } for (int i = 0; i < layoutControlGroup8.Items.Count; i++) { this.layoutControlGroup8.Items[i].DataBindings.Clear(); } txtStokKodu.DataBindings.Add("EditValue", StokArama, "StokKodu", false, DataSourceUpdateMode.OnPropertyChanged); lkpGrup.Properties.DataSource = Grubu.StokGrupDoldur(SqlConnections.GetBaglanti(), trGenel); lkpGrup.Properties.ValueMember = "StokGrupID"; lkpGrup.Properties.DisplayMember = "StokGrupAdi"; txtStokAdi.DataBindings.Add("EditValue", StokArama, "StokAdi", false, DataSourceUpdateMode.OnPropertyChanged); txtBarkodu.DataBindings.Add("EditValue", StokArama, "Barkod", false, DataSourceUpdateMode.OnPropertyChanged); checkEdit_SadeceSeciliFiyatiOlanlar.DataBindings.Add("EditValue", StokArama, "SadeceFiyatiOlanlar", false, DataSourceUpdateMode.OnPropertyChanged); SeciliFiyatTanimlariniAl(); //checkedComboBoxFiyatTanimlari.DataBindings.Add("EditValue", StokArama, "StokFiyatTanimIDleri", true, DataSourceUpdateMode.OnPropertyChanged); //checkedComboBoxFiyatTanimlari.DataBindings.Add("Text", StokArama, "StokFiyatTanimAdlari", true, DataSourceUpdateMode.OnPropertyChanged); //checkedComboBoxFiyatTanimlari. txtAciklama.DataBindings.Add("EditValue", StokArama, "Aciklama", false, DataSourceUpdateMode.OnPropertyChanged); lkpGrup.DataBindings.Add("EditValue", StokArama, "StokGrupID", false, DataSourceUpdateMode.OnPropertyChanged); cmbAktifmi.DataBindings.Add("EditValue", StokArama, "Aktif", false, DataSourceUpdateMode.OnPropertyChanged); cmbUrunTanitim.DataBindings.Add("SelectedIndex", StokArama, "UrunTanitimdaGoster", false, DataSourceUpdateMode.OnPropertyChanged); lkpGrup.EditValueChanged += new EventHandler(lkpGrup_EditValueChanged); cmbEMagazaErisimi.DataBindings.Add("SelectedIndex", StokArama, "EMagazaErisimi", false, DataSourceUpdateMode.OnPropertyChanged); txtGaranti.DataBindings.Add("EditValue", StokArama, "Garanti", false, DataSourceUpdateMode.OnPropertyChanged); txtDesi.DataBindings.Add("EditValue", StokArama, "Desi", false, DataSourceUpdateMode.OnPropertyChanged); txtKisaAciklama.DataBindings.Add("EditValue", StokArama, "KisaAciklama", false, DataSourceUpdateMode.OnPropertyChanged); txtDetayliAciklama.DataBindings.Add("EditValue", StokArama, "DetayliUrunBilgisi", false, DataSourceUpdateMode.OnPropertyChanged); lkpHemenAlKategori.DataBindings.Add("EditValue", StokArama, "HemenAlKategoriID", false, DataSourceUpdateMode.OnPropertyChanged); cmbHemenAlKategoriGuncellenmesin.DataBindings.Add("SelectedIndex", StokArama, "HemenAlKategoriGuncellenmesin", false, DataSourceUpdateMode.OnPropertyChanged); lkpHemanAlDurum.DataBindings.Add("EditValue", StokArama, "HemenAlDrum", false, DataSourceUpdateMode.OnPropertyChanged); txtHemenAlSira.DataBindings.Add("EditValue", StokArama, "HemenAlSira", false, DataSourceUpdateMode.OnPropertyChanged); txtHemenAlID.DataBindings.Add("EditValue", StokArama, "HemenAlID", false, DataSourceUpdateMode.OnPropertyChanged); lkpAraGrup.DataBindings.Add("EditValue", StokArama, "StokAraGrupID", false, DataSourceUpdateMode.OnPropertyChanged); lkpAltGrup.DataBindings.Add("EditValue", StokArama, "StokAltGrupID", false, DataSourceUpdateMode.OnPropertyChanged); cmbMiktarGetir.DataBindings.Add("SelectedIndex", StokArama, "MiktariOlanlar", false, DataSourceUpdateMode.OnPropertyChanged); checkBox_MinMikAltındaolanlar.DataBindings.Add("Checked", StokArama, "MinMiktarinAltindaOlanlar", false, DataSourceUpdateMode.OnPropertyChanged); checkEdit_OlmasiGerekenMiktardanAzOlanlar.DataBindings.Add("Checked", StokArama, "OlmasiGerekenMiktardanAzOlanlar", false, DataSourceUpdateMode.OnPropertyChanged); lkpStokSayimGrubu.DataBindings.Add("EditValue", StokArama, "StokSayimGrubuID", false, DataSourceUpdateMode.OnPropertyChanged); txtOzelKodu1.DataBindings.Add("EditValue", StokArama, "OzelKod1", false, DataSourceUpdateMode.OnPropertyChanged); txtOzelKodu2.DataBindings.Add("EditValue", StokArama, "OzelKod2", false, DataSourceUpdateMode.OnPropertyChanged); txtOzelKodu3.DataBindings.Add("EditValue", StokArama, "OzelKod3", false, DataSourceUpdateMode.OnPropertyChanged); cmbStokTipi.DataBindings.Add("SelectedIndex", StokArama, "StokTipi", false, DataSourceUpdateMode.OnPropertyChanged); ceGruptakilerinHepsi.DataBindings.Add("Checked", StokArama, "StokGrupHepsiniGetir", false, DataSourceUpdateMode.OnPropertyChanged); txtStokAdi.Focus(); }
private void btnSec_Click(object sender, EventArgs e) { if (gvStokListesi.RowCount == 0) { return; } decimal Miktarr = 1; if (ceBarkoddanMiktarAl.Checked == true) { try { trGenel = SqlConnections.GetBaglanti().BeginTransaction(); Miktarr = StokArama.BarkdundanMiktarVer(SqlConnections.GetBaglanti(), trGenel, MiktarliBarkod); trGenel.Commit(); } catch (Exception hata) { trGenel.Rollback(); frmHataBildir frmHataBildir = new frmHataBildir(hata.Message, hata.StackTrace); frmHataBildir.ShowDialog(); } } if (ceMiktariElleGir.Checked == true && !gvStokListesi.IsMultiSelect) // eğer çoklu seçim ise aşağıda çağıracak bu satırları { frmMiktarGirr = new clsTablolar.frmMiktarGir(Miktarr, clsTablolar.frmMiktarGir.SayiCinsi.Ondalikli); frmMiktarGirr.labelControl1.Text = gvStokListesi.GetFocusedRowCellValue("StokAdi").ToString() + "\n Eklenecek Miktarı Girin"; frmMiktarGirr.ShowDialog(); Miktarr = Convert.ToDecimal(frmMiktarGirr.textEdit1.EditValue); } if (StokArama.SayimID != -1) { Miktarr = Convert.ToDecimal(gvStokListesi.GetFocusedRowCellValue("SayimMiktari")); } // bunu böyle yaptık çünkü birden fazla satır seçilme işlemindede çalışsın ve s // ve bşrden fazla satır seçildiğinde ilk önce seçimin ilk satırını versin if (ceCokluSecim.CheckState == CheckState.Checked && gvStokListesi.IsMultiSelect) { for (int i = 0; i < gvStokListesi.GetSelectedRows().Length; i++) { if (ceMiktariElleGir.Checked == true) { frmMiktarGirr = new clsTablolar.frmMiktarGir(Miktarr); frmMiktarGirr.labelControl1.Text = gvStokListesi.GetFocusedRowCellValue("StokAdi").ToString() + "\n Eklenecek Miktarı Girin"; frmMiktarGirr.ShowDialog(); Miktarr = Convert.ToDecimal(frmMiktarGirr.textEdit1.EditValue); } //if ((int)btnEdit_SayimAciklama.EditValue != -1) if (StokArama.SayimID != -1) { Miktarr = Convert.ToDecimal(gvStokListesi.GetRowCellValue(gvStokListesi.GetSelectedRows()[i], "SayimMiktari")); } Stok_Sec((int)(gvStokListesi.GetRowCellValue(gvStokListesi.GetSelectedRows()[i], "StokID")), Miktarr); } } else { Stok_Sec((int)(gvStokListesi.GetFocusedRowCellValue("StokID")), Miktarr); } if (secilenKontrol != null) { secilenKontrol.SelectAll(); } if (ceArdArdaEkle.Checked == false) { Close(); } }
private void btnFiltrele_Click(object sender, EventArgs e) { try { StokArama.FotoOzellikleri = (clsTablolar.Stok.csStokArama.enumFotoOzellikleri)Convert.ToInt32(lookUpEdit1.EditValue); // buraları biraz karışık açıklama lazım // stok arama yalada oldukça alakalı StokArama.StokFiyatTanimAdlari = ""; StokArama.StokFiyatTanimIDleri = ""; for (int i = 0, b = 0; i < checkedListBox_FiyatTanimlari.ItemCount; i++) { if (checkedListBox_FiyatTanimlari.GetItemChecked(i) == true) { if (b > 0) // virgülü koyma ile alaklı bişi sanırım { StokArama.StokFiyatTanimAdlari += " ," + checkedListBox_FiyatTanimlari.GetDisplayItemValue(i); StokArama.StokFiyatTanimIDleri += " ," + checkedListBox_FiyatTanimlari.GetItemValue(i); } else { StokArama.StokFiyatTanimAdlari += checkedListBox_FiyatTanimlari.GetDisplayItemValue(i); StokArama.StokFiyatTanimIDleri += checkedListBox_FiyatTanimlari.GetItemValue(i); } b++; } } switch (cmbN11.SelectedIndex) { case 0: StokArama.N11Entegrasyonu = clsTablolar.Stok.csStokArama.n11entegrasyon.Hepsi; break; case 1: StokArama.N11Entegrasyonu = clsTablolar.Stok.csStokArama.n11entegrasyon.Olan; break; case 2: StokArama.N11Entegrasyonu = clsTablolar.Stok.csStokArama.n11entegrasyon.Olmayan; break; default: break; } //= StokArama.dt_StokListesi; if (cedit_FotoKatolog.Checked) { gcStokListesi.MainView = layoutView1; //layoutView1.OptionsView.ViewMode = DevExpress.XtraGrid.Views.Layout.LayoutViewMode.MultiColumn; StokArama.TumFotograflariYukle = true; //layoutView1.Columns["StokAdi"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; lvcolStokAdi.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; //lvcolStokID.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; layoutView1.OptionsMultiRecordMode.MultiColumnScrollBarOrientation = DevExpress.XtraGrid.Views.Layout.ScrollBarOrientation.Vertical; } else { gcStokListesi.MainView = gvStokListesi; StokArama.TumFotograflariYukle = false; } if (ucStokGruplari1.AhandaBuradakiler != null && ucStokGruplari1.AhandaBuradakiler.Count != 0) { StokArama.SeciliGruplar = ucStokGruplari1.AhandaBuradakiler.ToArray(); //StokArama.SeciliGruplar = } else { StokArama.SeciliGruplar = null; } gvStokListesi.Columns.Clear(); //layoutView1.Columns.Clear(); trGenel = SqlConnections.GetBaglanti().BeginTransaction(); gcStokListesi.DataSource = StokArama.StokListeGetir(SqlConnections.GetBaglanti(), trGenel); trGenel.Commit(); if (cedit_FotoKatolog.Checked == false) { GridArayuzIslemleri(enGridArayuzIslemleri.Get); } MiktarliBarkod = txtBarkodu.Text; // bunu neden buna eşitlemiştik KacSatirVar(); } catch (Exception hata) { try { trGenel.Rollback(); } catch (Exception) { } frmHataBildir frmHataBildir = new frmHataBildir(hata.Message, hata.StackTrace); frmHataBildir.ShowDialog(); } }
void SeciliFiyatTanimlariniAl() { checkedListBox_FiyatTanimlari.DataSource = FiyatTanimlari.TumFiyatTanimlariniGetir(SqlConnections.GetBaglanti(), trGenel, false); checkedListBox_FiyatTanimlari.DisplayMember = "FiyatTanimAdi"; checkedListBox_FiyatTanimlari.ValueMember = "FiyatTanimID"; //checkedListBox_FiyatTanimlari.SetItemChecked(1, true); clsTablolar.Ayarlar.csAyarlar.StokListeFiyatTanimlari.Split(','); for (int i = 0; i < checkedListBox_FiyatTanimlari.ItemCount; i++) { if (clsTablolar.Ayarlar.csAyarlar.StokListeFiyatTanimlari.Split(',').Contains(checkedListBox_FiyatTanimlari.GetItemValue(i).ToString())) { checkedListBox_FiyatTanimlari.SetItemChecked(i, true); } } }
private void StokAltGrupGuncelle() { lkpAltGrup.Properties.DataSource = AltGrubu.StokAltGrupDoldur(SqlConnections.GetBaglanti(), trGenel, StokArama.StokAraGrupID); lkpAltGrup.Properties.ValueMember = "StokAltGrupID"; lkpAltGrup.Properties.DisplayMember = "StokAltGrupAdi"; }
void lkpGrup_EditValueChanged(object sender, EventArgs e) { lkpAraGrup.Properties.DataSource = AraGrubu.StokAraGrupDoldur(SqlConnections.GetBaglanti(), trGenel, csGenelKodlar.IDBossaEksiBirVer(lkpGrup.EditValue)); lkpAraGrup.Properties.ValueMember = "StokAraGrupID"; lkpAraGrup.Properties.DisplayMember = "StokAraGrupAdi"; }
private void cbtnKaydedildi_Click(object sender, EventArgs e) { try { if (XtraMessageBox.Show("Üretim Emri Durumu 'Kaydedildi' Olarak Değiştirilecek.\n{Üretim Fişleri silinecek.}\nOnaylıyor musunuz?", "ARES", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.No) { return; } int SeciliSatir = gvUretimEmri.FocusedRowHandle; #region StokFis ve StokFisDetay Tablolarından 'StokFisNo' su yakalanan satır siliniyor. string StokFisID = "-1"; using (SqlCommand cmd = new SqlCommand("Select StokFisID From StokFis Where StokFisNo=@StokFisNo", SqlConnections.GetBaglanti())) { cmd.Parameters.Add("@StokFisNo", SqlDbType.NVarChar).Value = gvUretimEmri.GetFocusedRowCellValue("PartiNo").ToString(); using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult)) if (dr.Read()) { StokFisID = dr["StokFisID"].ToString(); } } trGenel = SqlConnections.GetBaglanti().BeginTransaction(); using (SqlCommand cmdDelete = new SqlCommand("Delete From StokFis Where StokFisID=@StokFisID", SqlConnections.GetBaglanti())) { cmdDelete.Transaction = trGenel; cmdDelete.Parameters.Add("@StokFisID", SqlDbType.Int).Value = StokFisID; cmdDelete.ExecuteNonQuery(); } System.Collections.Generic.List <Int32> hareketler = new System.Collections.Generic.List <int>(); using (SqlCommand cmdHareketler = new SqlCommand("Select StokFisDetayID From StokFisDetay Where StokFisID=@StokFisID", SqlConnections.GetBaglanti())) { cmdHareketler.Transaction = trGenel; cmdHareketler.Parameters.Add("@StokFisID", SqlDbType.Int).Value = StokFisID; using (SqlDataReader dr = cmdHareketler.ExecuteReader()) while (dr.Read()) { hareketler.Add(Convert.ToInt32(dr["StokFisDetayID"].ToString())); } } foreach (Int32 ID in hareketler) { using (SqlCommand cmdDelete = new SqlCommand("Delete From StokFisDetay Where StokFisDetayID=@StokFisDetayID", SqlConnections.GetBaglanti())) { cmdDelete.Transaction = trGenel; cmdDelete.Parameters.Add("@StokFisDetayID", SqlDbType.Int).Value = ID; cmdDelete.ExecuteNonQuery(); } } trGenel.Commit(); #endregion #region UretimEmri Kaydının Durum'u değiştiriliyor. using (SqlCommand cmd = new SqlCommand(@"Update UretimEmri Set Durum=0 Where UretimEmriID=@UretimEmriID", SqlConnections.GetBaglanti())) { cmd.Parameters.Add("@UretimEmriID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("UretimEmriID").ToString(); cmd.ExecuteNonQuery(); } #endregion dt.Clear(); daUretim.Update(dt); daUretim.Fill(dt); gvUretimEmri.FocusedRowHandle = SeciliSatir; } catch (Exception hata) { frmHataBildir frmHataBildir = new frmHataBildir(hata.Message, hata.StackTrace); frmHataBildir.ShowDialog(); } }
private void GenerateCodes_Click(object sender, RoutedEventArgs e) { var conn = (GeneratorConfig.Connection) this.ConnectionsCombo.SelectedItem; if (conn == null) { MessageBox.Show("A connection must be selected!"); return; } var tables = this._tables.Where(x => x.IsChecked == true); if (this.ConnectionsCombo.SelectedItem == null) { MessageBox.Show("Please select at least one table!"); return; } ; var noIdentifier = tables.FirstOrDefault(x => x.Identifier.IsTrimmedEmpty()); if (noIdentifier != null) { MessageBox.Show("Identifier for table " + noIdentifier.FullName + " is empty!"); return; } ; foreach (var table in tables) { try { EntityModel rowModel; using (var connection = SqlConnections.New(conn.ConnectionString, conn.ProviderName)) { connection.Open(); var tableName = table.FullName; string schema = null; if (tableName.IndexOf('.') > 0) { schema = tableName.Substring(0, tableName.IndexOf('.')); tableName = tableName.Substring(tableName.IndexOf('.') + 1); } rowModel = RowGenerator.GenerateModel(connection, schema, tableName, table.Module, table.ConnectionKey, table.Identifier, table.PermissionKey, config); var kdiff3Paths = new[] { config.KDiff3Path, Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ProgramFilesX86), "KDiff3\\kdiff3.exe"), Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ProgramFiles), "KDiff3\\kdiff3.exe"), }; CodeFileHelper.Kdiff3Path = kdiff3Paths.FirstOrDefault(File.Exists); if (config.TFSIntegration) { CodeFileHelper.SetupTFSIntegration(config.TFPath); } CodeFileHelper.SetupTSCPath(config.TSCPath); var siteWebProj = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, config.WebProjectFile)); new EntityCodeGenerator(rowModel, config, siteWebProj).Run(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } if (config.GenerateService || config.GenerateUI || config.GenerateCustom) { var siteWebProj = Path.GetFullPath(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, config.WebProjectFile)); var siteWebPath = Path.GetDirectoryName(siteWebProj); CodeFileHelper.ExecuteTSC(Path.Combine(siteWebPath, @"Scripts\"), ""); } MessageBox.Show("Code files for the selected table is generated. Please REBUILD SOLUTION before running application, otherwise you may have script errors!"); GenerateCodeButton.IsEnabled = false; }
private decimal CiktiMiktariniGetir() { decimal CiktiMiktari = 0; using (SqlCommand cmd = new SqlCommand(@"SELECT dbo.UretimEmri.UretimMiktari * dbo.ReceteDetail.Miktar AS CiktiMiktari FROM dbo.UretimEmri INNER JOIN dbo.ReceteMaster ON dbo.UretimEmri.ReceteMasterID = dbo.ReceteMaster.ReceteMasterID INNER JOIN dbo.ReceteDetail ON dbo.ReceteMaster.ReceteMasterID = dbo.ReceteDetail.ReceteMasterID WHERE (dbo.ReceteDetail.SatirTur = 1) AND (dbo.UretimEmri.UretimEmriID = @UretimEmriID)", SqlConnections.GetBaglanti())) { cmd.Parameters.Add("@UretimEmriID", SqlDbType.Int).Value = gvUretimEmri.GetFocusedRowCellValue("UretimEmriID").ToString(); using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult)) { if (dr.Read()) { CiktiMiktari = (decimal)dr["CiktiMiktari"]; } } } return(CiktiMiktari); }
public static AuditLogListResponse List(string schema, AuditLogListRequest request) { #if COREFX var fld = Dependency.Resolve <IAuditLogRow>(); #else var fld = Dependency.Resolve <IAuditLogRow>(schema); #endif Authorization.ValidateLoggedIn(); var response = new AuditLogListResponse(); using (var connection = SqlConnections.NewByKey("Default")) { response.Entities = new List <Row>(); var row = ((Row)fld).CreateNew(); if (request.Sort == null || request.Sort.Length == 0) { request.Sort = new SortBy[] { new SortBy(fld.DateField.Name, true) } } ; var query = new SqlQuery().From(row) .Select( (Field)fld.IdField, fld.EntityTypeIdField, fld.EntityIdField, fld.ParentTypeIdField, fld.OldParentIdField, fld.NewParentIdField, fld.DateField, (Field)fld.UserIdField, fld.AuditTypeIdField, fld.OldAuditDataField, fld.NewAuditDataField) .OrderBy( (Field)fld.IdField) .ApplySkipTakeAndCount(request.Skip, request.Take, request.ExcludeTotalCount) .ApplySort(request.Sort); if (request.EntityTypeId != null && request.EntityId != null) { var pEntityId = query.AddParam(request.EntityId); var pEntityTypeId = query.AddParam(request.EntityTypeId); query.Where(~( ~( new Criteria(0, fld.EntityTypeIdField) == pEntityTypeId & new Criteria(0, fld.EntityIdField) == pEntityId) | ~( new Criteria(0, fld.ParentTypeIdField) == pEntityTypeId & ~( new Criteria(0, fld.OldParentIdField) == pEntityId | new Criteria(0, fld.NewParentIdField) == pEntityId)))); } else { if (request.EntityTypeId != null) { query.WhereEqual(fld.EntityTypeIdField, request.EntityTypeId);//Convert.ToInt32(request.EntityTypeId.Value)); } if (request.EntityId != null) { query.WhereEqual(fld.EntityIdField, request.EntityId.Value); } } response.TotalCount = query.ForEach(connection, delegate() { response.Entities.Add(row.Clone()); }); response.SetSkipTakeTotal(query); response.IdNameLookups = new Dictionary <EntityType, Dictionary <long, string> >(); response.FieldTitles = new Dictionary <EntityType, Dictionary <string, string> >(); response.ForeignEntityTypes = new Dictionary <EntityType, Dictionary <string, string> >(); response.EntityTitles = new Dictionary <EntityType, string>(); var lookups = response.IdNameLookups; var titles = response.FieldTitles; var foreigns = response.ForeignEntityTypes; var entities = response.EntityTitles; Action <EntityType, Int64> addLookup = (entityType, id) => { Dictionary <long, string> lookup; if (!lookups.TryGetValue(entityType, out lookup)) { lookup = new Dictionary <long, string>(); lookups[entityType] = lookup; } if (!lookup.ContainsKey(id)) { lookup[id] = null; } }; Action <EntityType, string> addTitle = (entityType, field) => { Dictionary <string, string> lookup; if (!titles.TryGetValue(entityType, out lookup)) { lookup = new Dictionary <string, string>(); titles[entityType] = lookup; } if (!lookup.ContainsKey(field)) { lookup[field] = null; } }; Action <EntityType> addEntity = (entityType) => { if (!entities.ContainsKey(entityType)) { //Row r; String s = null; // TODO: FIX! //if (schema.TypeToTable.TryGetValue(entityType, out r)) // s = LocalText.TryGet(1055, "Db." + r.Table + ".EntitySingular", false); s = s ?? Enum.GetName(typeof(EntityType), entityType); entities[entityType] = s; } }; Action <EntityType, string, EntityType> addForeign = (entityType, field, foreignType) => { Dictionary <string, string> foreign; if (!foreigns.TryGetValue(entityType, out foreign)) { foreign = new Dictionary <string, string>(); foreigns[entityType] = foreign; } if (!foreign.ContainsKey(field)) { foreign[field] = Enum.GetName(typeof(EntityType), foreignType); } }; foreach (var entity in response.Entities) { addEntity(fld.EntityTypeIdField[entity]); addLookup(fld.EntityTypeIdField[entity], fld.EntityIdField[entity].Value); if (fld.ParentTypeIdField[entity] != null) { addEntity(fld.ParentTypeIdField[entity]); } //if (entity.UserId != null) // addLookup(UserRow.TableName, entity.UserId.Value); Row theRow; if (((AuditType?)fld.AuditTypeIdField[entity] == AuditType.Insert || (AuditType?)fld.AuditTypeIdField[entity] == AuditType.Update) && (fld.OldAuditDataField[entity] != null || fld.NewAuditDataField[entity] != null)) { theRow = RowRegistry.ByConnectionKey(RowRegistry.DefaultConnectionKey)[fld.EntityTypeIdField[entity]].FirstOrDefault(); if (theRow == null) { continue; } UpdateAuditDataDictionary ud = new UpdateAuditDataDictionary(); if (fld.OldAuditDataField[entity] != null) { ud.Old = JsonConvert.DeserializeObject <Dictionary <string, object> >(fld.OldAuditDataField[entity].TrimToNull() ?? "{}", JsonSettings.Tolerant); } if (fld.NewAuditDataField[entity] != null) { ud.New = JsonConvert.DeserializeObject <Dictionary <string, object> >(fld.OldAuditDataField[entity].TrimToNull() ?? "{}", JsonSettings.Tolerant); } for (var i = 0; i < 2; i++) { var d = (i == 0) ? ud.Old : ud.New; if (d != null) { foreach (var p in d) { addTitle(fld.EntityTypeIdField[entity], p.Key); if (p.Value != null && p.Value is Int16 || p.Value is Int32 || p.Value is Int64) { var f = theRow.FindField(p.Key); if (!ReferenceEquals(null, f) && f.ForeignTable != null) { //EntityType foreignType; //if (schema.TableToType.TryGetValue(f.ForeignTable, out foreignType)) { addForeign(fld.EntityTypeIdField[entity], p.Key, f.ForeignTable); addLookup(f.ForeignTable, Convert.ToInt64(p.Value)); } } } } } } } } foreach (var pair in response.IdNameLookups) { Row entity = RowRegistry.ByConnectionKey(RowRegistry.DefaultConnectionKey)[pair.Key].FirstOrDefault(); if (entity != null) { var idRow = entity as IIdRow; var nameField = entity.GetNameField() as StringField; if (idRow != null && !ReferenceEquals(null, nameField)) { var lookup = pair.Value; var idName = GetIdNameDictionary(connection, (IIdRow)entity, nameField, lookup.Keys); foreach (var p in idName) { lookup[p.Key] = p.Value; } } } } foreach (var pair in response.FieldTitles) { Row entity = RowRegistry.ByConnectionKey(RowRegistry.DefaultConnectionKey)[pair.Key].FirstOrDefault(); if (entity != null) { var lookup = pair.Value; var keys = new string[lookup.Keys.Count]; lookup.Keys.CopyTo(keys, 0); foreach (var key in keys) { Field f; if (key.EndsWith("Id")) { var s = key.Substring(0, key.Length - 2); f = entity.FindField(s); if (!ReferenceEquals(null, f)) { lookup[key] = f.Title; continue; } } f = entity.FindField(key); if (!ReferenceEquals(null, f)) { lookup[key] = f.Title; } } } } return(response); } }
/// <summary> /// Automatically creates a database for the template if it doesn't already exists. /// You might delete this method to disable auto create functionality. /// </summary> private static void EnsureDatabase(string databaseKey) { var cs = SqlConnections.GetConnectionString(databaseKey); var serverType = cs.Dialect.ServerType; bool isSql = serverType.StartsWith("SqlServer", StringComparison.OrdinalIgnoreCase); bool isPostgres = serverType.StartsWith("Postgres", StringComparison.OrdinalIgnoreCase); bool isMySql = serverType.StartsWith("MySql", StringComparison.OrdinalIgnoreCase); bool isSqlite = serverType.StartsWith("Sqlite", StringComparison.OrdinalIgnoreCase); bool isFirebird = serverType.StartsWith("Firebird", StringComparison.OrdinalIgnoreCase); if (isSqlite) { var contentRoot = Serenity.Dependency.Resolve <IWebHostEnvironment>().ContentRootPath; Directory.CreateDirectory(Path.Combine(contentRoot, "App_Data")); return; } var cb = cs.ProviderFactory.CreateConnectionStringBuilder(); cb.ConnectionString = cs.ConnectionString; if (isFirebird) { if (cb.ConnectionString.IndexOf(@"localhost") < 0 && cb.ConnectionString.IndexOf(@"127.0.0.1") < 0) { return; } var database = cb["Database"] as string; if (string.IsNullOrEmpty(database)) { return; } database = Path.GetFullPath(database); if (File.Exists(database)) { return; } Directory.CreateDirectory(Path.GetDirectoryName(database)); using (var fbConnection = SqlConnections.New(cb.ConnectionString, cs.ProviderName)) { ((WrappedConnection)fbConnection).ActualConnection.GetType() .GetMethod("CreateDatabase", new Type[] { typeof(string), typeof(bool) }) .Invoke(null, new object[] { fbConnection.ConnectionString, false }); } return; } if (!isSql && !isPostgres && !isMySql) { return; } string catalogKey = "?"; foreach (var ck in new[] { "Initial Catalog", "Database", "AttachDBFilename" }) { if (cb.ContainsKey(ck)) { catalogKey = ck; break; } } var catalog = cb[catalogKey] as string; cb[catalogKey] = null; using (var serverConnection = SqlConnections.New(cb.ConnectionString, cs.ProviderName)) { try { serverConnection.Open(); } catch (SqlException ex) { if (ex.Number != -2146232060) { throw; } const string oldVer = @"\v11.0"; if (cb.ConnectionString.IndexOf(oldVer) >= 0) { throw new Exception( "You don't seem to have SQL Express LocalDB 2012 installed.\r\n\r\n" + "If you have Visual Studio 2015 (with SQL LocalDB 2014) " + "try changing '" + databaseKey + "' connection string in WEB.CONFIG to:\r\n\r\n" + cs.ConnectionString.Replace(oldVer, @"\MSSqlLocalDB") + "\r\n\r\nor:\r\n\r\n" + cs.ConnectionString.Replace(oldVer, @"\v12.0") + "';\r\n\r\n" + "You can also try another SQL server type like .\\SQLExpress."); } throw; } string databasesQuery = "SELECT * FROM sys.databases WHERE NAME = @name"; string createDatabaseQuery = @"CREATE DATABASE [{0}]"; if (isPostgres) { databasesQuery = "select * from postgres.pg_catalog.pg_database where datname = @name"; createDatabaseQuery = "CREATE DATABASE \"{0}\""; } else if (isMySql) { databasesQuery = "SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = @name"; createDatabaseQuery = "CREATE DATABASE `{0}`"; } if (serverConnection.Query(databasesQuery, new { name = catalog }).Any()) { return; } var isLocalServer = isSql && ( serverConnection.ConnectionString.IndexOf(@"(localdb)\", StringComparison.OrdinalIgnoreCase) >= 0 || serverConnection.ConnectionString.IndexOf(@".\") >= 0 || serverConnection.ConnectionString.IndexOf(@"localhost") >= 0 || serverConnection.ConnectionString.IndexOf(@"127.0.0.1") >= 0); string command; if (isLocalServer) { string baseDirectory; var hostingEnvironment = Serenity.Dependency.TryResolve <IWebHostEnvironment>(); if (hostingEnvironment != null) { baseDirectory = hostingEnvironment.ContentRootPath; } else { baseDirectory = AppDomain.CurrentDomain.BaseDirectory; } var filename = Path.Combine(Path.Combine(baseDirectory, "App_Data/".Replace('/', Path.DirectorySeparatorChar)), catalog); Directory.CreateDirectory(Path.GetDirectoryName(filename)); command = String.Format(@"CREATE DATABASE [{0}] ON PRIMARY (Name = N'{0}', FILENAME = '{1}.mdf') LOG ON (NAME = N'{0}_log', FILENAME = '{1}.ldf')", catalog, filename); if (File.Exists(filename + ".mdf")) { command += " FOR ATTACH"; } } else { command = String.Format(createDatabaseQuery, catalog); } serverConnection.Execute(command); SqlConnection.ClearAllPools(); } }
public void SqlLogger_WorksProperly() { using (new MunqContext()) { var fld = SystemLogRow.Fields; var registrar = Dependency.Resolve <IDependencyRegistrar>(); var fakeConfig = A.Fake <IConfigurationRepository>(); A.CallTo(() => fakeConfig.Load(null)) .WithAnyArguments() .ReturnsLazily((Type t) => JSON.ParseTolerant(JSON.Stringify(new { Level = "Debug", ConnectionKey = "Serenity", InsertCommand = new SqlInsert(fld.TableName) .SetTo(fld.EventDate, "@date") .SetTo(fld.LogLevel, "@level") .SetTo(fld.LogMessage, "@message") .SetTo(fld.Exception, "@exception") .SetTo(fld.SourceType, "@source") .ToString() }), t)); registrar.RegisterInstance <IConfigurationRepository>("Application", fakeConfig); using (var context = NewDbTestContext()) { context.ExpireOverrides(); var logger = new SqlLogger(); registrar.RegisterInstance <ILogger>(logger); Log.MinimumLevel = LoggingLevel.Debug; Log.Debug("Hello1", new Exception("SomeException1"), this.GetType()); Log.Info("Hello2", new Exception("SomeException2"), this.GetType()); Log.Warn("Hello3", new Exception("SomeException3"), this.GetType()); using (var connection = SqlConnections.NewByKey("Serenity")) { logger.Flush(); var items = connection.List <SystemLogRow>(q => q.SelectTableFields().OrderBy(fld.ID, desc: true).Take(3)); Assert.Equal(3, items.Count); var item = items[2]; Assert.Equal("Hello1", item.LogMessage); Assert.Contains("SomeException1", item.Exception); Assert.Equal("Debug", item.LogLevel); Assert.Equal(this.GetType().FullName, item.SourceType); Assert.True(DateTime.Now.Subtract(item.EventDate.Value).TotalSeconds < 60); item = items[1]; Assert.Equal("Hello2", item.LogMessage); Assert.Contains("SomeException2", item.Exception); Assert.Equal("Info", item.LogLevel); Assert.Equal(this.GetType().FullName, item.SourceType); Assert.True(DateTime.Now.Subtract(item.EventDate.Value).TotalSeconds < 60); item = items[0]; Assert.Equal("Hello3", item.LogMessage); Assert.Contains("SomeException3", item.Exception); Assert.Equal("Warn", item.LogLevel); Assert.Equal(this.GetType().FullName, item.SourceType); Assert.True(DateTime.Now.Subtract(item.EventDate.Value).TotalSeconds < 60); } } } }
public List <SimpleReportViewModel> Bar() { //list of department var lstModel = new List <SimpleReportViewModel>(); using (var ChartConnection = SqlConnections.NewByKey("Default")) { //var xx = ChartConnection.List<SchedulingRow>().FindAll(s => s.Month == DateTime.Now.Month.ToString()); string query = @"select fullDate, Value from MeterDetail inner join Scheduling on MeterDetail.SchedulingID = Scheduling.SchedulingID where FullDate between @DateStart and @DateEnd --and MeterID = @MeterId and ParameterID in @ParameterId"; string dateStart = "2019-03-14 11:43:21"; string dateEnd = "2019-08-09 15:43:21"; int meterId = 1; int[] parameterId = { 1, 2, 3, 4, 5 }; var chartConnection = ChartConnection.Query(query, param: new { MeterId = meterId, ParameterId = parameterId, DateStart = dateStart, DateEnd = dateEnd }); string queryTwo = @"select * from Meter inner join Consumer on Meter.ConsumerID = Consumer.ConsumerID"; var meters = ChartConnection.Query(queryTwo); string queryThree = @"select * from Parameter inner join MeterDetail on MeterDetail.ParameterID = Parameter.ParameterID where MeterID = @MeterId"; var parameters = ChartConnection.Query(queryThree, param: new { MeterId = meterId }); string queryFour = @"select ParameterID,FullDate, Value from MeterDetail inner join Scheduling on MeterDetail.SchedulingID = Scheduling.SchedulingID where FullDate between @DateStart and @DateEnd and MeterID = @MeterId and ParameterID in @ParameterId order by ParameterID"; var chartDataset = ChartConnection.Query(queryFour, param: new { MeterId = meterId, ParameterId = parameterId, DateStart = dateStart, DateEnd = dateEnd }); foreach (var item in chartConnection) { string date = item.Day + ""; int v = int.Parse(item.Value); lstModel.Add(new SimpleReportViewModel { DimensionOne = date, Quantity = v }); } return(lstModel); } }
private void GenerateCodes_Click(object sender, RoutedEventArgs e) { if (this.ConnectionsCombo.SelectedItem == null || this.TablesCombo.SelectedItem == null) { MessageBox.Show("A connection string and table name must be selected!"); return; } if (EntitySingular.IsTrimmedEmpty()) { MessageBox.Show("Entity class identifier must be entered!"); return; } if (Permission.IsTrimmedEmpty()) { MessageBox.Show("Permission key must be entered!"); return; } string tableName = (string)this.TablesCombo.SelectedItem; try { EntityCodeGenerationModel rowModel; var conn = (GeneratorConfig.Connection) this.ConnectionsCombo.SelectedItem; using (var connection = SqlConnections.New(conn.ConnectionString, conn.ProviderName)) { connection.Open(); var table = (string)this.TablesCombo.SelectedItem; string tableSchema = null; if (table.IndexOf('.') > 0) { tableSchema = table.Substring(0, table.IndexOf('.')); table = table.Substring(table.IndexOf('.') + 1); } rowModel = RowGenerator.GenerateModel(connection, tableSchema, table, Module, ConnectionKey, EntitySingular, Permission, config); new EntityCodeGenerator(rowModel, config).Run(); MessageBox.Show("Code files for the selected table is generated!"); GenerateCodeButton.IsEnabled = false; } var cnn = this.ConnectionsCombo.SelectedItem as GeneratorConfig.Connection; var tableObj = cnn != null?cnn.Tables.FirstOrDefault(x => x.Tablename == tableName) : null; if (tableObj == null && cnn != null) { tableObj = new GeneratorConfig.Table(); tableObj.Tablename = tableName; cnn.Tables.Add(tableObj); } if (tableObj != null) { tableObj.Identifier = EntitySingular; tableObj.PermissionKey = Permission; tableObj.Module = Module; tableObj.ConnectionKey = ConnectionKey; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } config.Save(); }
static void Main(string[] args) { var assembly = Assembly.GetAssembly(typeof(Serene.Northwind.Entities.CategoryRow)); var rowClasses = assembly.GetTypes().Where(w => w.GetCustomAttribute <TableNameAttribute>() != null); using (var connection = SqlConnections.New(@"Data Source=(LocalDb)\MSSqlLocalDB; Initial Catalog=Serene_Northwind_v1; Integrated Security=True", "System.Data.SqlClient")) { connection.Open(); var schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType); foreach (var rowClass in rowClasses) { Row row = (Row)Activator.CreateInstance(rowClass); Console.WriteLine(row.Table); var tableName = row.Table; string schema = null; if (tableName.IndexOf('.') > 0) { schema = tableName.Substring(0, tableName.IndexOf('.')); tableName = tableName.Substring(tableName.IndexOf('.') + 1); } var rowFields = row.GetFields(); var dbFields = schemaProvider.GetFieldInfos(connection, schema ?? "dbo", tableName); for (int i = 0; i < row.FieldCount; i++) { Field rowfield = rowFields[i]; if (EntityFieldExtensions.IsTableField(rowfield)) { var dbField = dbFields.FirstOrDefault(f => f.FieldName == rowfield.Name); string strNull = rowfield.Flags.HasFlag(FieldFlags.NotNull) ? "NOT NULL" : "NULL"; if (dbField == null) { Console.WriteLine($"\t{rowfield.Type} {rowfield.Name} {strNull} \t\t no corresponding field in database!"); } else { string strTypeMismatch = rowfield.Type.ToString() == SchemaHelper.SqlTypeNameToFieldType(dbField.DataType, dbField.Size) ? "" : "datatype mismatch"; string strNullableMismatch = rowfield.Flags.HasFlag(FieldFlags.NotNull) == !dbField.IsNullable ? "" : "nullable mismatch"; Console.WriteLine($"\t{rowfield.Type} {rowfield.Name} {strNull}" + $"\t\t {strTypeMismatch}\t{strNullableMismatch}"); } } } Console.WriteLine(); } connection.Close(); } Console.ReadKey(); }
public void Run(string csproj, string[] args) { var projectDir = Path.GetDirectoryName(csproj); var outFile = GetOption(args, "o").TrimToNull(); var connectionKey = GetOption(args, "c").TrimToNull(); var table = GetOption(args, "t").TrimToNull(); var what = GetOption(args, "w").TrimToNull(); var module = GetOption(args, "m").TrimToNull(); var identifier = GetOption(args, "i").TrimToNull(); var permissionKey = GetOption(args, "p").TrimToNull(); if (identifier != null) { CodeFileHelper.Overwrite = true; } var config = GeneratorConfig.LoadFromFile(Path.Combine(projectDir, "sergen.json")); if (!string.IsNullOrEmpty(config.CustomTemplates)) { Templates.TemplatePath = Path.Combine(projectDir, config.CustomTemplates); } var connectionKeys = config.Connections .Where(x => !x.ConnectionString.IsEmptyOrNull()) .Select(x => x.Key).ToList(); var appSettingsFile = Path.Combine(projectDir, "appsettings.json"); AppSettingsFormat appSettings; if (File.Exists(appSettingsFile)) { appSettings = JSON.ParseTolerant <AppSettingsFormat>(File.ReadAllText(appSettingsFile).TrimToNull() ?? "{}"); } else { appSettings = new AppSettingsFormat(); } connectionKeys.AddRange(appSettings.Data.Keys); var appSettingsFile2 = Path.Combine(projectDir, "appsettings.machine.json"); if (File.Exists(appSettingsFile2)) { var appSettings2 = JSON.ParseTolerant <AppSettingsFormat>(File.ReadAllText(appSettingsFile2).TrimToNull() ?? "{}"); foreach (var pair in appSettings2.Data) { appSettings.Data[pair.Key] = pair.Value; } } connectionKeys.AddRange(appSettings.Data.Keys); connectionKeys = connectionKeys.Distinct(StringComparer.OrdinalIgnoreCase).OrderBy(x => x).ToList(); if (connectionKeys.Count == 0) { Console.Error.WriteLine("No connections in appsettings.json or sergen.json!"); Environment.Exit(1); } if (outFile == null && connectionKey == null) { Console.ForegroundColor = ConsoleColor.Cyan; Console.WriteLine("=== Table Code Generation ==="); Console.WriteLine(""); Console.ResetColor(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Available Connections:"); Console.ResetColor(); foreach (var x in connectionKeys) { Console.WriteLine(x); } Console.ResetColor(); Console.WriteLine(); } else if (connectionKey == null) { File.WriteAllText(outFile, JSON.Stringify(connectionKeys)); Environment.Exit(0); } string userInput = null; if (outFile == null && connectionKey == null) { userInput = connectionKeys.Count == 1 ? connectionKeys[0] : null; while (connectionKey == null || !connectionKeys.Contains(connectionKey, StringComparer.OrdinalIgnoreCase)) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Enter a Connection: ('!' to abort)"); Console.ForegroundColor = ConsoleColor.Yellow; connectionKey = Hinter.ReadHintedLine(connectionKeys, userInput: userInput); userInput = connectionKey; if (connectionKey == "!") { Console.ResetColor(); return; } } } userInput = connectionKey; connectionKey = connectionKeys.Find(x => string.Compare(x, userInput, StringComparison.OrdinalIgnoreCase) == 0); if (connectionKey == null) { Console.Error.WriteLine("Can't find connection with key: " + userInput + "!"); Environment.Exit(1); } if (outFile == null) { Console.ResetColor(); Console.WriteLine(); } var dataConnection = appSettings.Data.ContainsKey(connectionKey) ? appSettings.Data[connectionKey] : null; var confConnection = config.Connections.FirstOrDefault(x => string.Compare(x.Key, connectionKey, StringComparison.OrdinalIgnoreCase) == 0); var connectionString = dataConnection != null?dataConnection.ConnectionString.TrimToNull() : null; if (connectionString == null && confConnection != null) { connectionString = confConnection.ConnectionString.TrimToNull(); } var providerName = dataConnection != null?dataConnection.ProviderName.TrimToNull() : null; if (providerName == null && confConnection != null) { providerName = confConnection.ProviderName.TrimToNull(); } providerName = providerName ?? "System.Data.SqlClient"; #if !NET45 DbProviderFactories.RegisterFactory("System.Data.SqlClient", SqlClientFactory.Instance); DbProviderFactories.RegisterFactory("Microsoft.Data.Sqlite", Microsoft.Data.Sqlite.SqliteFactory.Instance); DbProviderFactories.RegisterFactory("Npgsql", Npgsql.NpgsqlFactory.Instance); DbProviderFactories.RegisterFactory("FirebirdSql.Data.FirebirdClient", FirebirdSql.Data.FirebirdClient.FirebirdClientFactory.Instance); DbProviderFactories.RegisterFactory("MySql.Data.MySqlClient", MySql.Data.MySqlClient.MySqlClientFactory.Instance); #endif if (connectionString.IndexOf("../../..") >= 0) { connectionString = connectionString.Replace("../../..", Path.GetDirectoryName(csproj)); } else if (connectionString.IndexOf(@"..\..\..\") >= 0) { connectionString = connectionString.Replace(@"..\..\..\", Path.GetDirectoryName(csproj)); } ISchemaProvider schemaProvider; List <TableName> tableNames; using (var connection = SqlConnections.New(connectionString, providerName)) { schemaProvider = SchemaHelper.GetSchemaProvider(connection.GetDialect().ServerType); tableNames = schemaProvider.GetTableNames(connection).ToList(); } var tables = tableNames.Select(x => x.Tablename).ToList(); if (outFile == null && table == null) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Available Tables:"); Console.ResetColor(); foreach (var x in tables) { Console.WriteLine(x); } } else if (table == null) { File.WriteAllText(outFile, JSON.Stringify(tableNames.Select(x => { var xct = confConnection == null ? null : confConnection.Tables.FirstOrDefault(z => string.Compare(z.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0); return(new { name = x.Tablename, module = xct == null || xct.Module.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(connectionKey) : xct.Module, permission = xct == null || xct.PermissionKey.IsTrimmedEmpty() ? "Administration:General" : xct.PermissionKey, identifier = xct == null || xct.Identifier.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(x.Table) : xct.Identifier, }); }))); Environment.Exit(0); } userInput = tables.Count == 1 ? tables[0] : null; if (userInput == null && schemaProvider.DefaultSchema != null && tables.Any(x => x.StartsWith(schemaProvider.DefaultSchema + "."))) { userInput = schemaProvider.DefaultSchema + "."; } if (outFile == null) { Console.WriteLine(); while (table == null || !tables.Contains(table, StringComparer.OrdinalIgnoreCase)) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Enter a Table: ('!' to abort)"); Console.ForegroundColor = ConsoleColor.Yellow; table = Hinter.ReadHintedLine(tables, userInput: userInput); userInput = table; if (table == "!") { Console.ResetColor(); return; } } } userInput = table; var tableName = tableNames.First(x => string.Compare(x.Tablename, userInput, StringComparison.OrdinalIgnoreCase) == 0); if (tableName == null) { Console.Error.WriteLine("Can't find table with name: " + userInput + "!"); Environment.Exit(1); } var confTable = confConnection == null ? null : confConnection.Tables.FirstOrDefault(x => string.Compare(x.Tablename, table, StringComparison.OrdinalIgnoreCase) == 0); if (module == null) { userInput = confTable == null || confTable.Module.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(connectionKey) : confTable.Module; Console.WriteLine(); while (module.IsTrimmedEmpty()) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Enter a Module name for table: ('!' to abort)"); Console.ForegroundColor = ConsoleColor.Yellow; module = Hinter.ReadHintedLine(new string[0], userInput: userInput); userInput = module; if (module == "!") { Console.ResetColor(); return; } } } if (identifier == null) { userInput = confTable == null || confTable.Identifier.IsEmptyOrNull() ? RowGenerator.ClassNameFromTableName(tableName.Table) : confTable.Identifier; Console.WriteLine(); while (identifier.IsTrimmedEmpty()) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Enter a class Identifier for table: ('!' to abort)"); Console.ForegroundColor = ConsoleColor.Yellow; identifier = Hinter.ReadHintedLine(new string[0], userInput: userInput); userInput = identifier; if (identifier == "!") { Console.ResetColor(); return; } } } if (permissionKey == null) { userInput = confTable == null || confTable.PermissionKey.IsTrimmedEmpty() ? "Administration:General" : confTable.PermissionKey; Console.WriteLine(); while (permissionKey.IsTrimmedEmpty()) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Enter a Permission Key for table: ('!' to abort)"); Console.ForegroundColor = ConsoleColor.Yellow; permissionKey = Hinter.ReadHintedLine(new string[0], userInput: userInput); userInput = permissionKey; if (permissionKey == "!") { Console.ResetColor(); return; } } } if (what == null) { Console.WriteLine(); userInput = "RSUC"; while (what.IsEmptyOrNull()) { Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("Choose What to Generate (R:Row, S:Repo+Svc, U=UI, C=Custom)"); Console.ForegroundColor = ConsoleColor.Yellow; what = Hinter.ReadHintedLine(new string[0], userInput: userInput); userInput = what; if (what == "!") { Console.ResetColor(); return; } } } config.GenerateRow = what.IndexOf("R", StringComparison.OrdinalIgnoreCase) >= 0; config.GenerateService = what.IndexOf("S", StringComparison.OrdinalIgnoreCase) >= 0; config.GenerateUI = what.IndexOf("U", StringComparison.OrdinalIgnoreCase) >= 0; config.GenerateCustom = what.IndexOf("C", StringComparison.OrdinalIgnoreCase) >= 0; Console.ResetColor(); Console.WriteLine(); if (confConnection == null) { confConnection = new GeneratorConfig.Connection { Key = connectionKey }; config.Connections.Add(confConnection); } if (confTable == null) { confTable = new GeneratorConfig.Table { Identifier = identifier, Module = module, PermissionKey = permissionKey, Tablename = tableName.Tablename }; confConnection.Tables.Add(confTable); } else { confTable.Identifier = identifier; confTable.Module = module; confTable.PermissionKey = permissionKey; } File.WriteAllText(Path.Combine(projectDir, "sergen.json"), config.SaveToJson()); using (var connection = SqlConnections.New(connectionString, providerName)) { connection.Open(); var rowModel = RowGenerator.GenerateModel(connection, tableName.Schema, tableName.Table, module, connectionKey, identifier, permissionKey, config); rowModel.AspNetCore = true; var kdiff3Paths = new[] { config.KDiff3Path }; CodeFileHelper.Kdiff3Path = kdiff3Paths.FirstOrDefault(File.Exists); CodeFileHelper.TSCPath = config.TSCPath ?? "tsc"; new EntityCodeGenerator(rowModel, config, csproj).Run(); } }
void GridArayuzleriYukle(Control ctrl) { DevExpress.XtraGrid.GridControl gc = new GridControl(); gc = ctrl as DevExpress.XtraGrid.GridControl; DevExpress.XtraGrid.Views.Grid.GridView gv = (DevExpress.XtraGrid.Views.Grid.GridView)gc.Views[0]; MemoryStream ms = cs.csGridLayout.GetLayout(Convert.ToInt32(frmKullaniciGiris.KullaniciID), this.Name, gv.Name, SqlConnections.GetBaglanti(), trGenel); if (ms.Length > 0) { gv.RestoreLayoutFromStream(ms); } }
public static void sendEMailThroughOUTLOOK(string mail,string persona , string ticket,int dia) { try { SqlConnections temp = new SqlConnections(); // Create the Outlook application. Random rand = new Random(); int unique = rand.Next(1,999999999); Outlook.Application oApp = new Outlook.Application(); Outlook.NameSpace ns = oApp.GetNamespace("MAPI"); Outlook.MAPIFolder f = ns.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox); System.Threading.Thread.Sleep(9000); // test Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem); oMsg.HTMLBody = "La persona : " + persona + " cuenta aun con una solicitud pendiente de aprobar<br/>" + "Favor de ingresar a la siguiente liga http://192.168.26.160/pendingApproval/?id=" +ticket+"&unique="+unique+" para aprobar o rechazar el ticket " + ticket +"<br/><b>Atencion : Una vez que actualize el ticket la liga dejara de funcionar es una liga unica. <b/>"; // string liga = "http://192.168.26.160/pendingApproval/?id="+ticket + "&unique=" + unique; //string query = "INSERT INTO ligas (WORKORDERID,link) VALUES ("+ticket+","+unique+")"; // temp.insertTemp(query); oMsg.Subject = "Pending Aproval Ticket: "+ticket; Outlook.Recipients oRecips = (Outlook.Recipients)oMsg.Recipients; Outlook.Recipient oRecip = (Outlook.Recipient)oRecips.Add(mail); oRecip.Resolve(); string query = "select count (*) FROM ligas WHERE WORKORDERID = "+ticket; int valor = temp.consultaDia(query); if (valor == 0) { query = "INSERT INTO ligas (WORKORDERID,LINK,nombre_status) VALUES (" + ticket + "," + unique + "," + dia + ")"; temp.insertTemp(query); oMsg.Send(); oRecip = null; oRecips = null; oMsg = null; oApp = null; Console.WriteLine("correo enviado"); }//SI esl query regresa 0 el ticket no existe en la tabla temporal por lo tannto se crea un nuevo ticket else { query = "select nombre_status FROM ligas WHERE WORKORDERID = "+ticket; valor = temp.consultaDia(query); if (dia != valor) { query = "UPDATE ligas SET nombre_status = " + dia + " WHERE workorderid = " + ticket; temp.insertTemp(query); oMsg.Send(); oRecip = null; oRecips = null; oMsg = null; oApp = null; Console.WriteLine("correo enviado"); } else { Console.WriteLine("El usuario ya recibio un correo el dia de hoy"); } }//si el query regresa diferente de 0 es porque el ticket ya existe en la tabla }//end of try block catch (Exception ex) { Console.WriteLine(ex); }//end of catch }
private bool ValidateFirstTimeUser(ref string username, string password) { var throttler = new Throttler("ValidateUser:"******"Error on directory first time authentication", ex, this.GetType()); return(false); } try { string salt = null; var hash = UserRepository.GenerateHash(password, ref salt); var displayName = entry.FirstName + " " + entry.LastName; var email = entry.Email.TrimToNull() ?? (username + "@yourdefaultdomain.com"); username = entry.Username.TrimToNull() ?? username; using (var connection = SqlConnections.NewFor <UserRow>()) using (var uow = new UnitOfWork(connection)) { var userId = (int)connection.InsertAndGetID(new UserRow { Username = username, Source = "ldap", DisplayName = displayName, Email = email, PasswordHash = hash, PasswordSalt = salt, IsActive = 1, InsertDate = DateTime.Now, InsertUserId = 1, LastDirectoryUpdate = DateTime.Now }); uow.Commit(); UserRetrieveService.RemoveCachedUser(userId, username); } return(true); } catch (Exception ex) { Log.Error("Error while importing directory user", ex, this.GetType()); return(false); } }
public Result <ServiceResponse> ResetPassword(ResetPasswordRequest request) { return(this.InTransaction("Default", uow => { request.CheckNotNull(); if (string.IsNullOrEmpty(request.Token)) { throw new ArgumentNullException("token"); } var bytes = HttpContext.RequestServices .GetDataProtector("ResetPassword").Unprotect(Convert.FromBase64String(request.Token)); int userId; using (var ms = new MemoryStream(bytes)) using (var br = new BinaryReader(ms)) { var dt = DateTime.FromBinary(br.ReadInt64()); if (dt < DateTime.UtcNow) { throw new ValidationError(Texts.Validation.InvalidResetToken); } userId = br.ReadInt32(); } UserRow user; using (var connection = SqlConnections.NewFor <UserRow>()) { user = connection.TryById <UserRow>(userId); if (user == null) { throw new ValidationError(Texts.Validation.InvalidResetToken); } } if (request.ConfirmPassword != request.NewPassword) { throw new ValidationError("PasswordConfirmMismatch", LocalText.Get("Validation.PasswordConfirm")); } request.NewPassword = UserRepository.ValidatePassword(user.Username, request.NewPassword, false); string salt = null; var hash = UserRepository.GenerateHash(request.NewPassword, ref salt); UserRepository.CheckPublicDemo(user.UserId); uow.Connection.UpdateById(new UserRow { UserId = user.UserId.Value, PasswordSalt = salt, PasswordHash = hash }); BatchGenerationUpdater.OnCommit(uow, UserRow.Fields.GenerationKey); return new ServiceResponse(); })); }
public JsonResult GetVisitsTasks(string start, string end) { var user = (UserDefinition)Authorization.UserDefinition; var startDate = DateTime.ParseExact(start, "yyyy-MM-dd", new CultureInfo("en-US"), DateTimeStyles.None); var endDate = DateTime.ParseExact(end, "yyyy-MM-dd", new CultureInfo("en-US"), DateTimeStyles.None); var cabinetIdActive = Request.Cookies["CabinetPreference"]; var model = new DashboardPageModel(); using (var connection = SqlConnections.NewFor <VisitsRow>()) { var visitFlds = VisitsRow.Fields.As("vis"); var patient = PatientsRow.Fields.As("ptn"); var visitType = VisitTypesRow.Fields.As("vstt"); var users = UserRow.Fields.As("assUsr"); var query = new SqlQuery() .From(visitFlds) .Select("*") .Where(~( new Criteria(visitFlds.StartDate) >= startDate & new Criteria(visitFlds.EndDate) <= endDate & new Criteria(visitFlds.CabinetId) == int.Parse(cabinetIdActive) )) .LeftJoin(users, visitFlds.AssignedUserId == users.UserId) .Select(users.DisplayName = visitFlds.AssignedUserName) .LeftJoin(patient, visitFlds.PatientId == patient.PatientId) .Select(patient.Name = visitFlds.PatientName, patient.NotifyOnChange = visitFlds.PatientNotifyOnChange) .LeftJoin(visitType, visitFlds.VisitTypeId == visitType.VisitTypeId) .Select(visitType.BackgroundColor = visitFlds.VisitTypeBackgroundColor, visitType.BorderColor = visitFlds.VisitTypeBorderColor) ; if (!Authorization.HasPermission(PermissionKeys.Tenants)) { query.Where(visitFlds.TenantId == user.TenantId); } var result = connection.Query <VisitsRow>(query); foreach (VisitsRow visit in result) { model.EventsList.Add(new Event { id = visit.VisitId ?? 0, patientId = visit.PatientId ?? 0, assignedToUser = visit.AssignedUserName, patientAutoEmailActive = visit.PatientNotifyOnChange ?? false, title = string.Join("\n", string.IsNullOrEmpty(visit.PatientName)?"* " + LocalText.Get("Db.PatientManagement.Visits.FreeForReservation") + " *": visit.PatientName , visit.Description), start = (visit.StartDate ?? DateTime.Now).ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz"), end = (visit.EndDate ?? DateTime.Now).ToString("yyyy-MM-ddTHH\\:mm\\:ss.fffffffzzz"), allDay = false, backgroundColor = visit.VisitTypeBackgroundColor, borderColor = visit.VisitTypeBorderColor }); } } return(Json(model.EventsList)); }
private void frmStokListesi_Load(object sender, EventArgs e) { try { layoutControlItem43.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; trGenel = SqlConnections.GetBaglanti().BeginTransaction(); Grubu = new clsTablolar.Stok.csStokGrup(SqlConnections.GetBaglanti(), trGenel, -1); AraGrubu = new clsTablolar.Stok.csStokAraGrup(SqlConnections.GetBaglanti(), trGenel, -1); //StokArama = new clsTablolar.Stok.csStokArama(); FiltreKriterleriniBindleHamisina(); //barkodoku.BarkoduOku(); txtStokAdi.Focus(); trGenel.Commit(); HemenAlKategoriYukle(); clsTablolar.HemenAl.csHemenAlUrunDurum HemenAlUrunDurumu = new clsTablolar.HemenAl.csHemenAlUrunDurum(); lkpHemanAlDurum.Properties.DataSource = HemenAlUrunDurumu.Dt_UrunDurumlari; lkpHemanAlDurum.Properties.DisplayMember = "DurumAdi"; lkpHemanAlDurum.Properties.ValueMember = "DurumKodu"; clsTablolar.csEnumDanDtVer enumdanVerHamisina = new csEnumDanDtVer(); lookUpEdit1.Properties.DataSource = enumdanVerHamisina.ToDataTable(typeof(clsTablolar.Stok.csStokArama.enumFotoOzellikleri)); lookUpEdit1.Properties.DisplayMember = "name"; lookUpEdit1.Properties.ValueMember = "value"; lookUpEdit1.EditValue = 1; //lookUpEdit1.Properties.PopulateColumns(); //lookUpEdit1.Properties.Columns[1].Visible = false; clsTablolar.Stok.csStokSayimGrubu SayimGrubu = new clsTablolar.Stok.csStokSayimGrubu(); lkpStokSayimGrubu.Properties.DataSource = SayimGrubu.SayimGrubuGetir(SqlConnections.GetBaglanti(), trGenel); lkpStokSayimGrubu.Properties.DisplayMember = "SayimAdi"; lkpStokSayimGrubu.Properties.ValueMember = "StokSayimGrubuID"; //checkedListBox_FiyatTanimlari.Text = clsTablolar.Ayarlar.csAyarlar.StokListeFiyatTanimlari; panelControl1.Select(); panelControl1.Focus(); panelControl1.Select(); //layoutControlGroup5.tabp //xtraTabPage1.Focus(); //xtraTabPage1.Select(); txtStokAdi.SelectAll(); txtStokAdi.Focus(); txtStokAdi.Select(); secilenKontrol = txtStokAdi; } catch (Exception hata) { trGenel.Rollback(); frmHataBildir frmHataBildir = new frmHataBildir(hata.Message, hata.StackTrace); frmHataBildir.ShowDialog(); } //txtStokKodu.FindForm(); txtStokAdi.Focus(); }