/// <summary>
/// Lay Vung kenh theo ID
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public DMVung_GPSEntity GetVungKenh(int ID)
{
DMVung_GPSEntity vungKenh = new DMVung_GPSEntity();
if (g_sqlCon.State == ConnectionState.Closed)
{
g_sqlCon.Open();
}
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.Int)
};
parameters[0].Value = ID;
using (SqlDataReader sqldrVungKenh = SqlHelper.ExecuteReader(g_sqlCon, CommandType.StoredProcedure, "V3_DM_VUNG_GPS_GET_BY_ID", parameters))
{
if (sqldrVungKenh != null)
{
vungKenh.KenhVung = Convert.ToInt32(sqldrVungKenh["ID"]);
vungKenh.TenVungGPS = sqldrVungKenh["TenVungGPS"].ToString();
vungKenh.KenhVung = Convert.ToInt32(sqldrVungKenh["KenhVung"]);
vungKenh.KenhGop = Convert.ToInt32(sqldrVungKenh["KenhGop"]);
vungKenh.ToaDoVung = sqldrVungKenh["ToaDoVung"].ToString();
vungKenh.BanKinhTimXe = Convert.ToInt32(sqldrVungKenh["BanKinhTimXe"]);
}
}
// đóng kêt nối db
g_sqlCon.Close();
return(vungKenh);
}
/// <summary>
/// Cap nhat kenh vung
/// </summary>
/// <param name="DMVung_GPS"></param>
/// <returns></returns>
public bool Insert(DMVung_GPSEntity DMVung_GPS)
{
if (g_sqlCon.State == ConnectionState.Closed)
{
g_sqlCon.Open();
}
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@TenVungGPS", SqlDbType.NVarChar, 50),
new SqlParameter("@KenhVung", SqlDbType.Int),
new SqlParameter("@KenhGop", SqlDbType.Int),
new SqlParameter("@ToaDoVung", SqlDbType.VarChar, 5000),
new SqlParameter("@BanKinhTimXe", SqlDbType.Int),
new SqlParameter("@Output", SqlDbType.Bit)
};
parameters[0].Value = DMVung_GPS.TenVungGPS;
parameters[1].Value = DMVung_GPS.KenhVung;
parameters[2].Value = DMVung_GPS.KenhGop;
parameters[3].Value = DMVung_GPS.ToaDoVung;
parameters[4].Value = DMVung_GPS.BanKinhTimXe;
parameters[5].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(g_sqlCon, CommandType.StoredProcedure, "V3_DM_VUNG_GPS_INSERT", parameters);
g_sqlCon.Close();
return(Convert.ToBoolean(parameters[5].Value));
}
private void gridVungGPS_Click(object sender, EventArgs e)
{
if (gridVungGPS.SelectedItems.Count > 0)
{
isSelectedRow = true;
gDMVung_GPSEntity = (DMVung_GPSEntity)((GridEXSelectedItem)gridVungGPS.SelectedItems[0]).GetRow().DataRow;
FillDataToForm();
}
}
/// <summary>
/// Cap nhat kenh vung
/// </summary>
/// <param name="DMVung_GPS"></param>
/// <returns></returns>
public bool Insert(DMVung_GPSEntity DMVung_GPS)
{
return(new Taxi.Data.DM.DMVung_GPS().Insert(DMVung_GPS));
}
/// <summary>
/// Cap nhat kenh vung
/// </summary>
/// <param name="DMVung_GPS"></param>
/// <returns></returns>
public bool Update(DMVung_GPSEntity DMVung_GPS)
{
return(new Taxi.Data.DM.DMVung_GPS().Update(DMVung_GPS));
}
