public NV_Map_ChiTiet GetById(int id) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_Map_getByID", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int); pID.Value = id; myCommand.Parameters.Add(pID); DataTable dt; NV_Map_ChiTiet model = new NV_Map_ChiTiet(); myConnection.Open(); using (SqlDataAdapter mData = new SqlDataAdapter(myCommand)) { dt = new DataTable(); mData.Fill(dt); } if (dt != null && dt.Rows.Count > 0) { model = new NV_Map_ChiTiet(dt); } return(model); } } }
public bool update(NV_Map_ChiTiet model) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_Map_update", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int); pID.Value = model.ID; myCommand.Parameters.Add(pID); SqlParameter pDiSanID = new SqlParameter("@DiSanID", SqlDbType.Int); pDiSanID.Value = model.DiSanID; myCommand.Parameters.Add(pDiSanID); SqlParameter pDiaChi = new SqlParameter("@DiaChi", SqlDbType.NVarChar, 1000); pDiaChi.Value = model.DiaChi; myCommand.Parameters.Add(pDiaChi); SqlParameter pMoTa = new SqlParameter("@MoTa", SqlDbType.NText); pMoTa.Value = model.MoTa; myCommand.Parameters.Add(pMoTa); SqlParameter pLat = new SqlParameter("@Lat", SqlDbType.Float); pLat.Value = model.Lat; myCommand.Parameters.Add(pLat); SqlParameter pLng = new SqlParameter("@Lng", SqlDbType.Float); pLng.Value = model.Lng; myCommand.Parameters.Add(pLng); try { myConnection.Open(); myCommand.ExecuteNonQuery(); return(true); } catch { return(false); } } } }