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();
}
