public List <graphassets> getseries(string ids, string begindate, string enddate) { string sql = "getpriceactionforassets"; List <graphassets> assets = null; try { if (thisConnection != null) { SqlCommand cmd = new SqlCommand(sql, thisConnection) { CommandType = CommandType.StoredProcedure }; SqlParameter pcustomerName = new SqlParameter("@assetids", SqlDbType.VarChar, 200) { Value = ids }; SqlParameter begindates = new SqlParameter("@begindate", SqlDbType.VarChar, 200) { Value = begindate }; SqlParameter enddates = new SqlParameter("@enddate", SqlDbType.VarChar, 200) { Value = enddate }; cmd.Parameters.Add(pcustomerName); cmd.Parameters.Add(begindates); cmd.Parameters.Add(enddates); assets = SQLHelpers.ExecuteDataFetch <graphassets>(cmd); return(assets); } else { return(null); } } catch (Exception ex) { throw ex; } }
public List <StandartComboBox> GetJurusan() { List <StandartComboBox> Result = new List <StandartComboBox>(); string Query = @"SELECT IdJurusan, Jurusan From TbJurusan"; DataTable dt = new DataTable(); dt = SQLHelpers.GetDataTable(Query); foreach (DataRow dr in dt.Rows) { Result.Add( new StandartComboBox { Value = Convert.ToString(dr["IdJurusan"]), Text = Convert.ToString(dr["Jurusan"]) }); } return(Result); }
public bool IsDataExist(string Id) { bool hasil = false; try { string Query = @"select * from TbJurusan where IdJurusan = '" + Id + "'"; DataTable dt = new DataTable(); dt = SQLHelpers.GetDataTable(Query); if (dt.Rows.Count > 0) { hasil = true; } return(hasil); } catch (Exception) { throw; } }
private bool CheckUsername() { var conn = SQLHelpers.GetConnection(); conn.Open(); var command = new SqlCommand("SELECT * FROM Bruger WHERE Brugernavn=@brugernavn", conn); command.Parameters.AddWithValue("@brugernavn", UserNameTextBox.Text); using (var reader = command.ExecuteReader()) { if (reader.Read()) { conn.Close(); return(false); } } return(true); }
public bool IsDataExist(String id) { bool hasil = false; try { string Query = @"SELECT * from TbJurusan WHERE IdJurusan = '" + id + "' "; DataTable dt = new DataTable(); dt = SQLHelpers.GetDataTable(Query); if (dt.Rows.Count > 0) { hasil = true; } return(hasil); } catch (Exception ex) { throw ex; } }
public List <mahasiswamodel> GetListMahasiswa() { try { List <mahasiswamodel> Result = new List <mahasiswamodel>(); string Query = @"SELECT m.NPM, m.Nama, m.JK, j.Jurusan, m.Alamat, Convert(varchar,m.TglLahir,101) TglLahir, m.Email FROM TbMahasiswa m LEFT JOIN Tbjurusan J on m.IdJurusan = J.IdJurusan"; DataTable dt = new DataTable(); dt = SQLHelpers.GetDataTable(Query); foreach (DataRow dr in dt.Rows) { Result.Add( new mahasiswamodel { NPM = Convert.ToString(dr["NPM"]), Nama = Convert.ToString(dr["Nama"]), JK = Convert.ToString(dr["JK"]), Jurusan = Convert.ToString(dr["Jurusan"]), Alamat = Convert.ToString(dr["Alamat"]), TglLahir = Convert.ToString(dr["TglLahir"]), Email = Convert.ToString(dr["Email"]) }); } return(Result); } catch (Exception) { throw; } }
public int UpdateMahasiswa(MahasiswaModel model) { int hasil = -1; try { string Query = @"Update TbMahasiswa SET Nama = '" + model.Nama + "', " + "JK = '" + model.JK + "', " + "IdJurusan = '" + model.IdJurusan + "', " + "Alamat = '" + model.Alamat + "', " + "TglLahir = '" + model.TglLahir + "', " + "Email = '" + model.Email + "' " + "Where NPM = '" + model.NPM + "'"; hasil = SQLHelpers.ExecQuery(Query); return(hasil); } catch (Exception ex) { throw ex; } }
private void loadgrid() { string sql = "getassetmonitor"; List <assetmonitor> assets = null; gridControl1.DataSource = null; try { if (thiconnect != null) { SqlCommand cmd = new SqlCommand(sql, thiconnect) { CommandType = CommandType.StoredProcedure }; SqlParameter pcustomerName = new SqlParameter("@assetids", SqlDbType.VarChar, 200) { Value = assetids }; SqlParameter begindates = new SqlParameter("@begin_date", SqlDbType.DateTime, 200) { Value = begin_date }; SqlParameter enddates = new SqlParameter("@end_date", SqlDbType.DateTime, 200) { Value = end_date }; cmd.Parameters.Add(pcustomerName); cmd.Parameters.Add(begindates); cmd.Parameters.Add(enddates); assets = SQLHelpers.ExecuteDataFetch <assetmonitor>(cmd); gridControl1.DataSource = assets; } } catch (Exception ex) { throw ex; } }
public Dog GetDogById(int id) { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @" SELECT Id, [Name], OwnerId, Breed, Notes, ImageUrl FROM Dog WHERE Id = @id"; cmd.Parameters.AddWithValue("@id", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { Dog dog = new Dog() { Id = reader.GetInt32(reader.GetOrdinal("Id")), Name = reader.GetString(reader.GetOrdinal("Name")), OwnerId = reader.GetInt32(reader.GetOrdinal("OwnerId")), Breed = reader.GetString(reader.GetOrdinal("Breed")), Notes = SQLHelpers.GetNullableString(reader, "Notes"), ImageUrl = SQLHelpers.GetNullableString(reader, "ImageUrl") }; reader.Close(); return(dog); } reader.Close(); return(null); } } }
public List <JurusanModel> GetListJurusanById(string id) { try { List <JurusanModel> Result = new List <JurusanModel>(); string Query = @"SELECT * FROM TbJurusan where IdJurusan = '" + id + "'"; DataTable dt = new DataTable(); dt = SQLHelpers.GetDataTable(Query); foreach (DataRow dr in dt.Rows) { Result.Add( new JurusanModel { idJurusan = Convert.ToString(dr["IdJurusan"]), jurusan = Convert.ToString(dr["Jurusan"]) }); } return(Result); } catch (Exception ex) { throw ex; } }
partial void OnCreated() { Connection.ConnectionString = SQLHelpers.GetConnectionStr(); }